What is dbt (data build tool), how does it work, and why should you use it? Koen Verbeeck covers everything you need to know in this series of guides and tutorials on dbt (data build tool).

Koen Verbeeck in General Analytics

Scripting Dimension Tables with dbt Macros: Type 1 and Type 2 SCD Patterns for Data Warehouses

Building dimension tables with dbt macros – Type 1 (overwriting changes) and Type 2 (preserving history with effective dates) slowly…

16 July 2025 10 min read 1

Koen Verbeeck in General Analytics

Loading a Date Dimension in Microsoft Fabric Warehouse with dbt Macros: Complete Tutorial with Generated Calendar Table

Building a date dimension table in Microsoft Fabric Warehouse using dbt macros – generating date rows with dbt’s sequence utilities,…

23 April 2025 8 min read

Koen Verbeeck in General Analytics

Loading Models from Source Data with dbt

The data transformation tool dbt (data build tool) has become more and more popular over the past years. It focuses…

20 January 2025 8 min read

Koen Verbeeck in General Analytics

A gentle introduction to dbt

In a typical data warehouse project, data is loaded, transformed and stored into a data store using an ETL (extract…

10 December 2024 12 min read 11