Factored
Analytics dbt Boosting Program
A hands-on program to master dbt fundamentals, advanced features, and modern data transformation best practices.
About This Course
The Analytics dbt Boosting Program is designed to rapidly upskill Analytics Engineers, Data Analysts, and anyone working with modern data stacks. Through a combination of structured learning, hands-on labs, and guided best practices, participants will learn how to use dbt to build scalable, maintainable, and production-ready data transformation pipelines.
Beyond core dbt training, the program emphasizes real-world engineering skills. Students will deploy a dbt project end-to-end, integrate SQLfluff for automated formatting, apply CI/CD principles using GitHub Actions or pre-commit hooks, and learn how to evaluate project quality using dbt packages like dbt_project_evaluator.
By the end of the program, participants will be able to:
-
Build reliable and well-tested transformation pipelines
-
Adopt scalable project structure and engineering conventions
-
Implement dbt CI/CD workflows
-
Deliver analytics-ready datasets that support business decision-making
This course is ideal for analysts transitioning into analytics engineering and engineers seeking to level up their dbt expertise.
Requirements
-
Basic knowledge of SQL
-
Familiarity with git and Python environments (optional but helpful)
-
Access to a cloud data warehouse (Postgres, Snowflake, BigQuery, or DuckDB)
-
Ability to install dbt locally (dbt Core)
-
Recommended: Prior experience with BI or data modeling