ASEAN Countries’ Life and Death Expectancy Visualization Dashboard
DOI:
https://doi.org/10.24191/jcrinn.v10i1.506Keywords:
dashboard visualization, data visualization, deaths, ASEAN, life expectancyAbstract
Death is the complete cessation of life processes that every living thing experiences at some point. It is influenced by various factors, including biological, behavioral, and societal determinants. Big data and data visualization are essential tools for understanding complex datasets and making informed decisions. This study focuses on life and death expectancy in ASEAN countries, aiming to address increasing rates of heart diseases, cancer, accidents, and infectious diseases by developing an interactive dashboard using Power BI. Despite available data, there is a lack of user-friendly dashboards that inform the public about causes of death, contributing to a lack of awareness and preventive measures. The objective is to identify trends and patterns in life and death expectancy, design and develop a dashboard, and evaluate its usability. The research scope includes collecting data from official sources like the Department of Statistics Malaysia and Kaggle and classifying the causes of death into meaningful categories. The significance of this study lies in providing accessible information to the public, raising awareness about health issues, and aiding individuals and governments in making informed health decisions. By highlighting health disparities and informing public health policies, the dashboard aims to improve healthcare systems and overall quality of life in ASEAN countries. This research follows the Waterfall Model, including planning, design, development, implementation, and evaluation phases. The process involves extracting, loading, and transforming data through Apache Hive. Microsoft Power BI is used to visualize the data extracted from the warehouse. The dashboard was evaluated by 40 respondents to validate its functionality, usability, and overall performance. Positive feedback highlights its potential as a valuable tool for public health in ASEAN countries.
Downloads
References
Ahmed, S. K., Mohamed, M. G., Abdulqadir, S. O., El–Kader, R. G. A., El‐Shall, N. A., Chandran, D., Rehman, M. E. U., & Dhama, K. (2023). Road traffic accidental injuries and deaths: A neglected global health issue. Health Science Reports, 6(5). https://doi.org/10.1002/hsr2.1240
Chidambaranathan-Reghupaty, S., Fisher, P. B., & Sarkar, D. (2021). Hepatocellular carcinoma (HCC): Epidemiology, etiology and molecular classification. Advances in Cancer Research, 1–61. https://doi.org/10.1016/bs.acr.2020.10.001
Dong, E., Ratcliff, J., Goyea, T. D., Katz, A., Lau, R. M., Ng, T. K., Garcia, B., Bolt, E., Prata, S., Zhang, D., Murray, R. C., Blake, M. R., Du, H., Ganjkhanloo, F., Ahmadi, F., Williams, J. D., Choudhury, S., & Gardner, L. (2022). The Johns Hopkins University Center for Systems Science and Engineering COVID-19 Dashboard: Data collection process, challenges faced, and lessons learned. Lancet Infectious Diseases, 22(12), e370–e376. https://doi.org/10.1016/s1473-3099(22)00434-0
Hamidi, S. R., Lokman, A. M., Shuhidan, S. M., & Hilmi, M. I. M. N. (2020). CancerMAS Dashboard: Data Visualization of cancer cases in Malaysia. Journal of Physics, 1529(2), 022019. https://doi.org/10.1088/1742-6596/1529/2/022019
Life expectancy & deaths Overview. (2023, July 11). Australian Institute of Health and Welfare. https://www.aihw.gov.au/reports-data/health-conditions-disability-deaths/life-expectancy-deaths/overview
Nguyen, T. T., & Trevisan, M. (2020). Vietnam a country in transition: Health challenges. BMJ Nutrition, Prevention & Health, 3(1), 60–66. https://doi.org/10.1136/bmjnph-2020-000069
Rahman, M., Islam, M. R., Akter, S., Akter, S., Islam, L., & Xu, G. (2021). DiaVis: Exploration and analysis of diabetes through visual interactive system. Human-Centric Intelligent Systems, 1(3–4), 75. https://doi.org/10.2991/hcis.k.211025.001
Tai, S., Chi, Y., Chien, Y. W., Kawachi, I., & Lu, T. (2023). Dashboard with bump charts to visualize the changes in the rankings of leading causes of death according to two lists: National Population-Based Time-Series Cross-Sectional study. JMIR Public Health and Surveillance, 9, e42149. https://doi.org/10.2196/42149
Thudumu, S., Branch, P., Jin, J., & Singh, J. J. (2020). A comprehensive survey of anomaly detection techniques for high dimensional big data. Journal of Big Data, 7(1). https://doi.org/10.1186/s40537-020-00320-x
World Health Organization: WHO. (2019, May 13). Diabetes. https://www.who.int/health-topics/diabetes
Yadav, C. P., & Sharma, A. (2022). National Institute of Malaria Research-Malaria Dashboard (NIMR-MDB): A digital platform for analysis and visualization of epidemiological data. The Lancet Regional Health - Europe, 5, 100030. https://doi.org/10.1016/j.lansea.2022.100030
Zeng, B., Perel, P., Mensah, G. A., & Ezzati, M. (2021). Global epidemiology, health burden and effective interventions for elevated blood pressure and hypertension. Nature Reviews Cardiology, 18(11), 785–802. https://doi.org/10.1038/s41569-021-00559-8