Version 1
: Received: 26 June 2024 / Approved: 26 June 2024 / Online: 27 June 2024 (00:01:54 CEST)
How to cite:
Obbo, A.; Wasswa, W.; Basaza-Ejiri, A. Leveraging Data Warehousing for Healthcare Delivery – A case of Outpatient Department. Preprints2024, 2024061899. https://doi.org/10.20944/preprints202406.1899.v1
Obbo, A.; Wasswa, W.; Basaza-Ejiri, A. Leveraging Data Warehousing for Healthcare Delivery – A case of Outpatient Department. Preprints 2024, 2024061899. https://doi.org/10.20944/preprints202406.1899.v1
Obbo, A.; Wasswa, W.; Basaza-Ejiri, A. Leveraging Data Warehousing for Healthcare Delivery – A case of Outpatient Department. Preprints2024, 2024061899. https://doi.org/10.20944/preprints202406.1899.v1
APA Style
Obbo, A., Wasswa, W., & Basaza-Ejiri, A. (2024). Leveraging Data Warehousing for Healthcare Delivery – A case of Outpatient Department. Preprints. https://doi.org/10.20944/preprints202406.1899.v1
Chicago/Turabian Style
Obbo, A., William Wasswa and Annabella Basaza-Ejiri. 2024 "Leveraging Data Warehousing for Healthcare Delivery – A case of Outpatient Department" Preprints. https://doi.org/10.20944/preprints202406.1899.v1
Abstract
Mortality rates in sub-Saharan Africa remains unacceptably high, and disproportionately affecting economically disadvantaged communities. And healthcare delivery which is considered a major contributor to this is challenged by the limited resources and high service costs, prompting many patients to opt for outpatient department services. This study addresses the need for a data-driven approach to healthcare policy formulation by proposing a model for the implementation of a data warehousing system that integrates outpatients into the national healthcare framework. By leveraging data warehousing, healthcare delivery can be made more efficient through a robust repository that supports decision-making and policy formulation. The research focuses on the outpatient department in resource-scarce settings, proposing a novel multidimensional data model and practical framework implementation. The benefits include improved patient experiences, cost-effective service delivery, and enhanced patient management through electronic health records. Additionally, mobile apps are explored for patient navigation and reminders to enhance treatment adherence. The study’s results indicate that data warehousing can significantly improve healthcare delivery by consolidating critical data and facilitating better planning, resource allocation, and policy formulation. Ultimately, this approach offers valuable insights for optimizing healthcare systems in resource-constrained environments, enabling data-driven policies, and improving health outcomes across sub-Saharan Africa.
Keywords
Data Warehousing; Healthcare; Electronic health records; Outpatients
Subject
Public Health and Healthcare, Other
Copyright:
This is an open access article distributed under the Creative Commons Attribution License which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
