Data Modeling in Power BI:From Zero to Hero
About the Session
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
About the Speaker
Markus Ehrenmueller-Jensen is the founder of Savory Data, with a career spanning project leadership, data engineering, and business intelligence architecture since 1994. He holds degrees in software engineering and business education and serves as a professor of databases and project engineering at HTL Leonding, a technical college. He is also certified in PL-300 (Power BI Data Analyst), DP-203 (Azure Data Engineer Associate Certification), DP-600 (Fabric Analytics Engineer Associate), and DP-700 (Fabric Data Engineer Associate).
Markus actively contributes to the global data community, speaking regularly at international conferences such as SQL Bits in London, Power BI Next Step in Copenhagen, Data Saturdays throughout Europe, and SQL Days. He co-founded SQL PASS Austria in 2013 and the Power Platform User Group Austria in 2016; both organizations merged in 2021 to form Data Community Austria. Since 2014, he has organized Data Community Austria Day in Vienna, fostering knowledge sharing among data professionals. In recognition of his technical leadership and community involvement, Markus has been honored as a Microsoft Data Platform Most Valuable Professional (MVP) since 2017.
In addition to his speaking engagements, Markus contributes articles to reputable journals and has authored the book "Data Modeling with Microsoft Power BI," published in June 2024.
Workshop day overview and information: Workshop Day (English) Workshop nap (magyar)