Objectives
- Clean and structure data with Excel and Power Query
- Query a database with SQL
- Build an interactive dashboard in Power BI
- Present a clear analysis to management
Curriculum
- Data fundamentals12 h
- Advanced Excel & Power Query20 h
- SQL for analysis24 h
- Applied statistics16 h
- Power BI: modelling & DAX28 h
- Data storytelling & final project20 h
Audience & prerequisites
Audience: Professionals who work with figures, recent graduates, management controllers, M&E officers.
Prerequisites: Comfortable with Excel; no programming knowledge required.
Tools used
ExcelPower QuerySQLPower BI
Assessment and certification
The programme ends with a practical project assessed by a panel of practitioners. Passing it earns the Africa Data Entry certificate « Data Analyst ».
Enrolment
An advisor will contact you within 48 hours to confirm your enrolment and funding.