Micro Free Course — 100% Free Learning
All lessons in this module are free to learn. Sign in with Google to save your progress.
Enterprise Data Modeling & Star Schema
Kimball dimensional modeling in VertiPaq tabular models. Learn Star Schemas, surrogate keys, role-playing dates, and eliminating bi-directional cross-filtering.
Module Content
Why Power BI Loves a Star Schema: Facts, Dimensions & Cardinality
Why the VertiPaq columnar database requires Star Schemas; relationship cardinalities and avoiding wide single tables.
Dimensional Modeling in Tabular Engines: Relationships, Grain & Filter Traps
Deep-dive textbook guide on Kimball Star Schemas, grain declaration, snowflake anti-patterns, and bi-directional cross-filtering hazards.
Role-Playing Dimensions & Multiple Dates with USERELATIONSHIP
Managing multiple dates (OrderDate vs ShipDate) using a single canonical date dimension and active/inactive relationships in DAX.
Quiz: Cardinality, Relationships & Star Schema Design
10 scenario-based psychometric questions evaluating dimensional modeling, surrogate keys, relationship direction, and SCDs.
Milestone Project 1: Enterprise E-Commerce Star Schema Transformation
Refactor a messy 28-column un-normalized flat file into an enterprise Star Schema model deliverable as a PBIP Git repository.