Implementation of Business Intelligence for Classifying Product Values and Revenue of UMKM at Diskopdagperin in Kuningan Regency Using Online Analytical Processing (OLAP) Technology
Keywords:
UMKM, Visualization, OLAP, Business Intelligence, TableauAbstract
UMKM have an important role in the economic development of the country. Kuningan Regency is one of the regencies in West Java with a significant number of UMKM, especially in the food sector. Department Cooperative UKM and Industry (Diskopdagperin) is responsible for implementing regional policies in the fields Cooperative UKM Trade and Industry. Department Cooperative UKM and Industry in Kuningan Regency often faces challenges with large, unstructured datasets that need to be analyzed. To analyze UMKM data in Kuningan Regency and monitor their development, a Business Intelligence (BI) analysis model is needed to manage the data effectively. The result of the analysis will be visualized by displaying dashboards or graphs to make it easier for the public to read data or information about UMKM development. This analysis will help UMKM practitioners predict their business prospects through the generated visualizations. This research processes data by implementing Online Analytical Processing (OLAP) technology with the assistance of the Tableau application to produce visualizations from processed data, providing information on the development of UMKM in Kuningan Regency, including business trends, regional trends, and turnover.
References
Al-Matari, E. M., & Al-Nahari, A. A. (2022). The Role of Business Intelligence in Enhancing SMEs Performance in Saudi Arabia. Journal of Small Business and Enterprise Development, 29(4), 654-676. https://doi.org/10.1108/JSBED-09-2020-0372
Ariyani, A., & Hidayat, A. (2021). Penerapan Business Intelligence sebagai Upaya Peningkatan Efektivitas UMKM di Kota Bandung. Jurnal Ilmiah Informatika, 9(3), 145-155. https://doi.org/10.30595/informatika.v9i3.5261
Basri, W. S., & Siam, M. R. A. (2020). The Impact of Business Intelligence on SME Performance in UAE. International Journal of Information Systems in the Service Sector, 12(2), 35-48. https://doi.org/10.4018/IJISSS.2020040103
Budiarto, R., et al. (2020). Business Intelligence for Enhancing Decision-Making in SMEs: A Case Study of Indonesian Small and Medium Enterprises. Journal of Business and Industrial Marketing, 35(8), 1341-1353. https://doi.org/10.1108/JBIM-03-2019-0114
Cahyani, I., & Hakim, L. (2021). Penerapan Data Analytics dalam Mengoptimalkan Perkembangan UMKM: Sebuah Tinjauan Studi di Jawa Barat. Jurnal Teknologi Informasi, 7(2), 101-110. https://doi.org/10.21831/jti.v7i2.33241
Casado-Belmonte, M. P., et al. (2021). Business Intelligence in Small and Medium Enterprises: The Case of Spanish SMEs. Technological Forecasting and Social Change, 170, 120885. https://doi.org/10.1016/j.techfore.2021.120885
Dar, A. H., & Gillani, S. (2019). Role of Big Data Analytics in SME Business Growth: An Insight from Pakistan. Journal of Business Research, 101, 437-447. https://doi.org/10.1016/j.jbusres.2019.03.035
Ekasari, M., & Purnamasari, A. (2020). Analisis Kinerja UMKM di Jawa Barat dengan Pendekatan Business Intelligence. Jurnal Akuntansi dan Manajemen Bisnis, 4(2), 229-240. https://doi.org/10.36741/jamb.v4i2.273
Gopal, R., & Deepa, N. (2020). Application of Business Intelligence Tools for Strategic Decision-Making in Small and Medium Enterprises. International Journal of Business Information Systems, 35(1), 94-112. https://doi.org/10.1504/IJBIS.2020.107824
Haryadi, E. S., et al. (2021). Peranan Visualisasi Data dalam Pengembangan UMKM: Studi Kasus di Yogyakarta. Jurnal Sistem Informasi, 17(1), 89-97. https://doi.org/10.21609/jsi.v17i1.8954
Janes, A., & Kasap, Z. (2019). Data-Driven Decision Making in Small Enterprises: The Impact of Business Intelligence. Journal of Enterprise Information Management, 32(3), 457-474. https://doi.org/10.1108/JEIM-03-2018-0050
Keskin, H., & Köseoglu, M. A. (2021). Business Intelligence and Performance Measurement in Small Firms. Journal of Management and Organization, 27(4), 585-607. https://doi.org/10.1017/jmo.2019.67
Lestari, N., & Rizki, M. (2020). Implementasi Business Intelligence dalam Analisis Tren UMKM di Indonesia. Jurnal Sistem Informasi Bisnis, 10(3), 331-341. https://doi.org/10.21456/vol10iss3pp331-341
McDonald, C. E., & Wilson, R. (2022). The Use of OLAP Technology for Business Intelligence in SMEs. Journal of Information Technology Management, 33(2), 212-229. https://doi.org/10.1080/10580530.2022.2017539
Santoso, Y., et al. (2019). Implementasi Business Intelligence pada UMKM untuk Meningkatkan Kinerja Bisnis. Jurnal Informatika, 13(2), 77-85. https://doi.org/10.20884/1.jif.2019.13.2.274
Downloads
Published
Issue
Section
License
Copyright (c) 2024 Nandita Rahma Putri (Author)
This work is licensed under a Creative Commons Attribution 4.0 International License.
