Course 1 of 11
Project: Sales Dashboard for a Kampala Retail ChainModel data, Build KPIs, Design dashboard, and more.
Intermediate · Course · 4 weeks at 5 hrs/week
17 hours · 20 lessons · 20 exercises · 4 quizzes · 1 project
Career track
Data Analyst with SQL & Power BI
11 courses, 70 hours, ending in Project: Sales Dashboard for a Kampala Retail Chain.
Yiga AI
Beginner → Intermediate en
Beginner → Intermediate · Career Track · 3–4 months at 10 hrs/week
- Duration
- 3–4 months
- Effort
- 10 hrs/week
- Courses
- 11
- Hands-on exercises
- 185
- Projects
- 11
- Certificate
- Included
Your pace≈ 3–4 months · 160 hours total
What you'll learn
11 courses in this track
- 01Project: Sales Dashboard for a Kampala Retail ChainIntermediate · 16.7 hours · 20 lessonsModel data · Build KPIs · Design dashboard · +1 more
- 02Data Modelling in Power BIIntermediate · 14 hours · 16 lessonsRelationships · Star schema · Calculated columns · +1 more
- 03Introduction to Power BIBeginner · 14 hours · 16 lessonsInterface · Importing data · Visuals · +1 more
- 04Dashboard Design & StorytellingIntermediate · 14.1 hours · 17 lessonsLayout · Colour · KPIs · +1 more
- 05Intermediate SQLIntermediate · 14 hours · 16 lessonsAggregation · CASE · Subqueries · +1 more
- 06Excel & Google Sheets for AnalystsBeginner · 14 hours · 16 lessonsFormulas · Pivot tables · Lookups · +1 more
- 07Window Functions & Advanced SQLIntermediate · 14 hours · 16 lessonsRANK/ROW_NUMBER · Running totals · LAG/LEAD · +1 more
- 08DAX FundamentalsIntermediate · 16.7 hours · 20 lessonsMeasures · CALCULATE · Time intelligence · +1 more
- 09Database Design BasicsBeginner · 14 hours · 16 lessonsTables & keys · Normalisation · Schemas · +1 more
- 10Introduction to SQLBeginner · 14 hours · 16 lessonsDatabases · SELECT · Filtering · +1 more
- 11Joining Data in SQLBeginner · 14 hours · 16 lessonsInner/outer joins · Self joins · Set operations · +1 more
About this track
What you’ll learn.
1
Introduction to SQL
2
Joining Data in SQL
3
Intermediate SQL
4
Window Functions & Advanced SQL
Skills you’ll gain
Data
How this compares
Comparable to DataCamp Data Analyst in SQL / Power BI · Coursera Microsoft Power BI Analyst. This track is 160 hours of study — about 3–4 months at 10 hrs/week.
Career outcomes
Turn learning into forward motion.
Build job-ready evidence for roles that use these skills every day.
Curriculum
A clear path, course by course.
Complete the courses in order so each new skill builds on the last.
- 1View course
- 2View course
Course 2 of 11
Data Modelling in Power BIRelationships, Star schema, Calculated columns, and more.
Intermediate · Course · 3 weeks at 5 hrs/week
14 hours · 16 lessons · 16 exercises · 4 quizzes · 1 project
- 3View course
Course 3 of 11
Introduction to Power BIInterface, Importing data, Visuals, and more.
Beginner · Course · 3 weeks at 5 hrs/week
14 hours · 16 lessons · 16 exercises · 4 quizzes · 1 project
- 4View course
Course 4 of 11
Dashboard Design & StorytellingLayout, Colour, KPIs, and more.
Intermediate · Course · 3 weeks at 5 hrs/week
14 hours · 17 lessons · 17 exercises · 4 quizzes · 1 project
- 5View course
Course 5 of 11
Intermediate SQLAggregation, CASE, Subqueries, and more.
Intermediate · Course · 3 weeks at 5 hrs/week
14 hours · 16 lessons · 16 exercises · 4 quizzes · 1 project
- 6View course
Course 6 of 11
Excel & Google Sheets for AnalystsFormulas, Pivot tables, Lookups, and more.
Beginner · Course · 3 weeks at 5 hrs/week
14 hours · 16 lessons · 16 exercises · 4 quizzes · 1 project
- 7View course
Course 7 of 11
Window Functions & Advanced SQLRANK/ROW_NUMBER, Running totals, LAG/LEAD, and more.
Intermediate · Course · 3 weeks at 5 hrs/week
14 hours · 16 lessons · 16 exercises · 4 quizzes · 1 project
- 8View course
Course 8 of 11
DAX FundamentalsMeasures, CALCULATE, Time intelligence, and more.
Intermediate · Course · 4 weeks at 5 hrs/week
17 hours · 20 lessons · 20 exercises · 4 quizzes · 1 project
- 9View course
Course 9 of 11
Database Design BasicsTables & keys, Normalisation, Schemas, and more.
Beginner · Course · 3 weeks at 5 hrs/week
14 hours · 16 lessons · 16 exercises · 4 quizzes · 1 project
- 10View course
Course 10 of 11
Introduction to SQLDatabases, SELECT, Filtering, and more.
Beginner · Course · 3 weeks at 5 hrs/week
14 hours · 16 lessons · 16 exercises · 4 quizzes · 1 project
- 11View course
Course 11 of 11
Joining Data in SQLInner/outer joins, Self joins, Set operations, and more.
Beginner · Course · 3 weeks at 5 hrs/week
14 hours · 16 lessons · 16 exercises · 4 quizzes · 1 project
Applied learning project
Finish with work you can show.
Bring the track together in Joining Data in SQL. Apply what you have learned to a practical challenge and explain the decisions behind your solution.
- Introduction to SQL
- Joining Data in SQL
- Intermediate SQL
Learn from experts
Grace A.
AI for professions
Shows working professionals how to use AI responsibly inside everyday workflows.
“The examples felt relevant to public service and worked on the connection I actually have.”
Frequently asked questions
Before you begin.
Do I need prior experience?
This track is designed for beginner → intermediate learners. Start with the first course and follow the numbered path so each skill builds naturally.
How long will the track take?
The track contains 11 courses and about 160 hours of learning. Most learners finish in around 3–4 months at 10 hrs/week.
Can I learn on my phone?
Yes. Yiga lessons are designed to work across phones and computers, so you can keep learning on the device available to you.
Will I earn a credential?
You can earn a shareable Yiga credential after completing the required learning and assessment activities in the track.
Is financial support available?
Scholarship and financial-aid options are available for eligible learners. Contact the Yiga support team before enrolling for guidance.
Ready when you are
Start this track today.
Begin with course 1 of 11, Project: Sales Dashboard for a Kampala Retail Chain, and work through the path at your own pace.
Keep exploring
Related tracks.
Beginner → Intermediate · Career Track · 6–7 months at 10 hrs/week
262 hours · 17 courses · 17 projects · Certificate
Data Analyst with Python
14 courses, 90 hours, ending in Analyst Career Prep.
Beginner → Intermediate · Career Track · 7–8 months at 10 hrs/week
314 hours · 19 courses · 19 projects · Certificate
Full-Stack Web Developer
17 courses, 140 hours, ending in Developer Career Prep.
Beginner → Intermediate · Career Track · 3–4 months at 10 hrs/week
148 hours · 9 courses · 9 projects · Certificate
Mobile App Developer (Flutter)
9 courses, 70 hours, ending in Project: Boda-Boda Delivery App.