Abstract
Background: Indonesia has 150 dengue cases every month, and more than one person dies every day from 2017 to 2020. One of the factors of Dengue Hemorrhagic Fever (DHF) patients dying is due to the late handling of patients in hospitals or clinics. Health Office of Malang Regency recorded 1,114 cases of DHF that occurred during 2016, and the number of patients room available is limited. Therefore, Malang Regency is used as a case study in this research.Objective: This study aims to make a dashboard to display the predictions, visualize the distribution of DHF patients, and give mitigation recommendations for handling DHF patients in Malang Health Office.Methods: This study used the Business Intelligence (BI) Development method, which consists of two main phases, namely the making of Business Intelligence and the use of Business Intelligence. This research used the making of the BI phase, which consists of four stages, which are BI development strategies, identification and preparation of data sources, selecting BI tools, and designing and implementing BI. In the Extract, Load, and Transform process, this study used essential transformation and forecast.Results: BI method has succeeded in building the dashboard. The dashboard displays the visualization of Dengue Hemorrhagic Fever predicted results, detail of Dengue Fever Patient number, Dengue Fever patient trends per year and predictions 2 Monthly patient, and mitigation recommendation for each Community Health Office.Conclusion: We have built the BI Dashboard using the BI development method. It needs some treatment to get better performance. These are improving ETL performance using data virtualization technology, considering the use of cloud computing technology, conducting further evaluations by understanding the critical success factors to determine the level of success and weaknesses.
Highlights
Indonesia has recorded tens of thousands of dengue cases every year
We made a dashboard which visualized forecasts and map of Dengue Hemorrhagic Fever (DHF) patients distribution. This prediction is based on the total patient number from previous SP2TP system (Reporting and Recording System of Community Health Center) which is an application for recording DHF patients in Malang district, seasons such as rain, temperature, and humidity, patient increment status, and the results of Epidemiological Investigations (PE)
The identification and preparation of the data sources that needed to build Business Intelligence are explained in more detail in the data collection section, where the data that used in this study comes from two primary sources, namely the Integrated Puskesmas Recording and Reporting System (SP2TP) owned by the Malang Regency Health Office and Meteorology, Climatology, and Geophysical Agency (BMKG) website
Summary
Indonesia has recorded tens of thousands of dengue cases every year. In 2017 there were 68,407 cases with 493 deaths. Health Office of Malang Regency recorded 1,114 cases of Dengue Hemorrhagic Fever (DHF) that occurred during the year 2016 with the largest number of patients in the eastern part of the district of Wajak and Tajinan. A map of the distribution of dengue patients in each Community Health Center displays them on a visual dashboard to help make decision systems become faster and prepare for medical facilities better handling of DHF patients so that it can reduce mortality. To overcome this problem, we made a dashboard which visualized forecasts and map of DHF patients distribution. These are improving ETL performance using data virtualization technology, considering the use of cloud computing technology, conducting further evaluations by understanding the critical success factors to determine the level of success and weaknesses
Sign-in/Register to view highlights & summary Sign-in/Register to access full text options 
Free) 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a call
