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

Radityo Prasetianto Wibowo, Wiwik Anggraeni, Tresnaning Arifiyah, Edwin Riksakomara, Febriliyan Samopa, Pujiadi Pujiadi, Siti Aminatus Zehroh, Nur Aini Lestari

Abstract views = 1940 times | downloads = 985 times


 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.

Full Text:



H. Ministry, "Pusat Data dan Informasikementerian Kesehatan Republik Indonesia," Indonesian Government, 28 NOVEMBER 2018. [Online]. Available: [Accessed 25 MARCH 2020].

D. K. K. Malang, "Dinas Kesehatan," 2016. [Online]. Available:

T. Arifiyah, "Pembuatan Sistem Pendukung Keputusan Berbasis Decision Tree Untuk Penentuan Keputusan Tindakan Mitigasi Penanganan Demam Berdarah Dengue di Kabupaten Malang," 2018.

C. Chen, "Online platform for applying space–time scan statistics for prospectively detecting emerging hot spots of dengue fever," International Journal of Health Geographics, 2016.

N. Mathur, V. S. Asirvadam, S. C. Dass and B. S. Gill, "Visualization of dengue incidences using expectation maximization (EM) algorithm," in International Conference on Intelligent and Advanced Systems (ICIAS), 2016.

J. M. Jamil, I. N. M. Shahranee and V. C. Yung, "An Innovative Data Mining and Dashboard System for Monitoring of Malaysian Dengue Trends," Journal of Telecommunication, Electronic and Computer Engineering (JTEC), vol. 8, pp. 1-4.

N. Martina, J. Bergsa, D. Eerdekensa, B. Depairea and S. Verelstb, "Developing an emergency department crowding dashboard: A design science approach," International Emergency Nursing, vol. 39, pp. 68-76, 2018.

W. Bonney, "Applicability of Business Intelligence in Electronic Health Record," Procedia-Social and Behavioral Sciences, vol. 73, pp. 257-262, 2013.

A. Pereira, F. Portela, M. F. Santos, J. Machado and A. Abelha, "Pervasive Business Intelligence: A new trend in Critical Healthcare," Procedia Computer Science, vol. 98, pp. 362-367, 2016.

R. Matheus, M. Janssen and D. Maheshwari, "Data science empowering the public: Data-driven dashboards for transparent and accountable decision-making in smart cities," Government Information Quarterly, 2018.

A. Franklina, S. Gantelaa and S. Shifarraw, "Dashboard visualizations: Supporting real-time throughput decision-making," Journal of Biomedical Informatics, vol. 71, pp. 211-221, 2017.

A. Haasbroek, J. J.Strydom, J. T.McCoy and L. Auret, "Fault Diagnosis for an Industrial High Pressure Leaching Process with a Monitoring Dashboard," IFAC-PapersOnLine, vol. 51, no. 21, pp. 117-122, 2018.

R. R. William A. Mattinglya, "Real-time enrollment dashboard for multisite clinical trials," Contemporary Clinical Trials Communications, vol. 1, pp. 17-21, 2015.

P. F. Kurnia and Suharjito, "Business Intelligence Model to Analyze Social Media Information," Procedia Computer Science, vol. 135, pp. 5-14, 2018.

C. M. Olszak and E. Ziemba, "Approach to Building and Implementing Business Intelligence Systems," vol. 2, 2017.

"Wikipedia," [Online]. Available: [Accessed 29 03 2020].

S. Hasso Plattner, P. Anja Bog, B. Jan Schaffner, B. Jens Kreuger and B. Alexander Zeier, "ETL-Less Zero-Redundancy System and Method For Reporting Oltp Data". United States of America Patent US 9,626.421 B2, 18 04 2017.

C. Lennerholt, J. van Laere and E. Söderström, "Implementation challenges of Self Service Business Intelligence: A literature review," in Annual Hawaii International Conference on System Sciences, 2018.

H. Baars and H.-G. Kemper, "Business Intelligence in the Cloud?," in Pacific Asia Conference on Information Systems, 2010.

W. Yeoh and A. Koronios, "Critical Success Factors Forbusiness Intelligence Systems," Journal of Computer Information Systems, 2010.

E. Ziemba and C. M. Olszak, "Critical Success Factors for Implementing Business Intelligence Systems in Small and Medium Enterprises on the Example of Upper Silesia, Poland," Interdisciplinary Journal of Information, Knowledge, and Management, vol. 7, 2012.


  • There are currently no refbacks.

Copyright (c) 2020 The Authors. Published by Universitas Airlangga

Creative Commons License
This work is licensed under a Creative Commons Attribution 4.0 International License.

ISSN 2443-2555 (online) 2598-6333 (print). Published by Universitas Airlangga.
 All article published in JISEBI are open access and under the CC BY license (