This community innovation has been accepted at the 2026 DHIS2 Annual Conference and will be included a session.
DHIS2 Central Data Warehouse for Humanitarian Ops
The International Committee of the Red Cross (ICRC) operates health programs across complex, multi-country humanitarian settings where timely, reliable, and scalable health information is essential for operational decision-making and accountability. Historically, medical and operational data were fragmented across electronic health records, parallel DHIS2 implementations, logistics systems, and manual reporting processes, causing reporting delays, data inconsistencies, limited real-time visibility, and poor scalability. To address these challenges, ICRC implemented the Medical Activities Database (MAD), a DHIS2 instance designed to function as a centralized operational data warehouse. MAD consolidates validated data from multiple clinical, pre-hospital, logistics, and operational systems through an Operational Data Store (ODS) that provides integration and validation. Clinical data from OpenMRS is synchronized to MAD via the ODS, enabling automated population of aggregated indicators and reducing manual data aggregation by over 60% in supported programs. MAD is interoperable with other DHIS2 instances, including ALMANACH DHIS2 and a dedicated Pre-Hospital DHIS2 instance capturing ambulance response data through an offline-first Android application. Validated indicators from these systems are centrally aggregated for analysis and reporting. Operational planning and monitoring data from the ICRC Planning and Monitoring Tool (PMT) and pharmacy stock and consumption data from the Pharmacy Stock Management (PSM) system are integrated, enabling combined analysis of service delivery and supply availability. Organization unit hierarchies and geospatial reference data are synchronized from the ICRC Location Manager to ensure consistent geographic analysis. MAD analytics tables and indicators feed DHIS2 dashboards used for operational oversight and donor reporting, reducing reporting cycles from several weeks to fewer than five days. Data elements and indicators are aligned with standard DHIS2 configurations, supporting future interoperability.
Primary Author: Mamadou Tafsir Diallo
Keywords:
DHIS2; Health Information Systems; Digital Public Infrastructure; Interoperability; OpenMRS; Operational Data Store; Humanitarian Health; Multi-country Programs; Health Data Integration; ETL; Tableau; Data Warehousing; Offline-first Systems; Supply Chain Integration; Health Analytics; Humanitarian Operations; Data Governance; Health System Strengthening
1 Like