ac

The Implementation of Business Intelligence to Analyze Sales Trends in the Indofishing Online Store Using Power BI

Authors

  • Sri Anardani Universitas PGRI Madiun, Indonesia
  • Muh Nur Luthfi Azis Universitas PGRI Madiun, Indonesia
  • Moch Yusuf Asyhari Universitas PGRI Madiun, Indonesia

DOI:

10.47709/brilliance.v3i2.3232

Keywords:

Business Intelligence, Microsoft Power BI, Warehouse, ETL, Dashboards

Dimension Badge Record



Abstract

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.

Author Biography

Sri Anardani, Universitas PGRI Madiun, Indonesia

 

 

Google Scholar Cite Analysis
Abstract viewed = 211 times

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

ARTICLE Published HISTORY

Submitted Date: 2023-11-23
Accepted Date: 2023-11-25
Published Date: 2023-12-04

How to Cite

Anardani, S. ., Azis, M. N. L., & Asyhari, M. Y. (2023). The Implementation of Business Intelligence to Analyze Sales Trends in the Indofishing Online Store Using Power BI. Brilliance: Research of Artificial Intelligence, 3(2), 300-305. https://doi.org/10.47709/brilliance.v3i2.3232

Issue

Vol. 3 No. 2 (2023): Brilliance: Research of Artificial Intelligence, Article Research November 2023

Section

Articles

License

Copyright (c) 2023 Sri Anardani, Muh Nur Luthfi Azis, Moch Yusuf Asyhari

Creative Commons License

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