Project: Sales Dashboard for a Kampala Retail Chain
Model data, Build KPIs, Design dashboard, and more.
Course 4 of 11
Layout, Colour, KPIs, and more.
Yiga AI
Intermediate · Course · 3 weeks at 5 hrs/week
What you’ll learn
Introduction to SQL
Joining Data in SQL
Intermediate SQL
Window Functions & Advanced SQL
Syllabus
4 modules · 22 lessons · 14 hours · 1 graded project
848 minutes of guided lesson time.
Sign in and enrol to unlock every lesson. The first lesson is open as a preview.
Quick start: clean a messy spreadsheet with AI
A 5–10 minute win you can use today.
Lesson
Overview and set-up
Overview and set-up — Layout in Dashboard Design & Storytelling.
Lesson · Locked
Core concepts
Core concepts — Layout in Dashboard Design & Storytelling.
Lesson · Locked
Worked example
Worked example — Layout in Dashboard Design & Storytelling.
Lesson · Locked
Hands-on practice
Hands-on practice — Layout in Dashboard Design & Storytelling.
Lesson · Locked
Module quiz: Layout
Check what you learned in Layout before moving on.
Quiz · Locked
Overview and set-up
Overview and set-up — Colour in Dashboard Design & Storytelling.
Lesson · Locked
Core concepts
Core concepts — Colour in Dashboard Design & Storytelling.
Lesson · Locked
Worked example
Worked example — Colour in Dashboard Design & Storytelling.
Lesson · Locked
Hands-on practice
Hands-on practice — Colour in Dashboard Design & Storytelling.
Lesson · Locked
Module quiz: Colour
Check what you learned in Colour before moving on.
Quiz · Locked
Overview and set-up
Overview and set-up — KPIs in Dashboard Design & Storytelling.
Lesson · Locked
Core concepts
Core concepts — KPIs in Dashboard Design & Storytelling.
Lesson · Locked
Worked example
Worked example — KPIs in Dashboard Design & Storytelling.
Lesson · Locked
Hands-on practice
Hands-on practice — KPIs in Dashboard Design & Storytelling.
Lesson · Locked
Module quiz: KPIs
Check what you learned in KPIs before moving on.
Quiz · Locked
Overview and set-up
Overview and set-up — Executive reports in Dashboard Design & Storytelling.
Lesson · Locked
Core concepts
Core concepts — Executive reports in Dashboard Design & Storytelling.
Lesson · Locked
Worked example
Worked example — Executive reports in Dashboard Design & Storytelling.
Lesson · Locked
Hands-on practice
Hands-on practice — Executive reports in Dashboard Design & Storytelling.
Lesson · Locked
Module quiz: Executive reports
Check what you learned in Executive reports before moving on.
Quiz · Locked
Graded project: Dashboard Design & Storytelling
Apply everything from Dashboard Design & Storytelling in one graded, portfolio-ready build.
Graded project · Locked
Applied learning project
Use Graded project: Dashboard Design & Storytelling to apply this course to a practical challenge. You’ll finish with a clear solution and the reasoning behind your choices.

Your instructor
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.”
Continue with
Following the order of Data Analyst with SQL & Power BI.
Next lesson
Quick start: clean a messy spreadsheet with AI
Dashboard Design & Storytelling
8 min · Resume
Course 5 in the track
Intermediate SQL
Aggregation, CASE, Subqueries, and more.
Intermediate · Course · 3 weeks at 5 hrs/week
Course 6 in the track
Excel & Google Sheets for Analysts
Formulas, Pivot tables, Lookups, and more.
Beginner · Course · 3 weeks at 5 hrs/week
Course 7 in the track
Window Functions & Advanced SQL
RANK/ROW_NUMBER, Running totals, LAG/LEAD, and more.
Intermediate · Course · 3 weeks at 5 hrs/week
Learner reviews
Sign in to share your experience with this course.
Sign in to reviewLoading reviews…
Keep going
Model data, Build KPIs, Design dashboard, and more.
Relationships, Star schema, Calculated columns, and more.
Interface, Importing data, Visuals, and more.
Aggregation, CASE, Subqueries, and more.