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

Report, Data and Model Views

Learn how to use the main views in Power BI Desktop to design reports, inspect loaded data, and manage relationships between tables. Understand how each view contributes to building reliable and meaningful business reports.

1. Introduction to Power BI Views

Power BI Desktop provides different views for working with reports and data. Each view has a specific purpose. Understanding these views helps you work efficiently and choose the correct workspace for each task.

Report View is used to design report pages, Table View is used to inspect loaded data, and Model View is used to understand relationships between tables.

Beginner Example

Samadhan is preparing a monthly sales report. He needs to create a sales chart, inspect the imported transaction records, and connect the Sales table to the Products table.

He uses Report View to create the chart, Table View to inspect the sales records, and Model View to check the relationship between the two tables.

Remember: These views serve different purposes. Knowing when to use each view makes report development easier and helps you identify data and modeling problems.

2. Overview of the Three Main Views

The following illustration summarizes the purpose of Report View, Table View, and Model View in Power BI Desktop.

Report View Design Reports Charts, tables, and cards Page layout and formatting Table View ID Product Sales 101 Laptop 45000 102 Monitor 30000 Inspect Data Rows and columns Data values and types Model View Products ProductID Sales ProductID Manage Model Table relationships

Visual 1: The purpose of the three main Power BI Desktop views.

3. Report View

Report View is the primary workspace for creating report pages. It allows you to display business information using visual elements such as charts, tables, cards, maps, and slicers.

Common Tasks in Report View

  • Create charts to compare sales, products, and regions.
  • Add cards to display important values.
  • Insert slicers to filter report data.
  • Arrange and resize visuals on report pages.
  • Format titles, labels, backgrounds, and visual elements.
  • Test whether visuals respond correctly to filters.

Example: Sales Performance Report

Pradnya wants to prepare a report showing total sales, monthly sales trends, and sales by product. She can use cards for totals, a line chart for monthly trends, and a bar chart for product comparisons.

Steps to Create a Visual

  1. Open Power BI Desktop and load a dataset.
  2. Select Report View.
  3. Choose an appropriate visual type.
  4. Add the required fields to the visual.
  5. Format the visual and arrange it on the page.
  6. Verify that the visual displays the expected result.
Tip: Select a visual that matches the business question. A line chart is useful for trends over time, while a bar chart is often useful for comparing categories.

4. Table View

Table View allows you to inspect the rows and columns of tables loaded into the Power BI data model. It helps you review values, check column names, and verify that data has loaded as expected.

Example: Sales Data Table

OrderID Product Region Quantity Sales
1001 Laptop North 2 90000
1002 Monitor South 3 45000
1003 Keyboard West 5 10000

In this example, each row represents a sales record. The columns describe the order, product, region, quantity, and sales amount.

What Can You Inspect?

  • Column names and data types.
  • Loaded rows and data values.
  • Unexpected blank or missing values.
  • Results after data preparation.
  • Calculated columns and their values.
Important: Table View helps inspect the data loaded into the model. Use Power Query Editor for most data transformation tasks, such as removing duplicates, changing data types, and replacing values.

5. Understanding Table Data

Before creating a report, review the data to confirm that the expected columns and values are available. This helps identify problems before they affect report calculations.

Inspecting a Sales Table OrderID Product Quantity Sales 1001 Laptop 2 90000 1002 Monitor 3 Check value 1003 Keyboard 5 10000 Verify unexpected values against the original data source.

Visual 2: Inspect table values and investigate unexpected data.

Best practice: Do not assume that an unusual value is incorrect. Compare it with the source data and confirm the appropriate correction before changing it.

6. Model View

Model View displays the tables in the data model and the relationships between them. Relationships allow Power BI to connect related records and apply filters across tables.

Important Relationship Concepts

Concept Description Example
One-to-many (1:*) One record on one side can relate to multiple records on the other side. One product can appear in many sales transactions.
Key column A column used to identify or match related records. ProductID in the Products and Sales tables.
Active relationship The relationship used by default for relevant filtering and calculations. An active relationship between Products and Sales.
Filter direction Defines how filters propagate between related tables. A product selection filters the related sales records.

