Premium event

Advanced Data Modelling with PowerBI

27. Mai 2021 - 9:00 bis 17:00

André Schmid


This course was developed by the Microsoft Power BI Team. It focusses on Modelling techniques and DAX, the modelling language used in Power BI. By the end of this course, you will be able to use DAX to create calculations in a Power BI Desktop data model. After this training you will be able to:

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

The course is broken down into 7 Modules with presentations, discussions and lab exercises:

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

Prerequisites: Attendees should be familiar with basic Power BI Report design techniques and have attended some introductory training, such as the Dashboard in a Day session.

Language: English or German, depending on attendees. During Break-Out Sessions our Trainers will communicate in your preferred language.

Register now!