BUSINESS INTELEGENCE MONITORING SYSTEM OF MEDICINE AND MEDICAL EQUIPMENT INVENTORY AT BAPTIS BATU MALANG HOSPITAL

CUKUP ABADI

Abstract

An increase in the income level of the population causes the demand for health services to increase and affects the increase in the cost of health services. This needs to be balanced with the increasing public health status. One of the improvement processes is by implementing the BI system in the Batu Baptist Hospital Pharmacy. The method used is implementing the BI system at Batu Baptist Hospital to support quality in strategic decision making. The BI system for drug and medical equipment inventory can be accessed by two types of users, namely admin and warehouse manager/pharmacist. Each of these actors can operate the system according to the access rights they have. Admin can make ETL, and manage BI System dashboard for medicine and medical equipment inventory. The results of the dashboard can later be seen by the warehouse manager/pharmacist. BI development to assist decision making at Batu Baptist Hospital Malang through several stages: data warehouse modeling, ETL process, pentaho application connection with tables, and BI dashboard visualization design. The BI dashboard that has been visualized is a graph of the comparison of drugs and outgoing drugs, a comparison graph of medical device supplies and the use of medical devices, trend graphs so that the expenditure of medical devices in a given month can be used as a manager's consideration for adding medical equipment supplies based on the needs of the most widely used medical equipment. per month in one year.

Full Text:

PDF

References

Abusweilem, M. A., & Abualous, S. “The impact of knowledge management process and ….business intelligence on organizational performance. Management Science Letters”, Hal. 2143–2156, 2019.

Azemi, N. A., Zaidi, H., & Hussin, N. “Information Quality in Organization for Better Decision Making“. International Journal of Academic Research in Business And Social Sciences, Vol. 7 No. 12, Hal. 429-437, 2018.

Trieu, V.-H. T., Cockcroft, S., & Perdana, A. “Decision-Making Performance in Big Data Era: The Role of Actual Business Intelligence Systems Use and Affecting External Constraints “. Research-in-Progress Papers ECIS 2018 Proceedings, Vol. 12. 2018.

Vayena, E., Dzenowagis, J., Brownstein, J. S., & Sheikh, A. “Policy implications of big data in the health sector”. Bulletin of the World Health Organization, Vol. 96 No. 1, Hal. 66–68. 2018.

T. V.Y., R. G., and P. J., “Penerapan Sistem Informasi Rumah Sakit X Kota Manado Dalam Perencanaan Ketenagaan Dan Peralatan Medik,” J. Kesmas, Vol. 8, no. 6, pp. 36–48, 2019.

M. R. Atsani, G. T. Anjari, and N. M. Saraswati, “Pengembangan Business Intelligence Di Rumah Sakit (Studi Kasus: Rsud Prof. Dr. Margono Soekarjo Purwokerto),” J. Telemat., vol. 12, No. 2, pp. 124–138, 2019.

A. Maulana and D. A. N. Wulandari, “Business Intelligence Implementation To Analyze Perfect Store Data Using the OLAP Method,” Sinkron, vol. 3, no. 2, pp. 103–109, 2019.

J. P. New, D. Leather, N. D. Bakerly, J. McCrae, and J. M. Gibson, “Putting patients in control of data from electronic health records,” Br. Med. J., 2018.

Darman, R. “Pembangunan Dashboard Lokasi Rawan Tanah Longsor di Indonesia Menggunakan Tableau”. Jurnal Teknik Informatika Dan Sistem Informasi, Vol. 4 No. 2, Hal. 256–269. 2018.

Haekal, M. F., Supian, M., & Sabrina, W. “Efektivitas Penetapan PSBB Dalam Menurunkan Perilaku Konsumtif Masyarakat Pada Masa Covid-19”. Jurnal Kajian Ilmiah, V. 1 No.1, 93–98. 2020.

Syarli, S., Tamin, R., & Qashlim, A. “Perancangan Business Intelligence System Pada Gudang Farmasi Dinas Kesehatan Kabupaten Mamasa “. Jurnal Keteknikan Dan Sains. JUTEKS), Vol.1 No.1, Hal. 7–14, 2018.

Yunus, N. R., & Rezki, A. Kebijakan pemberlakuan lock down sebagai antisipasi penyebaran corona virus Covid-19. Salam: Jurnal Sosial Dan Budaya Syar-I, Vol.7 No.03, Hal. 227–238, 2020.

Riksazany, R., & Ayub, M. “Eksplorasi Data Warehouse Penjualan dengan Tableau.” Jurnal STRATEGI-Jurnal Maranatha, Vol. 1 No.2, 574–584, 2019.

Rizaldy, I. “Sistem Pendukung Keputusan (SPK) Penentuan Kabupaten yang Terkena Corona Virus Disease19 (Covid19) Untuk Pemberlakuan Sistem Pembatasan Sosial Berskala Besar (PSBB) dengan Menggunakan Metode Topsis. ” 2020.

Lin, L., & Hou, Z. “Combat COVID-19 with artificial intelligence and big data.” Journal of Travel Medicine, Vol. 27 No.5, 2020.

Yunus, N. R., & Rezki, A. Kebijakan pemberlakuan lock down sebagai

antisipasi penyebaran corona virus Covid-19. Salam: Jurnal Sosial Dan

Budaya Syar-I, Vol.7 No.03, Hal. 227–238, 2020.

Riksazany, R., & Ayub, M. “Eksplorasi Data Warehouse Penjualan dengan

Tableau.” Jurnal STRATEGI-Jurnal Maranatha, Vol. 1 No.2, 574–584, 2019.

Rizaldy, I. “Sistem Pendukung Keputusan (SPK) Penentuan Kabupaten

yang Terkena Corona Virus Disease19 (Covid19) Untuk Pemberlakuan

Sistem Pembatasan Sosial Berskala Besar (PSBB) dengan Menggunakan

Metode Topsis. ” 2020.

Lin, L., & Hou, Z. “Combat COVID-19 with artificial intelligence

and big data.” Journal of Travel Medicine, Vol. 27 No.5, 2020.

DOI

https://doi.org/10.21107/ijseit.v7i1.17358

Metrics

Refbacks

  • There are currently no refbacks.


Copyright (c) 2022 CUKUP ABADI

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