How to Create a Conformed Dimension in Data Modeling (Kimball) How to create a Conformed Dimension in Data Modeling (Kimball): step-by-step to align dimensions across fact tables and… 5 min 08 Aug 2026
How to create an incremental snapshot in Data Modeling (Kimball) How to create an incremental snapshot in Data Modeling (Kimball): practical step-by-step to capture periodic states and… 4 min 30 Jul 2026
Accumulating snapshot in Kimball Data Modeling: practical step Accumulating snapshot in Data Modeling (Kimball): practical example to create an accumulating fact table and update the… 4 min 19 Jul 2026
How to Build a Periodic Snapshot Fact Table in SQL Learn how to build a periodic snapshot fact table in SQL: define the grain, create the table, run an idempotent daily l… 5 min 13 Jul 2026
How to create a factless fact table in a data warehouse Learn how to build a factless fact table in SQL to count events and reveal absences in your data warehouse, with a clea… 4 min 11 Jul 2026
Bridge table: model many-to-many in a star schema Learn how to build a bridge table in SQL to solve many-to-many relationships in a star schema and sum values without do… 4 min 08 Jul 2026
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
