DBT Analytics Engineering

33-Day DBT Analytics Engineering Batch : Real engineering thinking. Not tutorials. Not copy-paste projects. Covers 14 topics from dbt basics to Data Mesh, Semantic Models, and a Senior-level Capstone Project.

Curriculum / Modules to add (14 topics):

Day 1–2

Introduction to dbt

Account setup + first model running

Day 3–4

Data Modeling (SCD, ERD)

Complete ERD with SCD Type-2 design

Day 5–6

dbt Project Setup + Sources

dbt configured + freshness checks

Day 7–9

Models (5 materializations)

Day 10

Snapshots

Snapshot showing SCD Type-2 rows

Day 11–12

Jinja, Macros & Packages

Reusable macros + surrogate_key

Day 13

Hooks

Audit logging pattern

Day 14–15

Tests

Full test coverage on mart

Day 16

Documentation

Fully documented mart with doc blocks

Day 17–18

dbt in Production + CI/CD

GitHub Actions CI pipeline

Day 19–20

Data Mesh

Cross-project public model + contract

Day 21–22

Semantic Models + MetricFlow

Metrics queried via CLI

Day 23–26

Industry Standard Coding + AI

AI-powered dbt workflow

Day 27–30

Capstone Project

Senior-level portfolio project