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
How to model a data warehouse with a star schema Learn to model a data warehouse with a star schema: fact table, dimensions and surrogate keys, with SQL examples. 2 min 20 Jun 2023
