INTEGRATING DATA ENGINEERING, EXPLORATORY ANALYSIS, AND PREDICTIVE MODELING FOR CARDIOVASCULAR DISEASE RISK STRATIFICATION AND EMERGENCY DEPARTMENT CAPACITY PLANNING

Olawale Ajibola Ashaolu

doi:10.5281/zenodo.22840377

Abstract

Cardiovascular disease remains a major healthcare burden, requiring health systems to identify high-risk patients
while simultaneously maintaining sufficient emergency capacity for fluctuating clinical demand. Increasing
volumes of heterogeneous healthcare data provide opportunities to integrate patient-level risk intelligence with
operational planning, yet fragmented data architectures frequently limit effective analytical deployment. This
study develops an integrated framework combining scalable data engineering, exploratory analysis, predictive
modeling, and emergency department capacity forecasting. Structured clinical records, laboratory measurements,
demographics, vital signs, medication histories, utilization records, and unstructured clinical information are
consolidated through a standardized data engineering pipeline supporting quality validation and analytical
readiness. Statistical and visual exploratory analyses characterize cardiovascular risk distributions, variable
relationships, temporal patterns, and clinically relevant population differences. Predictive models subsequently
estimate patient-level cardiovascular risk and stratify individuals into actionable risk categories. Aggregated risk
predictions and historical utilization patterns are incorporated into emergency department demand forecasting to
estimate anticipated workload and inform staffing, bed capacity, monitoring requirements, and resource allocation.
The framework establishes a unified analytical pathway connecting clinical risk prediction with operational
decision support for proactive healthcare planning.

Keywords

Cardiovascular Disease Risk; Data Engineering; Exploratory Data Analysis; Predictive Modeling; Emergency

References

