Summary
Keywords
Full Transcript
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: https://www.linkedin.com/in/piotr-tybulewicz-81a8793/ GitHub with my drawings: https://github.com/TybulOnAzure/DP-203 Why star schema is your best choice in Power BI: https://www.youtube.com/watch?v=KBqRC6JWy9A ▬▬▬▬▬▬ MEMBERSHIP ▬▬▬▬▬▬ Join this channel to get access to perks: https://www.youtube.com/channel/UCLnXq-Fr-6rAsCitq9nYiGg/join ▬▬▬▬▬▬ 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
Continue this lesson in the app
Install CourseHive on Android or iOS to keep learning while you move.
