Data Warehouse — Tutorials, examples and exercises

Insights / Tutorials / Data Warehouse

11 tutorials

Learn how to implement an SCD Type 1 dimension in a Data Warehouse with a single SQL MERGE: overwrite changed attribute…

4 min 16 Jul 2026

Learn how to create a factless fact table in a Data Warehouse: set the grain, create the table, load the data and find …

5 min 12 Jul 2026

Learn how to create and use surrogate keys in a Data Warehouse with T-SQL: IDENTITY, the dimension table, the fact tabl…

4 min 08 Jul 2026

Learn how to model a snowflake schema in a Data Warehouse: normalize dimensions into linked tables and adjust your SQL …

4 min 07 Jul 2026

Learn how to create a bridge table in a data warehouse to model many-to-many relationships and sum values with a weight…

4 min 06 Jul 2026

Learn how to create a junk dimension in a Data Warehouse: combine several flags into one dimension with SQL, step by st…

4 min 05 Jul 2026

Learn how to reuse a single date dimension in several roles inside a Data Warehouse using SQL JOINs and views, keeping …

4 min 04 Jul 2026

Learn how to create a fact table in a Data Warehouse step by step: define the grain, link it to the dimensions, and wri…

4 min 04 Jul 2026

Learn how to create a date dimension (calendar table) in a Data Warehouse with SQL: table, load script and best practic…

4 min 04 Jul 2026

Learn how to implement an SCD Type 2 dimension in a Data Warehouse with simple SQL and keep the full history of changes…

4 min 04 Jul 2026

Learn to model a data warehouse with a star schema: fact table, dimensions and surrogate keys, with SQL examples.

2 min 20 Jun 2023