Business Intelligence Development in Distributed Information Systems to Visualized Predicting and Give Recommendation for Handling Dengue Hemorrhagic Fever

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.