dbt Training - 2 Days to Learn Data Transformation

Learn to transform your data with dbt, the leading tool in the Modern Data Stack.

You'll start by understanding the evolution of data architectures and the difference between ETL and ELT. You'll install dbt, create your first project and connect it to your data sources.

Then you'll learn to build structured data models, choose the right materialization options (table, view, incremental) and organize your metadata with tags. You'll discover how to reference your sources and manage dependencies between models.

You'll explore advanced features: seeds to initialize reference data, snapshots to track history and manage slowly changing dimensions, Jinja macros and variables to automate your transformations.

Finally, you'll implement automated tests to ensure data quality, document your models with lineage, and discover packages from the dbt community.

Hands-on training with 60% labs.

The achievement of training objectives is evaluated at multiple levels to ensure quality:

• Continuous Knowledge Assessment : Verification of knowledge throughout the training via participatory methods (quizzes, practical exercises, case studies) under instructor supervision.
• Progress Measurement : Comparative self-assessment system including an initial diagnostic to determine the starting level, followed by a final evaluation to validate skills development.
• Quality Evaluation : End-of-session satisfaction questionnaire to measure the relevance and effectiveness of the training as perceived by participants.