1) Xue F, Han P, Luo Y, Zhao S. Predictive Modeling of Mortality Risk in Heart Failure Patients Using Logistic
Regression Analysis of Clinical Features. Engineering Frontiers. 2025 Dec 2;1(1).
2) Peggy OO, Aremu BK. Integrating Multimodal Patient Data and Business Intelligence for Strategic
Healthcare Service Optimization and Value-Based Delivery. Int J Adv Res Publ Rev. 2025;2:422-42.
3) Ananthajothi K, David J, Kavin A. Cardiovascular Disease Prediction Using Langchain. In2024 International
Conference on Advances in Computing, Communication and Applied Informatics (ACCAI) 2024 May 9 (pp.
1-6). IEEE.
4) Wahid MF, Tafreshi R, Al-Hijji M, Abi Khalil C. A Machine Learning Approach to Predictive Modeling of
Cardiovascular Events. In2025 47th Annual International Conference of the IEEE Engineering in Medicine
and Biology Society (EMBC) 2025 Jul 14 (pp. 1-4). IEEE.
5) Boulmpou A, Moysiadis T, Zormpas G, Teperikidis E, Vassilikos V, Giannakoulas G, Papadopoulos C.
Exploring the Feasibility of Integrating Cardiopulmonary Exercise Testing, Echocardiography, and
Biomarkers for Predicting Atrial Fibrillation Recurrence: Rationale, Design and Protocol for a Prospective
Cohort Study (The PLACEBO Trial). Journal of Clinical Medicine. 2025 Mar 3;14(5):1690.
6) Sri KN, Meghana P, Pranathi K, Iswarya GV, Velmurugan AK, Kumar AD. Predictive Modeling for
Cardiovascular Health: Unveiling Insights, Enhancing Interpretability, and Charting Future Trajectories.
In2024 8th International Conference on Inventive Systems and Control (ICISC) 2024 Jul 29 (pp. 163-167).
IEEE.
7) Chukwunweike J. Coordinating PLC-based load shedding and variable-speed drives to prevent transformer
overloading during industrial production peaks. Int J Electr Data Commun. 2025;6(2 Pt B):118-135.
doi:10.22271/27083969.2025.v6.i2b.109.
8) Salami, A.A.M., Al-Anazi, K.H.S., Al-Anazi, M.M.S., Al-Otaibi, F.N.M., Haqawi, A.Y.J., Al-Otaibi,
K.N.B., Al-Anzi, S.M.N., Aljabri, A.M., Alharbi, T.A., Al-Anazi, N.K. and Al Shammari, A.M., 2025.
Artificial Intelligence Applications in Prehospital Emergency Care, Epidemiology, Health Information
Management, Paramedic Practice, and Health Assistant Services. International Journal of Aquatic Research
and Environmental Studies, 5(S2), pp.80-89.
9) Sharon John AS, Alagendran S, Sivaprakasam B, Mohan Ramaswamy MK, Selvaraj K, Ramanathan S,
Velam Chokkalingam P, Ravindran N, Suvaiyarasan S. Impact of artificial intelligence and digital twin
technology on cardiovascular disease diagnosis and management challenges and future directions. World
Academy of Sciences Journal. 2025 Jun 16;7(4):75.
10) Hossain MZ, Khan MM, Islam R, Nahar K, Kabir MF. Formulation of a multi-disease comorbidity prediction
framework: A data-driven case analysis on of diabetes, hypertension, and cardiovascular risk trajectories.
Journal of Computer Science and Technology Studies. 2023 Jul 25;5(3):161-82.
11) Pai RR, Pendyala JP. Optimizing Healthcare Pipelines for Patient Benefit: A Data Engineering Perspectives
on Preauthorization Delays and Denials. InInternational Conference on Software Engineering and Data
Engineering 2025 Oct 13 (pp. 40-52). Cham: Springer Nature Switzerland.
12) Khanna A, Singh P, Kaur I. Predictive analytics for cardiovascular health: A machine learning approach.
In2024 International Conference on Advances in Modern Age Technologies for Health and Engineering
Science (AMATHE) 2024 May 16 (pp. 1-6). IEEE.
13) Ahmed S, Haque MM, Hossain SF, Akter S, Al Amin M, Liza IA, Hasan E. Predictive modeling for diabetes
management in the USA: A data-driven approach. Journal of Medical and Health Studies. 2024;5(4):214-28.
14) Harikrishna T. Quantum-Enhanced Federated Learning with Explainable Multimodal Intelligence for Heart
Disease Risk Stratification, Progression Analysis, and Personalized Care. In2025 9th International
Conference on Electronics, Communication and Aerospace Technology (ICECA) 2025 Nov 5 (pp. 858-868).
IEEE.
15) Magajiaka J, Adesanmi B. Lifecycle cost and resilience performance evaluation of climate-resilient urban
road infrastructure under climate risk scenarios. International Journal of Current Research. 2026;18(5):37242-
37251.
16) Ejiyi CJ, Qin Z, Nneji GU, Monday HN, Agbesi VK, Ejiyi MB, Ejiyi TU, Bamisile OO. Enhanced
cardiovascular disease prediction modelling using machine learning techniques: a focus on cardiovitalnet.
Network: Computation in Neural Systems. 2025 Jul 3;36(3):716-48.
17) Ananthajothi K, David J, Kavin A. Cardiovascular Disease Prediction Using Langchain. In2024 International
Conference on Advances in Computing, Communication and Applied Informatics (ACCAI) 2024 May 9 (pp.
1-6). IEEE.
18) Hadi W, Jaware T, Khalifa T, Aburub F, Ali N, Saini R. Enhancing cardiovascular disease detection through
exploratory predictive modeling using DenseNet-Based deep learning. Computers. 2025 Aug 15;14(8):330.
19) Devi EP, Sharma HK, Bhandari G. Advancing Cardiovascular Health Risk Assessment: A Comprehensive
Study on Heart Attack Prediction Using. Innovative Computing and Communications: Proceedings of ICICC
2025, Volume 2. 2025 Sep 26;2:287.
20) Uddin MM, Sarker MT. THE ROLE OF PREDICTIVE ANALYTICS IN EARLY DISEASE DETECTION:
A DATA DRIVEN APPROACH TO PREVENTIVE HEALTHCARE. AIM INTERNATIONAL LLC
Publisher. 2024 Jan 1.
21) Kissi SA, Talukder MG, Iqbal MZ. Data-driven predictive modelling of lifestyle risk factors for
cardiovascular health. Electronics. 2025 Jul 20;14(14):2906.
22) Racheal Kikachukwu Ogan. Machine-learning-based API failure prediction and root-cause analytics for
improving reliability of enterprise banking integration architectures at scale. Int J Comput Artif Intell
2021;2(2):142-153. DOI: 10.33545/27076571.2021.v2.i2a.378
23) Priyanka Devi E, Sharma HK, Bhandari G. Advancing Cardiovascular Health Risk Assessment: A
Comprehensive Study on Heart Attack Prediction Using XGBoost Models and Cross-Validation.
InInternational Conference On Innovative Computing And Communication 2025 Feb 14 (pp. 287-298).
Singapore: Springer Nature Singapore.
24) Ananthajothi K, David J, Kavin A. Cardiovascular disease prediction using patient history and real time
monitoring. In2024 2nd International Conference on Intelligent Data Communication Technologies and
Internet of Things (IDCIoT) 2024 Jan 4 (pp. 1226-1233). IEEE.
25) Sem LX, Chua HN, Jasser MB, Wong RT, ALDharhani GS. Enhancing Cardiovascular Disease Analytics
with Demographic and Behavioral Risk Features through Unsupervised and Ensemble Learning Techniques.
In2024 IEEE 12th Conference on Systems, Process & Control (ICSPC) 2024 Dec 7 (pp. 304-309). IEEE.
26) Toffaha K. USING MACHINE LEARNING APPROACHES FOR RISK PREDICTION AND
STRATIFICATION IN HEALTHCARE (Doctoral dissertation, Khalifa University of Science).
27) Mukherjee UK, Ye H, Chhajed D. Encounter decisions for patients with diverse sociodemographic
characteristics: predictive analytics of EMR data from a large chain of clinics. Journal of Operations
Management. 2025 Jun;71(4):447-82.
28) Nahar K, Hossain MZ, Islam R, Khan MM, Hossain MS. Operationalizing Predictive Modeling in Clinical
Workflows: Design, Integration, and Validation of Decision Support Mechanisms within US Healthcare
Infrastructure. Frontiers in Computer Science and Artificial Intelligence. 2024 Dec 29;3(2):37-45.
29) Moreno-Sánchez PA, Aalto M, van Gils M. Prediction of patient flow in the emergency department using
explainable artificial intelligence. Digital health. 2024 Jul;10:20552076241264194.
30) Nyavor H. Predictive modeling of cardiovascular disease progression using biomarkers and machine learning
algorithms. International Journal of Advance Research Publication and Reviews. 2025;2(4):55-77.
31) Ogan RK. Risk-based API governance for predicting integration failures, security anomalies, and service
degradation across hybrid enterprise application environments. Int J Finance Manage Econ. 2024;7(2):871-
882. doi:10.33545/26179210.2024.v7.i2.946.
32) Obasi C. Forecasting Cardiovascular Diseases of Adult Patients in Emergency Department Using Ai
Models (Doctoral dissertation, King Fahd University of Petroleum and Minerals).
33) Hossain MZ, Khan MM, Islam R, Nahar K, Kabir MF. Formulation of a multi-disease comorbidity prediction
framework: A data-driven case analysis on of diabetes, hypertension, and cardiovascular risk trajectories.
Journal of Computer Science and Technology Studies. 2023 Jul 25;5(3):161-82.
34) Kuppuswamy P, Mohan M, Al Khalidi SQ, Prakash VV. Predictive Analytics Tools and Techniques for
Disease Prevention and Early Detection in Healthcare Sector. InAdvancing Healthcare Through Data-Driven
Innovations 2024 Dec 19 (pp. 28-49). CRC Press.
35) Singarathnam D, Ganesan S, Pokhrel S, Somasiri N. Machine learning-based predictive models for
cardiovascular risk assessment in data analysis, model development, and clinical implications. International
Journal of Recent Advances in Multidisciplinary Research. 2023 Oct 30;10(10):9084-9.
36) Liu T, Krentz AJ, Huo Z, Ćurčin V. Opportunities and challenges of cardiovascular disease risk prediction
for primary prevention using machine learning and electronic health records: a systematic review. Reviews
in Cardiovascular Medicine. 2025 Apr 25;26(4):37443.
37) Khan H, Alam A, Bouid H, Kamawal H, Hozaifa M. Predictive Analytics in Chronic Disease Management
Using AI to Enhance Cardiovascular Health and Patient Record Outcomes. Innovative Research Journal of
Artificial Intelligence. 2024 Dec 31;2(2).
38) Bhowmik PK, Miah MN, Uddin MK, Sizan MM, Pant L, Islam MR, Gurung N. Advancing heart disease
prediction through machine learning: Techniques and insights for improved cardiovascular health. British
Journal of Nursing Studies. 2024 Oct 1;4(2):35-50.
39) MGBAJIAKA, JOHNBOSCO. 2025. “Co-Designing Resilient Infrastructure: Participatory Approaches for
Sustainable Implementation”. Current Journal of Applied Science and Technology 44 (8):11-17.
https://doi.org/10.9734/cjast/2025/v44i84586.
40) Liza IA, Hossain SF, Saima AM, Akter S, Akter R, Al Amin M, Akter M, Marzan A. Heart disease risk
prediction using machine learning: A data-driven approach for early diagnosis and prevention. British Journal
of Nursing Studies. 2025 May 12;5(1):38-54.