Let's Improve the Tabular Model by Combining Queries
summary
Shows concrete Power Query steps to reduce model bloat and fix referential problems: append monthly files into one sales fact using Append as New, merge geography into customers to convert snowflake to star, add an index from catalog and replace text keys in the fact table to create reliable joins, and use an anti-left join to list projects present only in catalog or only in sales. Demos include type detection, column expansion, removing duplicates, and the resulting tables that work in a star schema.
AI-written summary · about
chapters (5)
- 0:00Start
- 1:58Identify Model Entities and Attributes
- 8:20Detect Data Type
- 13:12Remove Duplicates
- 19:17Conclusion
related talks
51mData modeling for experts with Power BI
41mThe Unified Star Schema
53mHailing Frequencies: Analysis Services Terms and Concepts
34mDimensional Data Modeling in the Modern Era
18mDemystifying Data Modeling
47mRoche's Maxim of Data Transformation - By Example
50mStar Schema ALL the things! But why?
49mModern T SQL for Better Performance