Data Visualization using Power BI · Lesson 3 of 3

Data Visualization using Power BI

Build a clear semantic model, write measures, and design interactive Power BI reports.

Lesson

1. Introduction

Power BI connects data preparation, semantic modeling, calculations, and interactive reporting. A well-designed model gives every visual a consistent meaning and helps users move from an overview to a relevant detail without changing the definition of a measure.

2. Core concepts

A star schema separates fact rows from descriptive dimensions. Relationships define how filters travel; measures calculate in the current filter context, while calculated columns are evaluated row by row during model processing. DAX should express business definitions, not conceal unclear grain.

3. Topics covered in this module

Power Query import and transformation, data types, and refresh
Fact and dimension tables, relationships, cardinality, and date tables
DAX measures, filter context, CALCULATE, and time intelligence
Cards, tables, slicers, drill-through, bookmarks, accessibility, and publishing

4. Syntax and how to read it

Total Sales = SUM(Sales[Amount])
Order Count = DISTINCTCOUNT(Sales[OrderID])
Average Order Value = DIVIDE([Total Sales], [Order Count])

DAX measures recalculate under report filters. DIVIDE handles a zero denominator more safely than ordinary division.

5. Practical workflow

Define the fact grain, identify dimensions and keys, validate relationships, then add one measure at a time. Reconcile a total against the source before adding interactive visuals.

6. Common mistakes

Creating ambiguous many-to-many relationships without understanding their filter behavior.
Using a calculated column where a measure is needed to respond to report filters.

7. Best practices

Use a marked date table and explicit measures with business-friendly names.
Test visuals with filters and reconcile key totals against trusted source queries.

8. Practice task

Write a DAX measure for average revenue per distinct order.

9. One possible solution

Average Revenue per Order = DIVIDE([Total Sales], DISTINCTCOUNT(Sales[OrderID])). Validate that the Sales table has the intended row grain.

10. Summary

Build a clear semantic model, write measures, and design interactive Power BI reports. Use a marked date table and explicit measures with business-friendly names. Test visuals with filters and reconcile key totals against trusted source queries.

11. What comes next

The next module, Tableau for Data Analytics, builds on this foundation and applies it to a new part of the analytics workflow.

Visual guide

A reliable Data Visualization using Power BI workflow

Step 01 Frame
Define the question, input scope, and intended output.
Step 02 Work
Apply the method and validate assumptions as you go.
Step 03 Check
Compare results with known cases and communicate limitations.

Code examples

Create a year-to-date measure

TEXT

Sales YTD = TOTALYTD([Total Sales], 'Date'[Date])

Expected output

Calculates sales from the start of the year through the current date context.

Count unique customers