dbt Fundamentals
What is dbt?
dbt (data build tool) enables analytics engineers to transform data in their warehouses by simply writing select statements. dbt handles turning these select statements into tables and views.
dbt does the T in ELT (Extract, Load, Transform) processes – it doesn’t extract or load data, but it’s extremely good at transforming data that’s already loaded into your warehouse.
The role of dbt within a modern data stack is discussed in more detail here.
dbt also enables analysts to work more like software engineers, in line with the dbt Viewpoint.
Learn the Fundamentals of dbt including modeling, testing, documentation, and deployment.
Duration: 25-30hrs
Course Content
- Welcome to dbt Fundamentals
- Who is an analytics engineer?
- Set up dbt Cloud
- Models
- Tests
- Documentation
- Sources
- Deployment
- Jinja Primer
- Macros
- Packages
- Materializations
- Analyses and Seeds