DP-203: 29 - Introduction to dimensional modeling

Greetings, data engineers! Achievement unlocked - we've successfully loaded data into the raw layer of our data lake. What's our next step? Should we construct reports directly from this data? If not, what are the reasons behind this decision?

Join me for the 29th episode of my free DP-203 course, where I'll address these queries and delve into the fundamentals of dimensional modeling.

Enjoy!

▬▬▬▬▬▬ IMPORTANT LINKS ▬▬▬▬▬▬
My LinkedIn profile:   / piotr-tybulewicz-81a8793  
GitHub with my drawings: https://github.com/TybulOnAzure/DP-203
Why star schema is your best choice in Power BI:    • Why star schema is your best choice i...  

▬▬▬▬▬▬ MEMBERSHIP ▬▬▬▬▬▬
Join this channel to get access to perks:
   / @tybulonazure  

▬▬▬▬▬▬ CHAPTERS ▬▬▬▬▬▬
00:00 Introduction
00:22 Common BI flow revisited
04:00 Data issues
18:50 Where does it fit?
24:17 Facts and dimensions
36:43 2nd example
43:36 Snowflake
51:33 Facts vs dimensions
54:37 Summary