Yiga AI

Course 1 of 11

Project: Sales Dashboard for a Kampala Retail Chain

Model data, Build KPIs, Design dashboard, 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 hoursModel dataModule 1 of 4 in Project: Sales Dashboard for a Kampala Retail Chain.

  1. Overview and set-up

    Overview and set-up — Model data in Project: Sales Dashboard for a Kampala Retail Chain.

    Lesson

    40 min

  2. Core concepts

    Core concepts — Model data in Project: Sales Dashboard for a Kampala Retail Chain.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Model data in Project: Sales Dashboard for a Kampala Retail Chain.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Model data in Project: Sales Dashboard for a Kampala Retail Chain.

    Lesson · Locked

    40 min

  5. Common pitfalls

    Common pitfalls — Model data in Project: Sales Dashboard for a Kampala Retail Chain.

    Lesson · Locked

    40 min

  6. Module quiz: Model data

    Check what you learned in Model data before moving on.

    Quiz · Locked

    20 min
Module 2 · 6 lessons · 3.7 hours LockedBuild KPIsModule 2 of 4 in Project: Sales Dashboard for a Kampala Retail Chain.

  1. Overview and set-up

    Overview and set-up — Build KPIs in Project: Sales Dashboard for a Kampala Retail Chain.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Build KPIs in Project: Sales Dashboard for a Kampala Retail Chain.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Build KPIs in Project: Sales Dashboard for a Kampala Retail Chain.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Build KPIs in Project: Sales Dashboard for a Kampala Retail Chain.

    Lesson · Locked

    40 min

  5. Common pitfalls

    Common pitfalls — Build KPIs in Project: Sales Dashboard for a Kampala Retail Chain.

    Lesson · Locked

    40 min

  6. Module quiz: Build KPIs

    Check what you learned in Build KPIs before moving on.

    Quiz · Locked

    20 min
Module 3 · 6 lessons · 3.7 hours LockedDesign dashboardModule 3 of 4 in Project: Sales Dashboard for a Kampala Retail Chain.

  1. Overview and set-up

    Overview and set-up — Design dashboard in Project: Sales Dashboard for a Kampala Retail Chain.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Design dashboard in Project: Sales Dashboard for a Kampala Retail Chain.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Design dashboard in Project: Sales Dashboard for a Kampala Retail Chain.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Design dashboard in Project: Sales Dashboard for a Kampala Retail Chain.

    Lesson · Locked

    40 min

  5. Common pitfalls

    Common pitfalls — Design dashboard in Project: Sales Dashboard for a Kampala Retail Chain.

    Lesson · Locked

    40 min

  6. Module quiz: Design dashboard

    Check what you learned in Design dashboard before moving on.

    Quiz · Locked

    20 min
Module 4 · 7 lessons · 5.7 hours LockedPresentModule 4 of 4 in Project: Sales Dashboard for a Kampala Retail Chain.

  1. Overview and set-up

    Overview and set-up — Present in Project: Sales Dashboard for a Kampala Retail Chain.

    Lesson · Locked

    40 min

  2. Core concepts

    Core concepts — Present in Project: Sales Dashboard for a Kampala Retail Chain.

    Lesson · Locked

    40 min

  3. Worked example

    Worked example — Present in Project: Sales Dashboard for a Kampala Retail Chain.

    Lesson · Locked

    40 min

  4. Hands-on practice

    Hands-on practice — Present in Project: Sales Dashboard for a Kampala Retail Chain.

    Lesson · Locked

    40 min

  5. Common pitfalls

    Common pitfalls — Present in Project: Sales Dashboard for a Kampala Retail Chain.

    Lesson · Locked

    40 min

  6. Module quiz: Present

    Check what you learned in Present before moving on.

    Quiz · Locked

    20 min

  7. Graded project: Project: Sales Dashboard for a Kampala Retail Chain

    Apply everything from Project: Sales Dashboard for a Kampala Retail Chain in one graded, portfolio-ready build.

    Graded project · Locked

    120 min

Applied learning project

Make the learning visible.

Use Graded project: Project: Sales Dashboard for a Kampala Retail Chain 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
Daniel O., Data & analytics

Your instructor

Daniel O.

Data & analytics

Turns real African data problems into practical lessons learners can apply immediately.

Brian Okello, Yiga learner

“The course content made machine learning understandable, and the practice kept me moving.”

Brian Okello

Software developer, Kampala

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

Project: Sales Dashboard for a Kampala Retail Chain

40 min · Resume

Course 2 in the track

Data Modelling in Power BI

Relationships, Star schema, Calculated columns, and more.

Intermediate · Course · 3 weeks at 5 hrs/week

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

Learner reviews

What learners say.

Write a review

Sign in to share your experience with this course.

Sign in to review

Loading reviews…

Next courseData Modelling in 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