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