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