Objectives

  • Understand the basic concepts of data modeling
  • Understand the consequences of data model design decisions
  • Understand the concepts of calculated columns and measures
  • Gain familiarity with standard DAX patterns and CALCULATE
  • Understand evaluation contexts and their impact on calculations

 

Agenda

  • Module 1: Data Modeling Basics and Power BI Desktop Internals
  • Module 2: Data Modeling Best Practices
  • Module 3: DAX Calculated Columns and Measures
  • Module 4: CALCULATE
  • Module 5: DAX Evaluation Contexts
  • Module 6: Advanced DAX Time Intelligence Functions
  • Module 7: DAX Best Practices