Master Power BI From Scratch

Learn Power BI fundamentals, data sources, data transformation, data modeling, DAX, visualizations, reports, and dashboards through structured practical lessons.

COURSE SYLLABUS
1. Power BI Introduction
Introduction to Power BI Power BI Desktop and Service Power BI Workflow Power BI Terminology Power BI Workspace Overview
2. Power BI Installation and Interface
Power BI Installation Power BI Desktop Interface Report, Data and Model Views Power BI File Management Power BI Settings and Options
3. Power BI Data Sources
Excel and CSV Data Sources Text and Folder Data Sources Database Data Sources Web and Online Data Sources Data Source Credentials and Refresh
4. Power BI Data Transformation
Power Query Introduction Data Types and Column Operations Merge and Append Queries Split, Group and Pivot Columns Power Query Applied Steps
5. Power BI Data Cleaning
Missing and Null Values Remove Duplicates and Errors Text and Date Cleaning Replace and Fill Values Data Quality Validation
6. Power BI Data Modeling
Data Modeling Fundamentals Create Table Relationships Cardinality and Filter Direction Star Schema and Dimension Tables Date Tables and Model Optimization
7. DAX
DAX Introduction and Syntax DAX Aggregation Functions DAX Logical and Conditional Functions DAX Filter and Iterator Functions DAX Date and Time Intelligence
8. Power BI Calculations
Calculated Columns Measures and Implicit Measures Row Context and Filter Context Quick Measures and KPI Time-Based Business Calculations
9. Power BI Visualizations
Basic Power BI Charts Pie, Donut and Treemap Charts Cards, Tables and Matrices Maps and Geographic Visuals Advanced and Custom Visuals
10. Power BI Filters and Slicers
Filter Types and Filter Pane Slicers and Sync Slicers Drill Down and Drill Through Cross-Filtering and Highlighting Bookmarks and Buttons
11. Power BI Reports and Dashboards
Report Page Layout and Design Multi-Page Reports Dashboard Creation and Tiles Executive and Business Reports Report Usability and Accessibility
12. Power BI Formatting and Interactivity
Themes and Color Formatting Conditional Formatting Tooltips and Report Page Tooltips Visual Interactions and Edit Interactions Mobile Layout and Responsive Reports
13. Power BI Publishing and Sharing
Publish Reports to Service Workspaces and Apps Scheduled Refresh and Gateway Sharing and Permissions Row-Level Security and Deployment
14. Power BI Projects and Assessment
Sales Dashboard Project Student Performance Project Data Cleaning and Modeling Assignment DAX and Visualization Assessment Final Power BI Project and Assessment

Power BI Desktop Interface

In this lesson, you will explore the Power BI Desktop interface and learn how its main areas help you import data, prepare tables, build data models, create report visuals, and organize your report pages.

1. Learning Objectives

By the end of this lesson, you will be able to:

  • Identify the main areas of the Power BI Desktop interface.
  • Understand the purpose of the Ribbon and its common commands.
  • Distinguish between Report View, Table View, and Model View.
  • Recognize the report canvas and explain how it is used.
  • Understand the Data, Visualizations, and Filters panes.
  • Create a basic report layout and save a Power BI project file.

2. What Is the Power BI Desktop Interface?

The Power BI Desktop interface is the main workspace where you connect to data sources, prepare data, create relationships between tables, build calculations, and design interactive reports.

When you open Power BI Desktop, you will see several interface areas. Their exact positions and available options may vary by version and by which panes are currently visible.

Example: A Student Fees Report

Samadhan has an Excel file containing Student Name, Course, City, and Fees columns. He wants to create a report showing the number of students in each course and the fees collected.

He can use the Ribbon to connect to the file, the Data pane to locate fields, the Visualizations pane to select charts, and the report canvas to arrange the finished visuals.

3. Main Areas of the Power BI Desktop Screen

The following diagram is a simplified illustration of the interface. Your installed version may show different icons, pane names, or positions.

Power BI Desktop Ribbon Home | Insert | Modeling | View Views Report Canvas Chart Visual Table Visual Visualizations Visual options Data pane ▸ Students □ Student Name □ Course □ Fees □ City Page tabs and status area
Figure 1: A simplified layout of the Power BI Desktop interface.

4. Understanding the Ribbon

The Ribbon appears near the top of the application. It contains tabs and commands for common tasks such as connecting to data, refreshing data, inserting report elements, managing calculations, and adjusting views.

Tab or Area Purpose Example
Home Provides common data and report commands. Get Data, Refresh, and Transform Data options.
Insert Adds elements to a report. Adding a text box or a supported report element.
Modeling Provides tools related to the data model and calculations. Creating measures or calculated columns and managing relationships.
View Helps manage the report layout and display options. Showing or hiding available panes and adjusting layout options.
Tip: The available tabs and commands may vary depending on your Power BI Desktop version, the selected view, and the item currently selected.

5. Report View, Table View, and Model View

