How to audit loads in a Data Warehouse: step by step
How to audit loads in a Data Warehouse to record successes, failures and performance metrics. Practical example with SQ…
4 min
11 Aug 2026
Inventory snapshot in Data Warehouse: step by step
How to create an inventory snapshot in a Data Warehouse to record daily balances and speed up reporting. Practical exam…
3 min
26 Jul 2026
How to implement SCD Type 1 in a Data Warehouse
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
How to create a factless fact table in a Data Warehouse
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
How to Create and Use Surrogate Keys in a Data Warehouse
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
How to model a snowflake schema in a Data Warehouse
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
How to create a bridge table in a Data Warehouse
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
How to create a junk dimension in a Data Warehouse
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
How to use a role-playing dimension in a Data Warehouse
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
How to create a fact table in a Data Warehouse
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
How to create a date dimension in a Data Warehouse
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
How to Implement SCD Type 2 in a Data Warehouse
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