Let's define Entities and attributes for tabular models in 20 minutes.
summary
Shows how to convert messy denormalized tables into useful tabular entities in 20 minutes by using Power Query steps: create a star schema via SQL joins or query merges, build a miscellany table with one index column (reference → remove other columns → remove duplicates → add index), and derive three classification attributes by aggregating min(date), count(rows) and sum(quantity) to produce three distinct values for product level. The process uses no code and yields a lean, usable model.
AI-written summary · about
chapters (8)
- 0:00Introduction
- 1:13Snowflake vs star schema
- 3:42Flat tables in star schema
- 6:39Misc table from flat data
- 11:03Multiple data sources
- 13:43Power Query for missing attributes
- 17:24Final design and performance
- 19:00Q&A
related talks
59mSelf-Service Data Modeling
54mData Visualization with Power View and the Tabular Model
34mDimensional Data Modeling in the Modern Era
01h 13mDiscover, Acquire, and Transform Your Data with Power Query
27mActivity schema data modeling using a single table
01h 04mBest Practices for Collecting and Analyzing Data with Power Query and Excel
02h 12mOptimizing your Power Pivot models using Power Query
45mRebooting your SME Data Analysis Strategy