Yiga AI

Course 10 of 11

Data Warehousing

Dimensional modelling, BigQuery/Snowflake, Loading, 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.

Sign in and enrol to unlock every lesson. The first lesson is open as a preview.

Module 1 · 6 lessons · 3.7 hoursDimensional modellingModule 1 of 4 in Data Warehousing.

  1. Overview and set-up

    Overview and set-up — Dimensional modelling in Data Warehousing.

    Lesson

    40 min

  2. Core concepts

    Core concepts — Dimensional modelling in Data Warehousing.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Dimensional modelling in Data Warehousing.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Dimensional modelling in Data Warehousing.

    Lesson · Locked

    40 min

  5. Common pitfalls

    Common pitfalls — Dimensional modelling in Data Warehousing.

    Lesson · Locked

    40 min

  6. Module quiz: Dimensional modelling

    Check what you learned in Dimensional modelling before moving on.

    Quiz · Locked

    20 min
Module 2 · 6 lessons · 3.7 hours LockedBigQuery/SnowflakeModule 2 of 4 in Data Warehousing.

  1. Overview and set-up

    Overview and set-up — BigQuery/Snowflake in Data Warehousing.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — BigQuery/Snowflake in Data Warehousing.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — BigQuery/Snowflake in Data Warehousing.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — BigQuery/Snowflake in Data Warehousing.

    Lesson · Locked

    40 min

  5. Common pitfalls

    Common pitfalls — BigQuery/Snowflake in Data Warehousing.

    Lesson · Locked

    40 min

  6. Module quiz: BigQuery/Snowflake

    Check what you learned in BigQuery/Snowflake before moving on.

    Quiz · Locked

    20 min
Module 3 · 6 lessons · 3.7 hours LockedLoadingModule 3 of 4 in Data Warehousing.

  1. Overview and set-up

    Overview and set-up — Loading in Data Warehousing.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Loading in Data Warehousing.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Loading in Data Warehousing.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Loading in Data Warehousing.

    Lesson · Locked

    40 min

  5. Common pitfalls

    Common pitfalls — Loading in Data Warehousing.

    Lesson · Locked

    40 min

  6. Module quiz: Loading

    Check what you learned in Loading before moving on.

    Quiz · Locked

    20 min
Module 4 · 7 lessons · 5.7 hours LockedCost controlModule 4 of 4 in Data Warehousing.

  1. Overview and set-up

    Overview and set-up — Cost control in Data Warehousing.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Cost control in Data Warehousing.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Cost control in Data Warehousing.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Cost control in Data Warehousing.

    Lesson · Locked

    40 min

  5. Common pitfalls

    Common pitfalls — Cost control in Data Warehousing.

    Lesson · Locked

    40 min

  6. Module quiz: Cost control

    Check what you learned in Cost control before moving on.

    Quiz · Locked

    20 min

  7. Graded project: Data Warehousing

    Apply everything from Data Warehousing in one graded, portfolio-ready build.

    Graded project · Locked

    120 min

Applied learning project

Make the learning visible.

Use Graded project: Data Warehousing 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
Mariam K., Software & cloud

Your instructor

Mariam K.

Software & cloud

Helps new developers build reliable products through clear explanations and guided practice.

Diana Nsiiza, Yiga learner

“I use what I learned in my work now, not in some distant future project.”

Diana Nsiiza

Data analyst, Entebbe

Continue with

Your next best step.

Following the order of Data Engineer.

See the full chain

Next lesson

Overview and set-up

Data Warehousing

40 min · Resume

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

Sign in to share your experience with this course.

Sign in to review

Loading reviews…

Previous courseWorkflow Orchestration with AirflowNext courseProject: National Health Data Pipeline

Keep going

Other courses in this track.

View full track
Streaming with Kafka cover illustration
Data

16 lessons · 14h · Advanced

Streaming with Kafka

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

Yiga Plus
Cloud Data Platforms cover illustration
Data

20 lessons · 16.7h · Intermediate

Cloud Data Platforms

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

Yiga Plus