Description

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 half-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

This workshop will be demo only, therefore laptops are not necessary. The materials will be shared with participants afterwards so they can do the exercises at their own pace.

Speaker

Markus Ehrenmüller-Jensen

BI Architect, Microsoft MVP and Founder of Savory Data

Markus Ehrenmüller-Jensen is an educated software-engineer, graduated business educator and professor for databases and project engineering at HTL Leonding (technical college) and certified as MCSE Data Platform and MCSE Business Intelligence. Markus speaks regularly on international conferences (eg. SQL PASS Summit, SQLBits London, Power Platform Worldtour, SQL Saturdays, SQL Days, SQL PASS Austria, ...) and writes articles for well-known journals. In 2013 he co-founded SQL PASS Austria and in 2016 Power Platform Usergroup Austria (both were merged into Data Community Austria in 2021) and organizes Data Community Austria (fka. SQL Saturdays & Data Saturdays) in Vienna since 2014. For his technical leadership in the community he was awarded repeatedly as a Microsoft Data Platform MVP since 2017.