The Unified Star Schema
summary
A single central and lightly populated Pini Bridge table carries foreign keys and connectors so multiple fact tables and shared dimensions answer many queries without rebuilding models; demo shows Tableau wired to an AdventureWorks USS schema and produces what previously required five separate models — five reports in one model. Claims 80–90% of common BI joins become automatic, notes performance limits for huge datasets but offers just‑in‑time bridge generation and moving measures to the bridge; real deployments report meaningful time savings.
AI-written summary · about
chapters (7)
- 0:00UniFi star schema intro
- 2:30Data analytics limits today
- 11:24Traditional star schema issues
- 18:23UniFi star schema concept
- 24:18Live demo in Tableau
- 30:44UniFi schema limits & future
- 34:23Q&A performance & use
related talks
16mGood Data Modeling & Effective Communication in Power BI
50mStar Schema ALL the things! But why?
34mDimensional Data Modeling in the Modern Era
50mGathering Requirements for your Star Schema
20mLet's Improve the Tabular Model by Combining Queries
35mData Vault in Business Intelligence
26mFrom datasets to tables in a multitenant data lake
01h 00mBuilding an Effective Data Warehouse Architecture