Business Intellegenge untuk Perencanaan Strategi Pemasaran pada UMKM Sarung dengan Manajemen Dashboard
Keywords:
Business Intelligence, Marketing Strategy, ETL, MSMEsAbstract
MSMEs are the backbone of the national economy, the government is trying to recover the economy after the Covid-19 pandemic by making a new breakthrough with digitalization. Digitalization helps MSMEs to process and analyze data for decision making. The data stored in the company is increasing, so it requires Business Intelligence to make it easier for companies to present information. MSME Abitex experienced problems in planning sales strategies by looking at interest in each city. The stages of research carried out were problem identification, data collection, design, manufacture, testing results. In identifying problems, problems were found in monitoring sales to create sales strategies, in data collection from 2021 to 2023. The number of transactions was 807 sales with 3 types of sarongs, a total of 14 sarongs produced. In designing using a star schema obtained from the sales fact table, time dim, customer dim, goods dim. Business intelligence can display data visualization by grouping by product, customer and by time, and can see interest in products in each city
References
Achmad, M., Andre, & Susilawati, D. (2020). Penerapan Business Intelligence Data Superstore Dengan Menggunakan. Algor, 2(1), 48–56.
Berlin, & Giap, Y. C. (2020). Penerapan Business Intelligence Pada CV. Tanggamas Chemichal dengan Metode Olap. Algor, 2(1), 57–65.
Dwiputra Wijaya, A., & Gantini, T. (2019). Analisis Forecasting dengan Implementasi Dashboard Business Intelligence Untuk Data Penjualan Pada PT. “X.” Prof. Drg. Surya Sumantri, 1(65), 1.
Handika, I. P. S. (2020). Perancangan datawarehouse dan teknologi business intelligence untuk analisa penjualan pada perusahaan retail PT. ABC. Rabit: Jurnal Teknologi dan Sistem Informasi Univrab, 5(2), 76–85. https://doi.org/10.36341/rabit.v5i2.1309
Hasan F. M., Juliharta, I., & Wijaya, I. Y. (2023). Penerapan Business Intelligence Pada Transaksi Penjualan di E-Commerce. JIMPS: Jurnal Ilmiah Mahasiswa Pendidikan Sejarah, 8(4), 4415–4423.
Hasim, L. (2019). 322564071. Penerapan Business Intelligence Pada Manajemen Dashboard Report Perusahaan Asuransi, 123–136.
Hendrawan, S. A., & Setyantoro, D. S. (2022). Pemanfaatan Dashboard Business Intelligence untuk Laporan Penjualan pada Superstore. Tekinfo, 23(1), 46–52. https://doi.org/10.1093/oseo/instance.00208803
Mahebu, M. A., & Samosir, R. S. (2023). A Visualisasi Data Penjualan CV. Waskat Karya Metal Menggunakan Pendekatan Business intelligence. KALBISCIENTIA Jurnal Sains Dan Teknologi, 10(02), 138–147. https://doi.org/10.53008/kalbiscientia.v10i2.2143
Oktavian, A. R., & Rumaisa, F. (2022). Penerapan Business Intelligence Terhadap Data Penjualan UMKM (Foodendez) Menggunakan Metode Algoritma Apriori Dalam Menentukan Segmentasi Pasar. Jurnal Media Informatika Budidarma, 6(3), 1740. https://doi.org/10.30865/mib.v6i3.4338
Rahman, E. (2024). Aplikasi Business Intelligence Pada Sistem Penjualan CV. Muda Jeans. EXPLORE, 14(1), 49–54.
Suhendar, A., & Hikmatunnisa, T. (2022). Penerapan Business Intelligence Pada Peluang Jenis Usaha Baru Usaha Mikro Kecil Menengah Dengan Menggunakan Teknologi Online Analytical Processing. JSiI (Jurnal Sistem Informasi), 9(2), 115–118. https://doi.org/10.30656/jsii.v9i2.5183
Sulistyoningsih, W., Wiajaya, I. N. Y. A., & Alam, H. S. (2023). Penerapan Model Business Intelligence Pada Perusahaan Retail XLT Untuk Meningkatkan Strategi Pemasaran. Jurnal Ilmiah Teknologi Informasi Asia, 17(1), 33. https://doi.org/10.32815/jitika.v17i1.893
Valentina, F. V., Alfiyan, V., & Anshori, M. I. (2024). Peran UMKM dalam Sistem Perekonomian Indonesia: Tantangan dan Peluang Pasca Pandemi. Jurnal Ilmu Manajemen, Bisnis Dan Ekonomi JIMBE, 1(5), 285–292.
Yasir, M., Khoirunnisaa, N., Alfarabi, D. F., & ... (2023). Penerapan Business Intelligence Dalam Analisis Perilaku Konsumen Online Shopping Pada Mahasiswa Universitas Bhayangkara …. Jurnal Sistem …, 4(2), 99–106.
Downloads
Published
Issue
Section
License
Copyright (c) 2025 Wahyu Setianto, Devi Sugianti, Ari Putra Wibowo, Risqiati Risqiati, Arief Soma Darmawan
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
