Power BI Deep Dive: Master DAX, Data Models & Dynamic Reports

Level: Intermediate | Tags: DAX · Data modelling · Relationships

Course Description

Take your Power BI skills to the next level by mastering the engine beneath the visuals. This course focuses on complex data modelling (Star Schemas) and Data Analysis Expressions (DAX) to perform advanced calculations, time-intelligence comparisons, and dynamic filtering.

Learning Outcomes

  • Architect scalable and efficient Star Schema data models that optimize report performance.
  • Write complex DAX formulas to calculate Year-to-Date (YTD), moving averages, and dynamic variance analysis.
  • Understand filter context and row context to troubleshoot and build highly dynamic report interactions.

Course Outline

  • Module 1: Advanced Data Modelling: Star Schemas, Fact Tables, and Dimension Tables
  • Module 2: Demystifying DAX: Syntax, Functions, and Calculated Columns vs. Measures
  • Module 3: Mastering Filter Context: The CALCULATE function and its modifiers
  • Module 4: Time Intelligence: Building dynamic calendar tables and period-over-period comparisons

Contact Us