Good Data Modeling & Effective Communication in Power BI
summary
Advocates a star schema with concrete rules: use a central fact table (or multiple complementary facts) and noun dimensions, avoid fact-to-fact relationships, and separate date and time dimensions. Distinguishes transactional fact table (one line per event), accumulating snapshot (process stages with multiple date columns) and periodic snapshot (regular point-in-time rows like bank statements). Gives sales, HR and inventory examples to show when each model makes queries simple, calculations feasible and reports smaller and faster.
AI-written summary · about
chapters (5)
related talks
51mData modeling for experts with Power BI
34mDimensional Data Modeling in the Modern Era
41mThe Unified Star Schema
01h 00mBuilding an Effective Data Warehouse Architecture
01h 01mModern Data Warehousing Strategy
19mTimespan Fact Tables
43mScaling Data Stacks: How To Build a Great Data Model
50mGathering Requirements for your Star Schema