Free book
Power BI for M&E and Public Health Data Analysts
A hands-on guide I wrote for people who work with health programme data: HIV, TB, malaria, ANC and NCD indicators, with a practice dataset that is messy on purpose.
Get the free PDF- 137pages
- 5practice data files
- FreePDF and online
- 31hands-on exercises
Who it is for
- M&E officers who produce routine reports and are tired of updating Excel files by hand.
- Data managers and health information officers who bring together data from DHIS2, KoboToolbox, ODK, lab systems and medical records.
- Programme managers and technical leads who need timely, interactive dashboards to make decisions.
Some of what is inside
- 01Why Power BI matters for data use
- 02From question to dashboard
- 05Power Query basics that actually matter
- 06The star schema
- 07DAX without fear, and the DAX function families
- 08Designing dashboards people actually use
What you need
- No experience with Power BI, DAX or databases. Excel reporting experience helps.
- Power BI Desktop, which is free, on Windows 10 or later.
- The five practice files, which you download from my book's appendix.