Power BI Desktop provides different views for different tasks. Understanding their purposes will help you work more efficiently.

Report View Build reports Charts and tables Table View Name Course Fees SamikshaExcel3000 OmkarPower BI4500 NehaExcel3000 Inspect table data Rows and columns Model View Students StudentID Courses CourseID Manage relationships Tables and connections
Figure 2: The three main views and their typical purposes.

Report View

Report View is where you design report pages and arrange charts, tables, cards, slicers, and other visuals on the canvas.

Table View

Table View lets you inspect rows and columns in loaded model tables. It is useful for checking the data available in the model. Many data cleaning and transformation tasks are performed in Power Query Editor.

Model View

Model View displays tables and their relationships. Correct relationships help Power BI filter related tables and calculate results accurately.

6. What Is the Report Canvas?

The report canvas is the main page area where you place and arrange visuals. Think of it as a digital presentation page that communicates important information through charts, tables, and other report elements.

Common Elements on a Report Canvas

  • Bar and column charts for comparing values.
  • Line charts for showing changes over time.
  • Tables and matrices for displaying detailed information.
  • Card visuals for highlighting key numbers.
  • Slicers for interactive filtering.
  • Text boxes and shapes for titles, labels, and layout support.

For example, Omkar could create a report page containing a card for total students, a bar chart for students by course, and a table listing student details.

7. Understanding the Data and Visualizations Panes

Data Pane ▾ Students Student Name Course Fees City Locate available fields. Visualizations Pane Choose a suitable visual Configure fields and formatting Options depend on the selected visual
Figure 3: Locate fields in the Data pane and configure visuals using the available visual options.

Data Pane

The Data pane lists the tables and fields available in the loaded data model. You can select fields or drag them into a visual, depending on the current interface and visual type.

Visualizations Pane

The Visualizations pane lets you choose a visual type and configure the selected visual. The available controls depend on the selected visual and the Power BI Desktop version.

Tip: Understand the data first, then select a suitable visual. A pie chart is not the best choice for every type of data.

8. Introduction to the Filters Pane

Filters limit the data displayed in a report. Depending on the filter type, a filter can affect an individual visual, the current report page, or the report.

Example: Filtering by Course

Pradnya has a Students table containing Excel, Power BI, and Advanced Excel courses. If she wants to focus on Power BI students, she can apply a suitable filter to the Course field.

  • Visual-level filter: Limits the data shown in one visual.
  • Page-level filter: Applies to visuals on the current report page.
  • Report-level filter: Applies across the report as configured.
Filters and slicers are related, but they are not the same interface element. Slicers are visible interactive controls placed on a report canvas, while filters are managed through the Filters pane.

9. Saving a Report and Basic Navigation

How to Save a Power BI Report

  1. Open the report in Power BI Desktop.
  2. Locate Save or Save As from the File menu or available save controls.
  3. Enter a meaningful file name, such as CIIT_Practice_Report.pbix.
  4. Choose an appropriate folder for your work.
  5. Save the file and confirm that the save operation completes.

Power BI Desktop reports commonly use the .pbix file extension. Available save options may depend on the version and workflow.

Useful Habits for Beginners

  • Use clear and meaningful report names.
  • Save your work regularly.
  • Avoid modifying original source files without permission.
  • Keep backups in an approved location.
  • Use clear page names, such as Overview, Course Analysis, and Fees Analysis.

10. A Simple Report-Building Workflow

1. Get Data Excel / CSV or other source 2. Prepare Check data and columns 3. Model Tables and relationships 4. Visualize Charts and tables 5. Save Each step helps make the report more reliable and understandable. High-level workflow; data preparation and modeling are covered in later lessons.
Figure 4: A high-level workflow from connecting to data to saving the report.

11. Classroom Practical Activity

Activity: Explore the Interface

At CIIT TRANING INSTITUTE, Samiksha, Neha, and Omkar can complete this activity using a practice dataset provided by the instructor.

  1. Open Power BI Desktop.
  2. Locate the Home tab and other available Ribbon tabs.
  3. Identify Report View and the available table and model views.
  4. Load the practice dataset provided by the instructor.
  5. Locate the table and its columns in the Data pane.
  6. Add a simple table visual and select the relevant fields.
  7. Save the report as CIIT_Interface_Practice.pbix.

Practice Questions

  1. What is the main purpose of the Power BI Desktop interface?
  2. Why does the Ribbon contain tabs and commands?
  3. What is the difference between Report View and Model View?
  4. What is the report canvas used for?
  5. What information can you find in the Data pane?
  6. How does the Visualizations pane help when creating a report?
  7. Why is it important to save a report as a PBIX file?

Summary

In this lesson, you explored the main areas of Power BI Desktop, including the Ribbon, report canvas, Data pane, Visualizations pane, Filters pane, and the main views.

Report View is used to design reports, Table View helps you inspect loaded table data, and Model View helps you understand relationships between tables. The Data and Visualizations panes help you select fields and configure visuals.