The Growing Analyst

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

  1. 01Why Power BI matters for data use
  2. 02From question to dashboard
  3. 05Power Query basics that actually matter
  4. 06The star schema
  5. 07DAX without fear, and the DAX function families
  6. 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.