Using Power BI and SQL for Predictive Health Data Analytics to Improve Decision-Making and Performance Tracking in Public Health Systems

Chijioke Ronald Nwokocha, Olaide Oluwatobi Ogundolapo and Michael Misan Eji

International Journal of Scientific Research in Computer Science, Engineering and Information Technology, 2025, vol. 11, issue 6, 422-444

Abstract: This review examines how SQL-based data engineering and Power BI-driven predictive analytics can transform public health decision-making by enabling real-time monitoring, forecasting, and performance optimization across complex health systems. It synthesizes how mature data pipelines, rigorous governance, and advanced feature engineering such as lags, rolling averages, seasonality markers, and spatial aggregation support critical use cases including outbreak early warning, patient flow prediction, stock-out risk identification, and staffing optimization. The paper further evaluates model integration pathways such as AutoML, Python/R, Azure Machine Learning, and in-database scoring, alongside dashboard architectures that incorporate KPI scorecards, drill-throughs, geospatial mapping, and cohort analytics to enhance insight delivery and executive action. Validation considerations including fairness, interpretability, drift detection, and recalibration are explored, as well as implementation strategies involving stakeholder alignment, change management, and analytics maturity frameworks. Finally, the review highlights persistent challenges in data quality, infrastructure, and workforce capacity, and highlights the necessity of privacy-by-design, responsible AI, and equity-centered analytics. Overall, the study provides a concise roadmap for scalable, ethical, and effective deployment of predictive analytics within public health systems.

Keywords: Predictive Analytics; Public Health Systems; SQL Data Engineering; Power BI Dashboards; Health Decision-Making (search for similar items in EconPapers)
Date: 2025
Note: Article URL: https://ijsrcseit.com/home/article/view/CSEIT2511662
References: Add references at CitEc
Citations:

Downloads: (external link)
https://ijsrcseit.com/home/article/view/CSEIT2511662 Article URL (text/html)
https://ijsrcseit.com/home/article/download/CSEIT2511662/CSEIT2511662 Full text (application/pdf)

Related works:
This item may be available elsewhere in EconPapers: Search for items with the same title.

Export reference: BibTeX RIS (EndNote, ProCite, RefMan) HTML/Text

Persistent link: https://EconPapers.repec.org/RePEc:jbh:ijsrcs:v11:y2025:i6:id:1817

DOI: 10.32628/CSEIT2511662

Access Statistics for this article

More articles in International Journal of Scientific Research in Computer Science, Engineering and Information Technology from International Journal of Scientific Research in Computer Science, Engineering and Information Technology
Bibliographic data for series maintained by Pankaj Sharma (USA) ().