A production-focused malaria data extraction app that connects to Nigeria DHIS2 instance, lets users filter by organisation unit, period, and indicators, and exports analysis-ready datasets.
It combines live DHIS2 querying, organisation hierarchy handling, and a Shiny-based extraction workflow into a practical reporting tool for public health teams.
This project is an R/Shiny application built to make malaria reporting data easier to query, structure, and export from DHIS2. It allows users to connect to the live Nigeria DHIS2 environment, choose the organisational scope they care about, select time periods and indicators, and generate downloadable datasets in a format that is much easier to use for analysis, reporting, and decision-making.
Key features:
- Live DHIS2 integration using authenticated API requests to pull analytics directly from the Nigeria DHIS2 instance.
- Indicator-driven extraction workflow where users can choose one or many malaria indicators from a curated catalog.
- Flexible time filtering with support for yearly and monthly period selection.
- Organisation unit filtering with hierarchy-aware selection across federal, state, LGA, ward, and facility levels.
- User-controlled organisation detail columns so the exported data can include only the hierarchy fields needed for the analysis.
- Wide-format output where selected indicators become column headers in the final extracted dataset.
- Extract preview table that reflects the real exported structure before download.
- CSV and RDS export options for both analyst-friendly and R-native workflows.
- Automatic organisation unit cache support to improve responsiveness and reduce unnecessary metadata calls.
- Resilient DHIS2 response handling to support different API row shapes and avoid extraction failures from inconsistent response formats.