Kenya malaria prevalence dashboard: interactive Power BI-style visualisation of P. falciparum survey data (1985-2020) with a full R analysis pipeline
# Kenya Malaria Prevalence Dashboard
An interactive, Power BI-style dashboard of *Plasmodium falciparum* malaria
prevalence in Kenya, built from 2,149 geo-referenced community and
school-based surveys (Malaria Atlas Project, 1985–2020). Every statistic on
the dashboard is computed in **R** — cleaning, summaries, and a binomial
logistic regression — and rendered as a self-contained HTML dashboard that
works offline in any browser.
> **Live demo:**
calvinokoth9528-cloud.githu…
## Visuals
## What the dashboard shows
| Section | Content |
|---|---|
| **KPI cards** | 2,149 surveys · 186,765 individuals examined · 38,161 infections · 20.4% overall prevalence |
| **Temporal trends** | Weighted prevalence by year (fell from ~46% in 1985 to ~8% by 2020) and by decade |
| **Seasonality & trends** | Prevalence by month of year, rural vs urban by year, microscopy vs RDT by year |
| **Geography** | Interactive map of all survey sites with a Kenya outline, plus prevalence by region and latitude band |
| **Breakdowns** | Setting, diagnostic method, age group, RDT types, hotspots |
| **Reliability** | Sample-size vs prevalence, per-survey statistics |
| **Statistical model** | Binomial logistic regression: year OR **0.930** (~7% decline/year), urban OR **0.483**, RDT OR **0.501** |
| **Data explorer** | Searchable table of all 2,149 surveys |
Power BI-style slicers (setting, diagnostic method, survey year) re-filter
every chart and the data table instantly.
## Dataset
- **Source:** Malaria Atlas Project (`malariaAtlas` R package), Kenya surveys
- **Scope:** 3,607 raw survey records; 2,149 retained after cleaning
(1,458 removed for missing or invalid parasitological data)
- **Recorded fields:** site, coordinates, year and month, age range,
individuals examined, positive results, parasite rate, diagnostic method,
RDT type, species (all *P. falciparum*)
## Methodology (R)
`malaria_analysis.R` (R 4.6.1, `tidyverse`) performs the full an …