Advanced Data Modelling in Power BI/ AAS
Links:
Sign up to our Meetup group https://www.meetup.com/hybrid-virtual...
Join our LinkedIn group / 12487. .
Follow us on Twitter / hybridvug
...and of course don't forget to subscribe to our channel, like the video, and hit the bell! It really helps us in our mission to produce free content for the masses.
Session Details:
While it is a good practice to model your data as a star schema, there are many challenges where you have to reach out to more advanced concepts. In this session, we will discuss many of these scenarios and how to overcome them, including:
• Multi-Fact model
• Many-to-many relationships
• Detached table
• Key-value-pair model
Speaker:
Markus Ehrenmüller-Jensen is a Microsoft Data Platform MVP and 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 at 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.
Host/s:
Mark Broadbent.
Mikael Wedham.
Originally recorded on 22nd September 2021.
Video Production: Mark Broadbent 3rd January 2022.
00:00 Introduction
04:20 Agenda
04:46 Multi-fact model
09:35 Demo 1
19:51 Detached table
23:38 Demo 2
32:43 Key-value-pair model
36:47 Demo 3
01:00:05 Take-aways and Summary
01:00:18 Questions