Learn to master dbt (Data Build Tool) and elevate your data engineering and analytics skills. From setting up your first dbt project to creating robust data pipelines with dbt Core and dbt Cloud, this course covers everything you need to transform, test, and manage your data efficiently. It features real-world exercises and hands-on examples to strengthen your data workflows.
What you will learn
- dbt Project Setup – Create and configure your dbt account, connect to your data warehouse, and load sample data.
- Models and Transformations – Define, structure, and organize your data transformations using dbt models.
- Testing and Quality – Write tests to ensure the accuracy and reliability of your data models.
- Materializations and Snapshots – Apply materialization techniques and capture historical data for analysis and auditing.
- Advanced Features – Use Jinja templating, custom macros, hooks, dbt analyses, and documentation to extend and automate your workflows.