dbt training

I’ve delivered multiple dbt trainings and workshops, both in-person and online. I can help you get started with dbt, or help you take your dbt skills to the next level.

Previous customers: Data Makers Fest

While working for Dataroots , I delivered dbt trainings to customers like Ennatuurlijk, Immoscoop, CLdN, Private Bank Delen, …

Format

The training is hands-on and can be tailored to your needs. The minimum duration is half a day, but I recommend a full day for the best experience. This can be extended to the complete training which takes 2 days. Depending on the skills and experiences of the audience, the duration can still vary. The training can be delivered in-person or online.

I strongly believe the hands-on approach is the best way to learn and to memorize and understand the concepts. I will provide a lot of exercises and examples, and I will be available to help you with your questions.

Platform

The training can be done on your environment, or I can provide a demo environment. I can work on any of the following data warehouses / data platforms:

• Azure SQL, SQL Server
• Azure Synapse
• BigQuery
• Databricks
• DuckDB, MotherDuck
• Microsoft Fabric
• PostgreSQL
• Snowflake
• Starburst

The training can be done with dbt Cloud or dbt Core. I can also help you set up your dbt Cloud environment.

Topics

The training uses the popular dbt Jaffle Shop example so that you can easily find more information about it online.

The topics include:

• introduction to what/why of dbt
• dbt Core installation / dbt Cloud setup
• dbt models, sources, seeds
• Jinja templating
• writing and using macros
• documentation
• data tests and unit tests
• debugging
• overview and usage of popular dbt packages
• snapshots
• incremental models
• exposures, analyses, metrics
• building your own dbt packages
• Python models