· beginner
Power BI Foundations
The parts of Power BI that decide whether a report is trusted: the data model underneath it, what filter context actually does to a measure, and why the total row is not the sum of the rows above it.
Written in house, from the work rather than from a syllabus. Every example is one we would use ourselves, and every quiz question explains why its answer is right.
What you’ll learn
- Shape data into a star schema, and say why one flat table is worse
- Choose between a measure and a calculated column for the right reason
- Explain filter context, and predict what a measure returns in a given cell
- Use CALCULATE to change what a measure is filtered by
- Build percentage and comparison measures that behave at the total row
- Keep a model small enough to stay fast, and know what makes it large
Before you start
- · Comfort with a spreadsheet and the idea of a table of records
- · No prior Power BI or DAX