How to Create a Junk Dimension in a Data Warehouse Learn how to create a junk dimension in your data warehouse to group low-cardinality flags, simplify the fact table, an… 4 min 07 Jul 2026
Role-Playing Dimensions in a Star Schema: Step by Step Learn how to build role-playing dimensions in a star schema: reuse a single date dimension in multiple roles, with SQL … 4 min 06 Jul 2026
How to Create a Date Dimension in SQL: Step by Step Learn how to build a date dimension in SQL for your data warehouse: table design, date generation, and linking it to th… 4 min 05 Jul 2026
One Big Table vs star schema: when to use each approach OBT (One Big Table) is popular in modern tools like dbt and Fabric. Understand the real trade-offs against the star sch… 1 min 01 Jun 2026
Modeling for Power BI: optimize the semantic model with VertiPaq The Power BI VertiPaq engine has unique compression and scan characteristics. Learn to model specifically to get maximu… 2 min 06 Jan 2026
Data Vault 2.0: flexibility and traceability for modern warehouses Data Vault 2.0 is an alternative to Kimball for environments with unstable data sources and demanding audit requirement… 1 min 13 Aug 2025
Slowly Changing Dimensions Type 2: preserving history in the data warehouse SCD Type 2 keeps the full history of changes in dimensions. Learn how to implement it in SQL Server and how to choose b… 2 min 20 Mar 2025
Kimball dimensional modeling: a practical guide to facts and dimensions The Kimball methodology for data warehousing defines fact and dimension patterns that have stood the test of time. Lear… 2 min 25 Oct 2024
