Data Modelling In Power BI – From Zero To Hero

Trainer(s): Markus Ehrenmüeller-Jensen
Provider: DPS 2022 (Data Platform Summit)
Duration: 8 Hours
Subtitles: Yes
Price: USD 149.5

Abstract: You have collected your first experiences with Power BI and wondering why the performance of your reports is slow (even when working with a relatively small amount of source rows)? Maybe you are suffering from complicated DAX formulas (which can have their cause in non-optimal modelling)? Or you are just curious about what’s the secret behind the model view? In any case, this full-day workshop got you covered!

We will start with the very basic foundation and we will work step-by-step from concepts and practical examples to real world problems and how to solve them.

Modules:

  1. “Modelling 101” : Tables, Primary Keys, Foreign Keys, Normal forms, Dimensional modelling, Kimball, Inmon, Data Vault.
  2. “Modelling Options in Power BI” : Relationships, Cardinality, Cross-filter direction, Data Preparation with DAX, Data Preparation with Power Query.
  3. “Special Dimensions” : Time & Date, Role-playing dimensions, Hierarchies.
  4. “Real world examples “ : Budgeting, Localized data models, Composite models.