Analysis and dashboards
Analysis that answers the question that was asked, and dashboards people use: clear indicators, honest denominators and nothing decorative.
IncludesPower BI, R and SQL, automated reporting, indicator design
About
Data professional, trainer and author. Founder of Data Use Academy & Consulting.
I help organisations make better use of their data, and I teach the people who do the work.
For over a decade I have worked where data meets decisions, strengthening how data is collected, cleaned, structured, analysed and used. That covers data management and data quality, monitoring and evaluation systems, analysis, dashboards and the reporting that leaders rely on. I have supported teams at facility, district and national levels to move beyond static reports to systems that allow continuous monitoring and better-informed decisions.
Much of that work has been on large public health programmes, including HIV, malaria, tuberculosis, maternal health and integrated service delivery, where data is often incomplete, inconsistent and needed quickly. That is where I learnt to protect indicator definitions, build reproducible workflows and keep analysis consistent from one reporting cycle to the next. The same discipline applies wherever an organisation needs to make decisions with its data.
I teach data analytics, SQL, data science, MERL, GIS and research methods, and I founded Data Use Academy & Consulting. My book, Power BI for M&E and Public Health Data Analysts, is a free guide to Power BI built on the same experience.
Most material for analysts teaches the tools and stops. The hard part is the decisions around them: which question to answer, whether the data can carry it, and how to explain what you found. That is what I write about here, along with the career questions that rarely get taught.
I also share my own learning as it happens: a new method, a changed opinion, a correction. Staying good at this work means continuing to learn, and I would rather show that than hide it.
I help organisations and teams make better decisions with their data, and I train the people who do the work.
Analysis that answers the question that was asked, and dashboards people use: clear indicators, honest denominators and nothing decorative.
IncludesPower BI, R and SQL, automated reporting, indicator design
Data management, data quality and monitoring and evaluation systems that take teams from static reports to continuous monitoring.
IncludesData quality reviews, indicator tracking, M&E frameworks
Hands-on courses and mentoring for analysts, M&E staff and whole teams, from the first spreadsheet to production dashboards.
SubjectsData analytics, SQL, data science, MERL, GIS, research methods
Good analytics is less about technical sophistication than about these three.
01
Clean, well-modelled data comes before any chart. Most reporting problems start long before the dashboard.
02
Every indicator has a written definition: what is counted, what it is divided by, and what the number cannot tell you.
03
Every step from raw data to the final number is recorded and repeatable, so anyone can check it.
Three series, one for each kind of lesson. The first posts are on the way.
Real analysis, step by step: the question, the approach, and what the result can't tell you.
For exampleBefore I trust this percentage, here are the checks I make.
What over a decade of data work has taught me about scope, trust and progression. Experience, not rules.
For exampleQuestions I would ask before accepting more responsibility.
What I am working on now: new methods, changed opinions and the corrections worth showing.
For exampleThe R error that made me understand my data differently.
New lessons, tools and resources by email. Subscribers also get my free Power BI book.