Data Analytics Masterclass: Excel, Power BI & AI
From raw data to a dashboard your boss shares
What you'll do
Power BI is what job adverts ask for. This is the course that gets you from a messy spreadsheet to a shared dashboard — live, from a working analyst, from any county.
- Category
- Data & Technology
- Format
- Live online on Zoom · Tue & Thu 7–9 pm EAT · 6 weeks · 12 live sessions (24 hours) · all sessions recorded
- Who it is for
- Graduates, analysts, office workers, NGO data staff and business owners who want the data skills employers name in job adverts.
- Before you start
- Basic computer use; no coding background needed. A laptop with Excel, and Power BI Desktop (free, Windows) or the Power BI web service.
- Taught by
- Contract instructor — a working data analyst (Excel, Power BI, SQL) with teaching experience
- Certificate
- SGI Africa certificate of completion, verifiable at sgiafrica.org/verify
You leave with
- A portfolio dashboard built on real data
- Excel and pivot-table fluency
- Beginner SQL
- SGI Africa certificate of completion
Week by week
| # | Module | You produce |
|---|---|---|
| 1 | Data fundamentals Data types, sources, questions; Excel as an analysis tool. | Cleaned dataset |
| 2 | Excel for analysis Formulas, lookups, pivot tables; AI-assisted formulas. | Pivot-table analysis |
| 3 | Statistics for decisions Averages, distributions, trends, comparisons. | Written insight memo |
| 4 | Power BI I Data models, measures, visuals. | First dashboard |
| 5 | Power BI II and SQL basics Refresh, sharing, querying a database. | Shared dashboard |
| 6 | Capstone A real business or NGO dataset, presented to the cohort. | Portfolio dashboard |
- All live sessions
- Session recordings
- Workbook and materials
- SGI Africa certificate of completion
- Everything in Essential
- Graded assignments
- Capstone review
- Mentor WhatsApp group
- LinkedIn badge
- Everything in Professional
- 2 × 1-on-1 coaching
- CV / LinkedIn rebuild
- Employer introductions where genuine
- Capped at 8 seats
Course fees are in KSh and inclusive of all taxes. Indicative USD equivalents use 1 USD = KES 129. Pay in full at registration and get lifetime access to all session recordings.
The same course costs more once there is proof. Founding is one cohort, ever. Anyone who paid a lower price never pays more later.
Thursday 14 January, 7:00–8:30 pm EAT on Zoom
75 minutes of real teaching from the course instructor, then 15 minutes on how the cohort works. Register and we'll send the link and the replay.
Data at Work Pathway
- AI at Work: ChatGPT & AI Tools for Professionals · 4 wks
- Data Analytics Masterclass: Excel, Power BI & AI · 6 wks
- Attend at least 9 of 12 sessions — a recording plus a catch-up task counts.
- Submit at least 5 of 6 assignments.
- Complete and present the final project.
- Fees paid in full. Certificates carry a unique code verifiable at sgiafrica.org/verify.
Payment
Secure your seat with a 50% deposit. The balance is due halfway through the course — the exact week is on every course page (week 2 of a 4-week course, week 3 of a 6-week course, week 5 of CCNA and Project Management). Your seat, your live sessions, your assignment feedback and your cohort group are yours from the day you pay the deposit.
Your certificate, transcript and LinkedIn badge are issued once your fees are paid in full. If you need more time, that's fine — tell us. Your documents are held, not cancelled, and we release them the day the balance clears.
Paying in full at registration? You also receive lifetime access to all session recordings.
Our promise
Attend at least 75% of the live sessions (a recording plus a catch-up task counts), submit at least 75% of the assignments and complete the final project. If you finish and your portfolio isn't complete, you join the next cohort free.
Refunds and transfers
Full refund up to 7 days before the start date, no questions asked. After Session 1, no refund — but you may transfer your seat once to any future cohort, or to a colleague, at no charge.
If we postpone a cohort because it did not reach its minimum, you choose: a full refund within 5 working days, or a transfer to the next cohort with a free upgrade to the Professional tier.
Organisation seats are invoiced and refundable in full up to 7 days before the start date; unused seats transfer to your next intake.
Founding cohort
The founding price is for the founding cohort only — the first-ever run of each course, capped at 20 seats. In return, founding students give a written testimonial and take part in a short case study, and keep lifetime access to every future run of that course.
Prices rise with cohort 2 and again from cohort 4. Anyone who paid a lower price never pays more.