Learn how to use dbt to build custom data models, scale a data warehouse, and develop production-ready data layers.
Do you want to learn how to build advanced data models within a data warehouse and become more like a data engineer?
What you’ll learn
- How to setup dbt.
- How to create models in dbt.
- How to use jinga, variables and table references to build models quickly.
- How to push models back into a data warehouse.
- How to use dbt docs to create documentation on the models that have been developed.
Course Content
- Introduction to dbt –> 9 lectures • 2hr 54min.
Requirements
Do you want to learn how to build advanced data models within a data warehouse and become more like a data engineer?
The Introduction to dbt: Data Modeling for Analysts course will reach you the fundamentals of the dbt platform and walk you through the exact steps needed to turn raw data into powerful business-ready datasets for analyses and dashboards.
The course covers the following topics:
- Getting started with dbt –> How to set up dbt, connect it to your data warehouse and code repository solution.
- Building your first data models in dbt –> How to navigate the IDE and start writing SQL-based data models.
- How to leverage jinga, variables and other advanced funtionality within dbt.
- How to work with Github, set up jobs in dbt, leverage dbt docs and seeds, and more.
At the end of the course you will find a 10 question quiz to help you test your knowledge.
The course moves at a slow to medium pace allowing you to take in the key concepts and get to know the fundamentals of dbt. Go through the videos in order and build on your knowledge through each lesson.
This 3 hour course will give you the knowledge you need to significantly enhance a data warehouse and provide massive value to your employer or clients.