dbt (Data Build Tool)

Transform data in the warehouse using software engineering best practices. Master the Analytics Engineering workflow with dbt Core.

dbt (data build tool) has created a new role: the Analytics Engineer. This course teaches you to transform data *inside* your warehouse using SQL and Jinja templating. You will learn to build modular data models, document your data automatically, and write tests to ensure data quality. We cover the shift from ETL (Extract-Transform-Load) to ELT, version control for data models, and deploying dbt projects in production. This is the industry standard for modern data transformation.

✅ 100% Free & Lifetime Access

⏱️ 5-Minute Lessons (Bite-sized learning)

🚀 21-Lesson Path (Independent modules)

📱 Mobile Friendly (Learn anywhere)

Analytics Eng

Start Learning

Secure Enrollment via SSL

Complete Course Syllabus

1

The ELT Workflow

Why transformation happens in the warehouse now.
2

dbt Fundamentals

Models, sources, refs, and the DAG (Directed Acyclic Graph).
3

Testing & Docs

Writing data tests and generating documentation sites.
4

Jinja Templating

Using loops and macros to write powerful SQL generators.
5

Deployment

Scheduling jobs and managing environments (Dev vs Prod).

Estimated completion time: 21 lessons • Self-paced learning • Lifetime access

Career Outlook

Estimated Salary

$110k - $150k

Career Paths

Analytics Engineer $110k-$160k

Data Engineer $120k-$170k

BI Architect $115k-$150k

What You Will Learn

Build modular data transformation pipelines using SQL and dbt

Implement software engineering practices like testing and version control for data

Automate documentation generation for data lineage and dictionaries

Use Jinja templating to write DRY (Don't Repeat Yourself) SQL code

Deploy dbt projects to production using CI/CD workflows

Skills You Will Gain

dbt Core Analytics Engineering Jinja Templating SQL Modeling Data Testing

Who Is This For

Data Analysts

Data Engineers

BI Developers

Prerequisites

Strong SQL

Git Basics