Yiga AI

Course 2 of 11

Data Modelling in Power BI

Relationships, Star schema, Calculated columns, and more.

Yiga AI

Intermediate en

Intermediate · Course · 3 weeks at 5 hrs/week

Duration
3 weeks
Effort
5 hrs/week
Lessons
16
Hands-on exercises
16
Projects
1
Language
en

What you’ll learn

Skills you can put to work.

Introduction to SQL

Joining Data in SQL

Intermediate SQL

Window Functions & Advanced SQL

Syllabus

Every module, step by step.

4 modules · 21 lessons · 14 hours · 1 graded project

840 minutes of guided lesson time.

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

Module 1 · 5 lessons · 3 hoursRelationshipsModule 1 of 4 in Data Modelling in Power BI.

  1. Overview and set-up

    Overview and set-up — Relationships in Data Modelling in Power BI.

    Lesson

    40 min

  2. Core concepts

    Core concepts — Relationships in Data Modelling in Power BI.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Relationships in Data Modelling in Power BI.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Relationships in Data Modelling in Power BI.

    Lesson · Locked

    40 min

  5. Module quiz: Relationships

    Check what you learned in Relationships before moving on.

    Quiz · Locked

    20 min
Module 2 · 5 lessons · 3 hours LockedStar schemaModule 2 of 4 in Data Modelling in Power BI.

  1. Overview and set-up

    Overview and set-up — Star schema in Data Modelling in Power BI.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Star schema in Data Modelling in Power BI.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Star schema in Data Modelling in Power BI.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Star schema in Data Modelling in Power BI.

    Lesson · Locked

    40 min

  5. Module quiz: Star schema

    Check what you learned in Star schema before moving on.

    Quiz · Locked

    20 min
Module 3 · 5 lessons · 3 hours LockedCalculated columnsModule 3 of 4 in Data Modelling in Power BI.

  1. Overview and set-up

    Overview and set-up — Calculated columns in Data Modelling in Power BI.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Calculated columns in Data Modelling in Power BI.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Calculated columns in Data Modelling in Power BI.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Calculated columns in Data Modelling in Power BI.

    Lesson · Locked

    40 min

  5. Module quiz: Calculated columns

    Check what you learned in Calculated columns before moving on.

    Quiz · Locked

    20 min
Module 4 · 6 lessons · 5 hours LockedHierarchiesModule 4 of 4 in Data Modelling in Power BI.

  1. Overview and set-up

    Overview and set-up — Hierarchies in Data Modelling in Power BI.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Hierarchies in Data Modelling in Power BI.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Hierarchies in Data Modelling in Power BI.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Hierarchies in Data Modelling in Power BI.

    Lesson · Locked

    40 min

  5. Module quiz: Hierarchies

    Check what you learned in Hierarchies before moving on.

    Quiz · Locked

    20 min

  6. Graded project: Data Modelling in Power BI

    Apply everything from Data Modelling in Power BI in one graded, portfolio-ready build.

    Graded project · Locked

    120 min

Applied learning project

Make the learning visible.

Use Graded project: Data Modelling in Power BI 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 Analyst with SQL & Power BI.

See the full chain

Next lesson

Overview and set-up

Data Modelling in Power BI

40 min · Resume

Course 3 in the track

Introduction to Power BI

Interface, Importing data, Visuals, and more.

Beginner · Course · 3 weeks at 5 hrs/week

Course 4 in the track

Dashboard Design & Storytelling

Layout, Colour, KPIs, and more.

Intermediate · Course · 3 weeks at 5 hrs/week

Course 5 in the track

Intermediate SQL

Aggregation, CASE, Subqueries, and more.

Intermediate · Course · 3 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 courseProject: Sales Dashboard for a Kampala Retail ChainNext courseIntroduction to Power BI

Keep going

Other courses in this track.

View full track
Intermediate SQL cover illustration
Data

16 lessons · 14h · Intermediate

Intermediate SQL

Aggregation, CASE, Subqueries, and more.

Yiga Plus