Summary DWH

The National Data Warehouse (NDW) is a central repository of the statistical HIV Care data gathered by Kenya’s health facilities implementing HIV programs and who are running Electronic Medical Records (EMR’s).

The KeHMIS project developed the integrated NDW and currently maintains it for anonymized patient-level data. The NDW acts as a repository and analytics platform through ‘connecting’, collating, and aggregating patient data from all the EMRs in the country. The solution is hosted at the National AIDS & STI Control Program (NASCOP) server. As a national repository, NDW hosts de-identified data to facilitate programmatic monitoring of Health Information Systems (HIS) implementations and progress on clinical care and outcomes for HIV infected and exposed persons. The primary source of data is the EMRs deployed at facility level.  As an analytics platform, the NDW supports the visualization of the progress towards UNAIDs 95:95:95 goals, case-based surveillance, the tracking of metrics relating to Human Resources for Health (HRH), the Monitoring of performance for different program indicators in the HIV scope and supports ad hoc data analysis for verified users to support further data analysis needs to be required.

The NDW hosts data for over 2.2 million HIV positive persons and over 1.1M testing records for tested individuals from 8 EMRs in over 1200 facilities with an EMR. The NDW has become an integral part in the country’s HIV program support by providing planners and decision-makers at the Ministry of Health, County Governments, development agencies, and others with the capabilities to create reports and analysis, interactive dashboards to improve evidence-based decision-making and strategic planning. This can be demonstrated through continued use of NDW data for country operational planning (COP) from the year 2017, the annual reporting of HIV cohort reports from the year 2016, in the verification of the national DQA in 2018 and the consistency of data needs used for measuring indicator performance across various implementation in the HIV domain.

Data from the EMRs is extracted from the EMR through the Extract, Transform and Load (ETL) process. This process is made simple through a multi-platform web-based Data Warehouse API (DWAPI) tool developed by KeHMIS team. DWAPI is installed at the EMR implementing facilities and extracts data from EMR databases, runs de-duplication and data quality routines before securely transmitting the extract to an API at NDW staging area for further processing.  A deduplication algorithm is defined both at the facility and warehouse level to enhance data quality through duplicates identification for unique patient categorization.

The project supports a single point of truth (SPOT) that is ideally used to showcase the uploads and metrics in real time. This suffices as the first point of upload verification and facility upload status point.

We are proud to work with NASCOP on behalf of MoH in actualizing this.