Track

Business Intelligence

The warehouse stores the numbers; the semantic model decides what they mean. This track covers the layer between the two: how to model warehouse tables for Power BI, how to write measures that stay correct as the model grows, and how to treat the model as code that can be reviewed, tested and documented.

10 chapters ~3 hours Power BI · DAX · Power Query · PBIP · PowerShell Level: intermediate → advanced

Tutorials

Tutorial · Semantic modelling

Power BI Semantic Modelling: From Warehouse Tables to Trusted Measures

A finance P&L model built end to end on AdventureWorksDW2022: star schema, a 4-4-5 fiscal calendar, a layered measure table, currency and security patterns, the model in git, generated measure documentation, and every number reconciled with SQL.

How to read the diagrams

Colour / mark	Meaning
PBIBlue	The Power BI semantic model: tables, relationships, measures
DWOrange	The data warehouse and its source queries
DEVTeal	Engineering tooling: git, scripts, generated documentation
—Grey arrows	Data flow, or a relationship from the many side to the one side

Use ⤢ Full screen on any diagram to see it at full size. On a phone, scroll the diagram sideways.