Yiga AI

Course 8 of 11

DAX Fundamentals

Measures, CALCULATE, Time intelligence, 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.

Introduction to SQL

Joining Data in SQL

Intermediate SQL

Window Functions & Advanced SQL

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 hoursMeasuresModule 1 of 4 in DAX Fundamentals.

  1. Overview and set-up

    Overview and set-up — Measures in DAX Fundamentals.

    Lesson

    40 min

  2. Core concepts

    Core concepts — Measures in DAX Fundamentals.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Measures in DAX Fundamentals.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Measures in DAX Fundamentals.

    Lesson · Locked

    40 min

  5. Common pitfalls

    Common pitfalls — Measures in DAX Fundamentals.

    Lesson · Locked

    40 min

  6. Module quiz: Measures

    Check what you learned in Measures before moving on.

    Quiz · Locked

    20 min
Module 2 · 6 lessons · 3.7 hours LockedCALCULATEModule 2 of 4 in DAX Fundamentals.

  1. Overview and set-up

    Overview and set-up — CALCULATE in DAX Fundamentals.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — CALCULATE in DAX Fundamentals.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — CALCULATE in DAX Fundamentals.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — CALCULATE in DAX Fundamentals.

    Lesson · Locked

    40 min

  5. Common pitfalls

    Common pitfalls — CALCULATE in DAX Fundamentals.

    Lesson · Locked

    40 min

  6. Module quiz: CALCULATE

    Check what you learned in CALCULATE before moving on.

    Quiz · Locked

    20 min
Module 3 · 6 lessons · 3.7 hours LockedTime intelligenceModule 3 of 4 in DAX Fundamentals.

  1. Overview and set-up

    Overview and set-up — Time intelligence in DAX Fundamentals.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Time intelligence in DAX Fundamentals.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Time intelligence in DAX Fundamentals.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Time intelligence in DAX Fundamentals.

    Lesson · Locked

    40 min

  5. Common pitfalls

    Common pitfalls — Time intelligence in DAX Fundamentals.

    Lesson · Locked

    40 min

  6. Module quiz: Time intelligence

    Check what you learned in Time intelligence before moving on.

    Quiz · Locked

    20 min
Module 4 · 7 lessons · 5.7 hours LockedFiltersModule 4 of 4 in DAX Fundamentals.

  1. Overview and set-up

    Overview and set-up — Filters in DAX Fundamentals.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Filters in DAX Fundamentals.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Filters in DAX Fundamentals.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Filters in DAX Fundamentals.

    Lesson · Locked

    40 min

  5. Common pitfalls

    Common pitfalls — Filters in DAX Fundamentals.

    Lesson · Locked

    40 min

  6. Module quiz: Filters

    Check what you learned in Filters before moving on.

    Quiz · Locked

    20 min

  7. Graded project: DAX Fundamentals

    Apply everything from DAX Fundamentals in one graded, portfolio-ready build.

    Graded project · Locked

    120 min

Applied learning project

Make the learning visible.

Use Graded project: DAX Fundamentals 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
Joel N., Career readiness

Your instructor

Joel N.

Career readiness

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

Amina Hassan, Yiga learner

“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 Analyst with SQL & Power BI.

See the full chain

Next lesson

Overview and set-up

DAX Fundamentals

40 min · Resume

Course 9 in the track

Database Design Basics

Tables & keys, Normalisation, Schemas, and more.

Beginner · Course · 3 weeks at 5 hrs/week

Course 10 in the track

Introduction to SQL

Databases, SELECT, Filtering, and more.

Beginner · Course · 3 weeks at 5 hrs/week

Course 11 in the track

Joining Data in SQL

Inner/outer joins, Self joins, Set operations, and more.

Beginner · 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 courseWindow Functions & Advanced SQLNext courseDatabase Design Basics

Keep going

Other courses in this track.

View full track