Course overview
From SACCOs and NGOs to retail shops and corporates, organisations need people who can clean data, analyse it and report clearly. This course gives you those skills using the tools most offices already have.
You'll work with realistic Tanzanian business datasets — sales, stock, mobile money transactions and survey results.
What you'll learn
- Cleaning and organising messy data
- Advanced formulas: XLOOKUP, IF, SUMIFS and more
- PivotTables and PivotCharts
- Building monthly and quarterly reports
- Power Query for importing and transforming data
- Power BI data models and visuals
- Interactive dashboards with filters
- Presenting insights to managers
Curriculum
- Data cleaning
- Key formulas and functions
- PivotTables and charts
- Report templates
- Importing and shaping data
- Automating refreshes
- Data models
- Visuals and interactivity
- Business dashboard project
- Presenting insights
Tools you'll use
Microsoft ExcelPower QueryPower BI Desktop
Who this course is for
Office staff, accountants, M&E officers, students and business owners.
Class schedules
| Option | Days | Time | Mode |
|---|---|---|---|
| Weekday mornings | Mon – Thu | 9:00 – 12:00 | In-person or live online |
| Weekday evenings | Mon – Thu | 17:30 – 19:30 | In-person or live online |
| Weekend class | Saturdays | 9:00 – 15:00 | In-person or live online |
Choose your preferred schedule when you enroll. In-person classes are held in Dar es Salaam; online classes run live on Zoom or Google Meet.
Ready to take the next step in your creative journey?
January 2027 intake is open. Reserve your seat in a design or IT class — in Dar es Salaam or online.
Enroll now