Example: Products and Sales

The Products table contains ProductID, ProductName, and Category. The Sales table contains OrderID, ProductID, Quantity, and SalesAmount.

Connecting the tables through ProductID allows a report to summarize sales by product or category without storing all product details in every sales record.

7. Example of a Data Model

A common reporting model contains a central transaction table and related dimension tables. This design is often called a star schema when dimension tables connect to a central fact table.

Sales Table SalesID ProductID CustomerID DateID and Amount Products ProductID Product Category Customers CustomerID Customer Name Date Table DateID, Month, Year Dimension tables describe the sales transactions Relationships should use appropriate matching keys.

Visual 3: A simplified star-schema-style data model.

Steps to Inspect Relationships

  1. Open Model View in Power BI Desktop.
  2. Locate the relevant tables.
  3. Inspect the relationship lines between tables.
  4. Check the columns used for each relationship.
  5. Verify relationship cardinality and filter direction.
  6. Test the model using appropriate report visuals.
Important: For a one-to-many relationship, the key on the one-side must contain unique values. Incorrect relationships can cause unexpected totals or filtering behavior.

8. Comparing the Three Views

Use the task you want to complete to decide which view to open. The following table provides a quick reference.

Task Recommended View Purpose
Create a bar chart Report View Create and format report visuals.
Display total sales in a card Report View Present a key business measure.
Inspect loaded rows Table View Review table data and values.
Review a calculated column Table View Inspect the calculated results.
Connect Products and Sales Model View Manage table relationships.
Check relationship cardinality Model View Understand how records relate.

9. Choosing the Correct View

The following decision guide can help beginners select the correct view for a task.

What do you want to accomplish? Create a report? Report View Inspect data? Table View Check relationships? Model View Design and format visuals and pages Review rows, columns, and values Inspect model structure and table connections

Visual 4: A quick guide for selecting the appropriate view.

10. Practical Exercise

Samiksha has imported a dataset containing Products, Customers, and Sales tables. Complete the following tasks using Power BI Desktop.

Exercise Checklist

  • Open Report View and create a chart showing sales by product.
  • Add a card displaying total sales.
  • Open Table View and inspect the Sales table.
  • Check the column names and data types.
  • Open Model View and inspect the Products-to-Sales relationship.
  • Verify the relationship key and cardinality.
  • Save the report as SalesPractice.pbix.

Practice Questions

  1. Which view is used to design report pages?
  2. Which view allows you to inspect loaded rows and columns?
  3. Which view is used to inspect table relationships?
  4. Why are relationships important in a data model?
  5. What should you check before creating a one-to-many relationship?
  6. Which view would you use to create a sales chart?
  7. Why should you verify data values before publishing a report?
Show Suggested Answers
  1. Report View.
  2. Table View.
  3. Model View.
  4. Relationships connect related tables and support filtering and analysis.
  5. Check that the key on the one-side contains unique values and that the columns have compatible data types.
  6. Report View.
  7. To identify data issues and confirm that the report displays reliable results.

11. Common Beginner Mistakes

Mistake 1: Using the Wrong View

Solution: Use Report View for report design, Table View for inspecting data, and Model View for examining relationships.

Mistake 2: Ignoring Data Quality

Solution: Review unexpected values, missing data, column types, and source records before trusting the report.

Mistake 3: Creating Incorrect Relationships

Solution: Check matching columns, key uniqueness, and relationship cardinality.

Mistake 4: Choosing Visuals Without a Purpose

Solution: Select visuals that answer a specific business question.

Mistake 5: Skipping Validation

Solution: Compare report totals with trusted source data and test filters before sharing.

Summary

In this lesson, you learned how the three main Power BI Desktop views support different tasks. Report View is used to design reports, Table View is used to inspect loaded data, and Model View is used to understand relationships between tables.

Choosing the correct view helps you organize your data, identify potential problems, create meaningful visuals, and build reliable reports.