Log in Start learning

Module 4

Power BI and Power BI Service

Model data as a star schema, write correct DAX, design dashboards people trust, and operate them in the Service.

Difficulty:All beginner intermediate advanced expert

Data Modeling

Facts, dimensions, relationships and date tables.

Star schema modeling

✓Power BI Desktop, Power Query and the star schemaGet data into Power BI, shape it in Power Query, and model it as a star schema with correct keys, cardinality, filter direction and a date table.Intermediate60 min

DAX

Measures, evaluation context and time intelligence.

DAX fundamentals

✓DAX fundamentals — measures, CALCULATE, iterators and RELATEDWrite the measures every report needs, understand calculated columns vs measures, and use CALCULATE, FILTER, SUMX, COUNTROWS, DISTINCTCOUNT, ALL and RELATED correctly.Intermediate70 min

Evaluation context

✓Row context, filter context, context transition and time intelligenceThe mental model behind every DAX result — and the time-intelligence measures (YTD, prior year, rolling periods) built on it.Advanced70 min

Report and Dashboard Design

KPI design, layout, interactivity and performance.

Dashboard design

✓KPI and dashboard design, interactivity, performance and Power BI ServiceDesign reports people trust and use, add purposeful interactivity, keep them fast, and operate them in the Power BI Service — workspaces, refresh, gateways, permissions and maintenance.Intermediate70 min