Course 8 of 11

dbt & Analytics Engineering

Models, Tests, Docs, and more.

Yiga AI

Intermediate en

Intermediate · Course · 4 weeks at 5 hrs/week

Duration: 4 weeks
Effort: 5 hrs/week
Lessons: 20
Hands-on exercises: 20
Projects: 1
Language: en

What you’ll learn

Skills you can put to work.

Data Engineering Foundations

Advanced SQL for Engineers

Python for Data Engineering

Data Warehousing

Syllabus

Every module, step by step.

4 modules · 25 lessons · 17 hours · 1 graded project

1000 minutes of guided lesson time.

Module 1 · 6 lessons · 3.7 hoursModelsModule 1 of 4 in dbt & Analytics Engineering.

Overview and set-up
Overview and set-up — Models in dbt & Analytics Engineering.
Lesson
40 min
Core concepts
Core concepts — Models in dbt & Analytics Engineering.
Lesson · Locked
40 min
Worked example
Worked example — Models in dbt & Analytics Engineering.
Lesson · Locked
40 min
Hands-on practice
Hands-on practice — Models in dbt & Analytics Engineering.
Lesson · Locked
40 min
Common pitfalls
Common pitfalls — Models in dbt & Analytics Engineering.
Lesson · Locked
40 min
Module quiz: Models
Check what you learned in Models before moving on.
Quiz · Locked
20 min

Module 2 · 6 lessons · 3.7 hours LockedTestsModule 2 of 4 in dbt & Analytics Engineering.

Overview and set-up
Overview and set-up — Tests in dbt & Analytics Engineering.
Lesson · Locked
40 min
Core concepts
Core concepts — Tests in dbt & Analytics Engineering.
Lesson · Locked
40 min
Worked example
Worked example — Tests in dbt & Analytics Engineering.
Lesson · Locked
40 min
Hands-on practice
Hands-on practice — Tests in dbt & Analytics Engineering.
Lesson · Locked
40 min
Common pitfalls
Common pitfalls — Tests in dbt & Analytics Engineering.
Lesson · Locked
40 min
Module quiz: Tests
Check what you learned in Tests before moving on.
Quiz · Locked
20 min

Module 3 · 6 lessons · 3.7 hours LockedDocsModule 3 of 4 in dbt & Analytics Engineering.

Overview and set-up
Overview and set-up — Docs in dbt & Analytics Engineering.
Lesson · Locked
40 min
Core concepts
Core concepts — Docs in dbt & Analytics Engineering.
Lesson · Locked
40 min
Worked example
Worked example — Docs in dbt & Analytics Engineering.
Lesson · Locked
40 min
Hands-on practice
Hands-on practice — Docs in dbt & Analytics Engineering.
Lesson · Locked
40 min
Common pitfalls
Common pitfalls — Docs in dbt & Analytics Engineering.
Lesson · Locked
40 min
Module quiz: Docs
Check what you learned in Docs before moving on.
Quiz · Locked
20 min

Module 4 · 7 lessons · 5.7 hours LockedLineageModule 4 of 4 in dbt & Analytics Engineering.

Overview and set-up
Overview and set-up — Lineage in dbt & Analytics Engineering.
Lesson · Locked
40 min
Core concepts
Core concepts — Lineage in dbt & Analytics Engineering.
Lesson · Locked
40 min
Worked example
Worked example — Lineage in dbt & Analytics Engineering.
Lesson · Locked
40 min
Hands-on practice
Hands-on practice — Lineage in dbt & Analytics Engineering.
Lesson · Locked
40 min
Common pitfalls
Common pitfalls — Lineage in dbt & Analytics Engineering.
Lesson · Locked
40 min
Module quiz: Lineage
Check what you learned in Lineage before moving on.
Quiz · Locked
20 min
Graded project: dbt & Analytics Engineering
Apply everything from dbt & Analytics Engineering in one graded, portfolio-ready build.
Graded project · Locked
120 min

Applied learning project

Make the learning visible.

Use Graded project: dbt & Analytics Engineering to apply this course to a practical challenge. You’ll finish with a clear solution and the reasoning behind your choices.

Apply the course’s core skillMake and explain practical decisionsCreate evidence you can share

Your instructor

Joel N.

Career readiness

Connects technical learning to portfolios, interviews and confident career moves.

“The track removed the uncertainty. I knew what to learn next and what to show employers.”
Amina Hassan
Career switcher, Dar es Salaam

Continue with

Your next best step.

Following the order of Data Engineer.

See the full chain

Next lesson

Overview and set-up

dbt & Analytics Engineering

40 min · Resume

Course 9 in the track

Workflow Orchestration with Airflow

DAGs, Operators, Scheduling, and more.

Intermediate · Course · 4 weeks at 5 hrs/week

Course 10 in the track

Data Warehousing

Dimensional modelling, BigQuery/Snowflake, Loading, and more.

Intermediate · Course · 4 weeks at 5 hrs/week

Course 11 in the track

Project: National Health Data Pipeline

Ingest, Transform, Warehouse, and more.

Advanced · Course · 4 weeks at 5 hrs/week

Learner reviews

What learners say.

Write a review

Loading reviews…

Previous courseBig Data with Spark Next courseWorkflow Orchestration with Airflow

Keep going

Other courses in this track.

View full track

Data

16 lessons · 14h · Advanced

Streaming with Kafka

Topics, Producers/consumers, Stream processing, and more.

Data

20 lessons · 16.7h · Intermediate

Cloud Data Platforms

AWS/GCP/Azure services, Storage, IAM, and more.

Data

16 lessons · 14h · Intermediate

Python for Data Engineering

ETL scripts, Logging, Testing, and more.

Advanced SQL for Engineers cover illustration

Data

21 lessons · 16.8h · Intermediate

Advanced SQL for Engineers

Performance, Partitioning, Transactions, and more.