Establishing Data Warehouse to Improve Standardize Health Care Delivery: A Protocol Development in Jakarta City

TL;DR

This paper describes the development of a data warehouse in Jakarta to standardize health care delivery data collection, improving efficiency and data consistency using the DHIS-2 platform, with initial implementation in 2021.

Contribution

It introduces a new integrated data warehouse system for Jakarta's health data, utilizing DHIS-2, and details the implementation process and benefits for standardizing health care data collection.

Findings

Faster data collection and presentation compared to conventional systems.

Reduced data contradictions between health programs.

Successful initial implementation and adaptation in 2021.

Abstract

Jakarta is a metropolitan city and among the most dense city in Indonesia. Jakarta has 12 major indicators of standardize health care delivery (Standard Pelayanan Minimum or SPM) derivates from Ministry of Health consists of services related to maternal and neonatal health, school-aged population, working-age population, elderly population, some specific conditions (hypertension, diabetes, tuberculosis, HIV), and also mental health. We planned to construct a data warehouse to provide a single integrated data center. In the first phase (2021), we improve the system by giving responsibility to the health Sub Department of Health of Administrative City for direct data input into a data warehouse. This period also let an introduction and adaptation to new data collection schemes by using a single entry for the first time. The basic platform use for this system is District Health Information System 2 (DHIS-2), an open-source platform that has been used worldwide, including Ministry of Health Republic of Indonesia. The major advantage of this data warehouse is the simplicity and convenience to collect a wide data from a different source and presenting it faster than using the conventional system. Less data contradiction was also found between health programs with intersecting data. During this transition phase, a double-work is made as data should be input to both the DHIS-2 system by Jakarta and the National Ministry of Health system, but an integration process is ongoing, and hopefully that in 2022 single data entry can be established.