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
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