Turn Raw Program Data Into Dashboards Decision-Makers Actually Use
Development organizations sit on enormous amounts of program, M&E, and financial data — and most of it never makes it further than a static spreadsheet. Reports take days to compile, numbers disagree across departments, and by the time a dashboard reaches leadership, it's already out of date.
This one-week, hands-on workshop takes you from raw, messy spreadsheets to live, interactive Power BI dashboards. You'll work with real datasets, build your own reports from scratch, and leave with the skills to turn your organization's data into insight your team and donors can actually use.
Who this workshop is for
Built for anyone who works with program, financial, or M&E data and needs to report on it clearly.
What you'll walk away able to do
Build Real Dashboards
Design interactive Power BI dashboards connected to live program and financial data.
Model and Clean Data
Use Power Query and data modeling to clean, shape, and relate messy datasets.
Write Working DAX
Create calculated columns, measures, and KPIs using DAX formulas.
Publish and Share Insight
Publish reports, schedule data refreshes, and share dashboards securely with teams and donors.
Five days, day by day
Click any day to see the full breakdown.
1 Power BI Foundations +
- Where Power BI fits in the business intelligence landscape
- Power BI Desktop vs. Power BI Service
- Connecting to Excel, CSV, and database sources
- The reporting workflow: Query → Model → Report
2 Power Query and Data Cleaning +
- Importing and transforming messy program data
- Merging and appending queries from multiple sources
- Handling duplicates, blanks, and inconsistent formats
- Building repeatable, reusable data-cleaning steps
3 Data Modeling and DAX Essentials +
- Building relationships between tables
- Star-schema basics for reporting
- Writing calculated columns and measures
- Common DAX functions for program and financial reporting
4 Building Dashboards and Visuals +
- Choosing the right visual for the data you have
- Building interactive dashboards with slicers and filters
- Conditional formatting and drill-through
- Designing reports for a non-technical audience
5 Publishing, Sharing, and Automation +
- Publishing reports to Power BI Service
- Setting up scheduled data refresh
- Sharing dashboards securely with teams and donors
- Building a personal rollout plan for your organization
How the workshop is delivered
Laptop-based and hands-on throughout — you build real dashboards, not just watch demos.
One fee. Everything covered.
5-day in-person workshop in Nairobi, Kenya. Please bring a laptop with Power BI Desktop installable (free).
- Ten o'clock tea/snacks
- Buffet lunches and water
- Power BI practice files and dashboard templates
- Four o'clock coffees
Training trusted across the continent and beyond
Asset Africa Institute specializes in the research, design, and delivery of high-quality, affordable training for development professionals worldwide — built around real organizational challenges, not theory for its own sake.
Organizations that have trusted AAI include:
World Resources Institute · Catholic University of Mozambique · National Open University of Nigeria (NOUN) · ACALISE, Uganda · WIOMSA · Help-ev.de, Zimbabwe · FCA-Kenya · Addis Ababa University, Ethiopia · FHI360, Burundi · GAIN, Pakistan · Moi University, Kenya · The Development Fund, Ethiopia/Somalia · eHealth, Nigeria · JRS, Thailand · SEND Sierra Leone · CABTAL, Cameroon · TOCH, South Sudan · CHA, Malawi · LEAP-RE (EU–AU Energy Partnership) — among tens of others.
Questions, answered
Who should attend this workshop?
M&E, data, program, finance, and communications staff who need to build or maintain reports and dashboards from organizational data. No prior Power BI experience is required.
When and where does it take place?
19–23 October 2026, in-person in Nairobi, Kenya.
What does the USD 695 fee cover?
Tuition, refreshments, buffet lunches, practice datasets, dashboard templates, and a certificate of completion. Accommodation and travel are not included.
Is this in person or online?
This workshop is delivered in person only. Participants should bring a laptop capable of running Power BI Desktop (free to install, Windows only).