The Implementation of Business Intelligence to Analyze Sales Trends in the Indofishing Online Store Using Power BI
DOI:
https://doi.org/10.47709/brilliance.v3i2.3232Keywords:
Business Intelligence, Microsoft Power BI, Warehouse, ETL, DashboardsAbstract
The growth of online sales businesses by utilizing E-Commerce is increasing rapidly. One way that can be used as a tool to face competition is to apply Business Intelligence as a basis for making the right business strategy decisions. Indofishing Shop is an online shop selling various fishing gear and equipment. So far, online sales transaction data processing uses Microsoft Excel, which has created problems with the need for more information to analyze product trends. This research applies Business Intelligence to detect data extracted and collected in a data warehouse. The data will be analyzed statistically and visualized using Microsoft Power BI. Data warehouse design uses Kimball's Nine-Step method. The results of this research are in the form of a visualization dashboard that is used to analyze sales trends for the most sold fishing equipment products from the Indofishing Shop. Diagram visualization helps Indofishing understand the trend conditions of the most in-demand products and the cities of origin of the buyers who buy the most products.
References
Abdillah, A. R., Muflih, H. Z., Pranata, A. B., & Hasan, F. N. (2023). Penerapan Business Intelligence Untuk Analisis Kematian di Indonesia Tahun 2000-2022. 10(2).
Akbar, R., Rasyiddah, D., Anrisya, M., Julyazti, N. F., & Syaputri, S. (2018). Penerapan Aplikasi Power Business Intelligence Dalam Menganalisis Prioritas Pekerjaan di Indonesia. Jurnal Edukasi Dan Penelitian Informatika (JEPIN), 4(1), 54. https://doi.org/10.26418/jp.v4i1.25497
Anshari, S. F., & Retno, S. (2023). Penerapan Metode Nine-Step Kimball Dalam Pengolahan Data History Menggunakan Data Warehouse dan Business Intelligence. Jurnal Ilmu Komputer, 16(1), 69. https://doi.org/10.24843/jik.2023.v16.i01.p07
Budisantoso, M. D., Sugiarto, D., & Siswanto, T. (2022). Perancangan Business Intelligence Data Ketersediaan Obat di Puskesmas Curug Tangerang. Intelmatics, 2(1), 1–8. https://doi.org/10.25105/itm.v2i1.12451
Febiyanti, W., Ghozali, K., & Indrawanti, A. S. (2022). Rancang Bangun Aplikasi Dashboard Penjualan, Logistik dan Tenaga Kerja di Pt. XYZ. Jurnal Teknik ITS, 11(2). https://doi.org/10.12962/j23373539.v11i2.85815
Hasan, F. N., & Febriandirza, A. (2021). Perancangan Data Warehouse Untuk Data Penelitian Di Perguruan Tinggi Menggunakan Pendekatan Nine Steps Methodologhy. Pseudocode, 8(1), 49–57. https://doi.org/10.33369/pseudocode.8.1.49-57
Muhammad Hasan, F., I Gede Putu Krisn, J., Wijaya, I. N., & Anggara, Y. (2023). Penerapan Business Intelligence Pada Transaksi Penjualan Di E-Commerce. : : Jurnal Ilmiah Mahasiswa Pendidikan Sejarah, 8(4).
Nisa, N., Firdaus, D., & Aprilia, R. (2023). Implementasi Business Intelligence Untuk Menganalisis Jumlah Guru SD SMP SMA SMK Di Jawa Barat. Simpatik: Jurnal Sistem Informasi Dan Informatika, 3(1), 11–16. https://doi.org/10.31294/simpatik.v3i1.1725
Novianti, N. A., Irawan, B. H., Ariyanto, N. P., Widiastuti, H., Restu, F., & Arifin, N. L. (2022). Penggunaan Power BI Untuk Pengolahan Data Non-Conformance Material. Jurnal Teknologi Dan Riset Terapan (JATRA), 4(2), 52–57. https://doi.org/10.30871/jatra.v4i2.3885
Pramartha, I. D. K., Sasmita, G. M. A., & Githa, P. (2023). Penerapan Business Intelligence Untuk Prediksi Penjualan Produk (Studi Kasus Pt. Xyz). Jurnal Ilmiah Teknologi Dan Komputer, 4(2).
Priono, T. R., Purnomo, W., & Setiawan, N. Y. (2021). Pengembangan Data Warehouse menggunakan Metode Kimball ( Studi Kasus?: Ekspor & Impor Fauna dan Flora Hias Air Laut ). Jurnal Pengembangan Teknologi Informasi Dan Ilmu Komputer, 5(8), 1.
Purnama, A., I Nyoman Yudi Anggara Wijaya, & Ida Bagus Kresna Sudiatmika. (2022). Penerapan Business Inteligence Untuk Menganalisis Data Penjualan Menggunakan Power Bi. Jurnal Informatika Teknologi Dan Sains, 4(2), 118–123. https://doi.org/10.51401/jinteks.v4i2.2030
Purwantin, N. P. J., Wijaya, I. N. Y. A., & Queena Fredlina, K. (2020). Intelligence Untuk Menentukan Trend Penjualan Barang (Studi Kasus: PT. Menikmati Distribusi). SMART TECHNO (Smart Technology, Informatic, and Technopreneurship), 2(2).
Steven, K., Hariyanto, S., dan Arijanto, R. (2021). Penerapan Business Intelligence Untuk Menganalisis Data Pada PT. Suryaplas. Jurnal Algor, Vol.2(No.2), 41–50.
Sulistyoningsih, W., Wiajaya, I. N. Y. A. W., & Alam, H. S. (2023). Penerapan Model Business Intelligence Pada Perusahaan Retail XLT Untuk Meningkatkan Strategi Pemasaran. Jurnal Ilmiah Teknologi Informasi Asia, 17(1), 33–44. https://jurnal.stmikasia.ac.id/index.php/jitika/article/view/893
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2023 Sri Anardani, Muh Nur Luthfi Azis, Moch Yusuf Asyhari
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.
