Markus Ehrenmüller-Jensen is the founder and business intelligence architect of Savory Data. He works as a project leader, trainer & consultant for data engineering, data science and data visualization since 1994. He 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, MCSE Business Intelligence, and MCT. Markus speaks regularly on international conferences (eg. PASS Summit, Power Platform World Tour, Intelligent Cloud Conference, SQL Saturdays, SQL Days, SQL PASS Austria, ...) and writes articles for well-known journals. In 2013 he co-founded SQL PASS Austria, in 2015 Power Platform Usergroup Austria and he organizes SQL Saturdays in Austria since 2014.
His topics will be:
"Model Your Data Like a Star in Power BI"
Power BI is a self-service Business Intelligence tool, which does a great job in hiding complexity and technology away from the user. But when it comes to performance and even correct numbers, one should spend some time in finding the right way of modelling the tables and how they are related to each other. In this talk we spend quality time on doing exactly that. You will get answers to questions like: Why should you care about the data model? What kind of relations are available? How do they influence performance? Why is redundancy (not) a bad thing?
After this session you will understand how to model data like a star.
00:00 - Intro to Markus
00:55 - Power BI Desktop - why people don't understand data modelling
2:38 - Agenda
4:00 - Relationships
8:22 - Relationships demo
13:29 - Denormalizing
17:55 - Single table
18:19 - Star and Snowflake Schema
21:52 - Star Schema
22:56 - Snowflake Schema
24:15 - Star Schema vs Snowflake Schema
24:38 - Schema Performance comparison
26:19 - Power Query
28:40 - Data Dimension
33:22 - Role Playing
34:56 - Role Playing vs Multiple Relationships
35:35 - Take-aways
37:15 - Dealing with Multiple Fact Tables in the Data Model (budget vs actuals)
44:15 - One date table or multiple date tables?
Негізгі бет PBIMCR - Markus Ehrenmueller Jensen - Model your data like a star
No video
Пікірлер