Implementation of Business Intelligence for Sales Data Analysis and Visualization Using Power BI
Keywords:
Business Intelligence, Sales Data, Power BIAbstract
Sales data stored as raw transaction records does not immediately yield easily interpretable information; therefore, data processing and visualization using a Business Intelligence approach are required. This study aims to implement Business Intelligence using Microsoft Power BI to analyze and visualize sales data, thereby generating information that is more structured and easier to understand. A quantitative approach was employed, comprising stages such as data inspection, cleaning, transformation using Power Query, data loading into Microsoft Power BI, analysis, and the creation of visualizations and dashboards. Analyses were conducted based on time, product, category, total sales, and transaction volume. The results demonstrate that sales data can be processed into a more structured dataset and used to generate visualizations—such as sales trend graphs over time and sales comparisons by product and category—as well as indicators for total sales and transaction volume. These processed results are presented in a Business Intelligence dashboard featuring filters for period, product, and category. Implementing Business Intelligence with Microsoft Power BI transforms sales data into more structured information through processing, analysis, and visualization. The resulting dashboard serves as a tool for exploring sales information across various dimensions.
Downloads
References
[1] F. P. Eka Putra, F. I. Maulana, N. M. Akbar, and W. Febriantoro, “Twitter sentiment analysis about economic recession in indonesia,” 2023. doi: 10.31763/businta.v7i1.592.
[2] A. Zulfikri, F. P. E. Putra, M. A. Huda, H. Hasbullah, M. Mahendra, and M. Surur, “Analisis Keamanan Jaringan Dari Serangan Malware Menggunakan Filtering Firewall Dengan Port Blocking,” 2023. doi: 10.47709/digitech.v3i2.3379.
[3] F. P. E. Putra, F. Fauzan, S. Syirofi, M. Mursidi, D. Wahid, and A. Nuraini, “Sistem Pengendali Lingkungan Pertanian Dengan Wireless Sensor Network Untuk Mengoptimalkan Budidaya Hidroponik,” 2024. doi: 10.47709/digitech.v3i2.3461.
[4] F. P. E. Putra, M. A. Mahmud, and I. S. Maqom, “Pengembangan Sistem Pemantauan Lingkungan Berbasis Internet of Things (IoT) di Kampus,” 2024, researchgate.net. doi: 10.47709/digitech.v3i2.3457.
[5] Fauzan Prasetyo Eka Putra, Debri Eko Arissandi, Achmad Rofiqi, and Moh Firman Hidayat, “Pemanfaatan Mikrotik Dalam Manajemen Bandwidth Pada Jaringan Sekolah,” 2025, researchgate.net. doi: 10.55606/jitek.v5i1.5938.
[6] Fauzan Prasetyo Eka Putra, Dian Tri Agustina, Triana Selvia Khusnul Khotimah, and Tarisha Ramadhanty, “Analisis Kinerja Jaringan 5G dalam Meningkatkan Konektivitas Internet of Things (IoT),” 2025, researchgate.net. doi: 10.55606/jitek.v5i1.5836.
[7] Fauzan Prasetyo Eka Putra, Dea Aulia Siswoyo, M. Idris Ainul Yaqin, and Rica Oktavia, “Tinjauan Regulasi Siber dan Kebijakan Keamanan Jaringan 5G: Perspektif Nasional dan Internasional,” 2025, researchgate.net. doi: 10.55606/jitek.v5i1.6141.
[8] Fauzan Prasetyo Eka Putra, Noviyani Dwi Saputri, Fathur Rosi, and Rohilia Loati, “Optimalisasi Infrastruktur Cloud Networking melalui Integrasi SDN, NFV, dan Multi-Cloud,” 2025, researchgate.net. doi: 10.55606/jitek.v5i1.6099.
[9] Fauzan Prasetyo Eka Putra, Yogi Setiawan, Samsul Arifin, and Wahyu Hidayatullah, “Peran VPN dalam Menjaga Privasi Pengguna Jaringan Publik,” 2025, researchgate.net. doi: 10.55606/jitek.v5i1.5834.
[10] Fauzan Prasetyo Eka Putra, Mustafida Mustafida, Royhan Alfadili, and Afifatun Nahriyah, “Perancangan Jaringan Nirkabel Berbasis Mesh untuk Menunjang Aplikasi Smart City,” 2025, researchgate.net. doi: 10.55606/jitek.v5i1.5934.
[11] F. P. E. Putra, M. Irfan, M. Aziz, and R. N. Saputra, “Wireless Network Design at Pamekasan Regency Public Library,” Brill. Res. Artif. Intell., vol. 5, no. 1, pp. 144–150, 2025, doi: 10.47709/brilliance.v5i1.5876.
[12] F. P. E. Putra, U. Ubaidi, A. Zulfikri, G. Arifin, and R. M. Ilhamsyah, “Analysis of Phishing Attack Trends, Impacts and Prevention Methods: Literature Study,” Brill. Res. Artif. Intell., vol. 4, no. 1, pp. 413–421, 2024, doi: 10.47709/brilliance.v4i1.4357.
[13] F. P. Eka Putra, F. Muslim, N. Hasanah, Holipah, R. Paradina, and R. Alim, “Analisis Komparasi Protokol Websocket dan MQTT Dalam Proses Push Notification,” J. Sistim Inf. dan Teknol., pp. 63–72, 2024, doi: 10.60083/jsisfotek.v5i4.325.
[14] F. P. E. Putra, U. Ubaidi, M. A. Huda, H. Hasbullah, and A. Rohman, “Computer Network Management Optimization Through Big Data Analysis Using Time Series Analysis Method,” Brill. Res. Artif. Intell., vol. 4, no. 1, pp. 434–442, 2024, doi: 10.47709/brilliance.v4i1.4373.
[15] F. P. E. Putra, F. Mu’minin, A. Nuraini, S. N. R. Barokah, and K. Khairurrozi, “Designing an Information System for Student Admissions at SMAN 1 Pademawu Using the Waterfall Method,” Brill. Res. Artif. Intell., vol. 5, no. 1, pp. 582–591, 2025, doi: 10.47709/brilliance.v5i1.6508.
[16] M. A. Mahebu and R. S. Samosir, “A Visualisasi Data Penjualan CV. Waskat Karya Metal Menggunakan Pendekatan Business intelligence,” KALBISCIENTIA J. Sains dan Teknol., vol. 10, no. 02, pp. 138–147, 2023, doi: 10.53008/kalbiscientia.v10i2.2143.
[17] I. D. K. Divha Pramartha, G. M. Arya Sasmita, and D. P. Githa, “Penerapan Business Intelligence Untuk Prediksi Penjualan Produk (Studi Kasus PT. XYZ),” 2023, pdfs.semanticscholar.org. doi: 10.24843/jtrti.2023.v04.i02.p19.
[18] D. Candra, N. N. Febriani, Y. S. Rachmanda, and D. R. Nursamsi, “Penerapan Business Intelligence Untuk Analisis Dan Visualisasi Data Penjualan Pada Agung Celuller Tasikmalaya Menggunakan Microsoft Power BI,” Indones. J. Innov. Multidisipliner Res., vol. 4, no. 3, pp. 1447–1456, 2026, doi: 10.69693/ijim.v4i3.1362.
[19] A. D. D. Sinambela, A. Zahra, and J. K. Jaman, “Using Power BI to Apply Business Intelligence to Product Sales,” Sistemasi, vol. 13, no. 2, p. 506, 2024, doi: 10.32520/stmsi.v13i2.3036.
[20] A. Pratama Bukhari, R. Hafidz, and R. W. Prio Pamungkas, “Analisis Business Intelligence Data Penjualan Pt Ambulance Pintar 2021,” JATI (Jurnal Mhs. Tek. Inform., vol. 8, no. 4, pp. 7184–7189, 2024, doi: 10.36040/jati.v8i4.10141.
[21] A. R. Nurridwan Firdaus and D. Firmansyah, “Implementasi Business Intelligence pada Data Pendapatan studi kasus (PT. Pos Indonesia),” J. Esensi Infokom J. Esensi Sist. Inf. dan Sist. Komput., vol. 7, no. 2, pp. 33–39, 2023, doi: 10.55886/infokom.v7i2.686.
[22] Y. Ramadhani, Dyna Marisa Khairina, and Septya Maharani, “Implementasi Business Intelligence Dalam Analisa Penjualan Mobil Mitsubishi Menggunakan Visualisasi Data,” Adopsi Teknol. dan Sist. Inf., vol. 3, no. 1, pp. 1–11, 2024, doi: 10.30872/atasi.v3i1.435.
[23] D. L. Halim, N. Calim, A. Tamalate, and W. Felicia, “Evaluasi Kinerja Bisnis Berbasis Business Intelligence Dashboard Pada UD. Sentral,” JDMIS J. Data Min. Inf. Syst., vol. 3, no. 2, pp. 54–63, 2025, doi: 10.54259/jdmis.v3i2.4216.
[24] R. Darmawan and G. Swalaganata, “Analisa Komparatif Power Bi Dan Tableau Dalam Implementasi Business Intelligence Pada Brazilian E-Commerce Public Dataset By Olist,” JATI (Jurnal Mhs. Tek. Inform., vol. 9, no. 5, pp. 8936–8944, 2025, doi: 10.36040/jati.v9i5.15178.
[25] E. Ramadhan and A. Voutama, “Visualisasi Prediksi Penjualan Game Di Dunia Menggunakan Power Bi,” J. Inform. dan Tek. Elektro Terap., vol. 13, no. 2, 2025, doi: 10.23960/jitet.v13i2.6353.
[26] A. Dzaki Alhadi and M. Agarina, “Business Intelligence Dashboard Using Power BI for Sentiment Analysis and Tokopedia Product Performance,” J. Teknol. Dan Open Source, vol. 9, no. 1, pp. 370–380, 2026, doi: 10.36378/jtos.v9i1.5745.
[27] J. Louis, D. Trisnawarman, and N. J. Perdana, “Perancangan Dashboard Business Intelligence Untuk Data Piutang Pada Apotek X,” Jutisi J. Ilm. Tek. Inform. dan Sist. Inf., vol. 12, no. 3, p. 1767, 2023, doi: 10.35889/jutisi.v12i3.1666.
[28] Selvia Ayu Putri Ananda and Muhammad Irwan Padli Nasution, “Peran Business Intelligence dalam Mendukung Pengambilan Keputusan pada Usaha Kecil Berbasis Data Transaksi,” Aslamiah J. Pendidikan, Ekon. Sos. dan Budaya, vol. 4, no. 2, pp. 296–307, 2026, doi: 10.66886/aslamiah-jpesb.v4i2.305.
[29] Rahil Aulia Rahma, Karimah Kusumawati, Ahmed Abusail, and Mahad Wicaksono, “Implementasi Business Intelligence dalam Pengendalian Mutu di Industri Manufaktur,” Router J. Tek. Inform. dan Terap., vol. 3, no. 2, pp. 97–112, 2025, doi: 10.62951/router.v3i2.504.
[30] Sri Bekti Handayani Ningsih, Iyat Ratna Komala, Leni Nurhayati, and Maya Suhayati, “Visualisasi Data Kependudukan Menggunakan Power Business Intelligence (Studi Kasus Kelurahan Sukamiskin Kecamatan Arcamanik Kota Bandung),” J. Penelit. Sist. Inf., vol. 3, no. 1, pp. 25–39, 2025, doi: 10.54066/jpsi.v3i1.2944.
[31] S. Saripudin and W. Murtiningrum, “Pelatihan Pemanfaatan Microsoft Power bi untuk Analisis dan Visualisasi Data di kanwil DJB Jawa Barat II,” J. Abdimas Perbanas, vol. 7, no. 1, pp. 57–64, 2026, doi: 10.56174/jap.v7i1.1177.
[32] Gozi Shidiq Munawir, Agus Nana Supena, and Djamaludin, “Perancangan Business Intelligence untuk Meningkatkan Penjualan di Java Jones Clothing,” 2025. doi: 10.29313/bcsies.v5i1.17525.
[33] E. G. Limbor, T. A. Putri, S. A. R. Qadriah, D. Arisandi, and J. T. Beng, “Perancangan Dashboard Penjualan Pakaian di Toko Cleo dengan Power BI,” Jutisi J. Ilm. Tek. Inform. dan Sist. Inf., vol. 13, no. 3, 2024, doi: 10.35889/jutisi.v13i3.2383.
[34] J. Jean Afenta, M. Hatta, and P. Sokibi, “Implementasi Business Intelligence Untuk Analisa Dan Visualisasi Data Penjualan Keramik Cv. Multi Keramik Indah Menggunakan Platform Tableau,” JATI (Jurnal Mhs. Tek. Inform., vol. 9, no. 6, pp. 9391–9396, 2025, doi: 10.36040/jati.v9i6.15627.
[35] Helmalia, Y. Wicaksono, A. Akbar Harahap, and T. Rochmadi, “Implementasi Business Intelligence untuk Visualisasi Data Pengembangan Kompetensi Aparatur Sipil Negara Di Kabupaten Lebak,” J. Teknol. Inf. dan Ilmu Komput., vol. 1, no. 2, pp. 49–58, 2025, doi: 10.65258/jutekom.v1.i2.7.
[36] W. . Sulistyoningsih, I. N. Y. A. Wiajaya, and H. S. Alam, “Penerapan Model Business Intelligence Pada Perusahaan Retail XLT Untuk Meningkatkan Strategi Pemasaran,” J. Ilm. Teknol. Inf. Asia, vol. 17, no. 1, pp. 33–44, 2023, doi: 10.32815/jitika.v17i1.893.
[37] A. R. Fahmi and M. W. Kasrani, “Visualisasi Dashboard Inventaris PT Pertamina Patra Niaga Berbasis Aplikasi Power BI (Business Intelligence),” J. Tek. Elektro Uniba (JTE UNIBA), vol. 9, no. 2, pp. 589–597, 2025, doi: 10.36277/jteuniba.v9i2.1269.
[38] B. J. Goh and D. Trisnawarman, “Perancangan Prototipe Business Intelligence Dashboard Penjualan PT ABC,” J. Ilm. Univ. Batanghari Jambi, vol. 24, no. 1, p. 556, 2024, doi: 10.33087/jiubj.v24i1.4704.
[39] Reno Naufal Maulidyan and M. Muharrom Al Haromainy, “Perancangan Data Warehouse untuk Analisis Penjualan Ritel Elektronik Berbasis Business Intelligence,” J. Ilm. Penelit. Mhs., vol. 4, no. 3, pp. 980–989, 2026, doi: 10.61722/jipm.v4i3.2604.
[40] S. Aulia, A. Lia Hananto, B. Priyatna, and S. Shofiah Hilabi, “Klasterisasi Penjualan Produk Minuman Menggunakan K-Means Dan Visualisasi Dengan Power Bi,” JATI (Jurnal Mhs. Tek. Inform., vol. 10, no. 3, pp. 3705–3711, 2026, doi: 10.36040/jati.v10i3.18004.
[41] R. Senjaya, B. Nurina Sari, and I. Purnamasari, “Implementasi Business Intelligence Pada Toko Smart-S Dalam Membantu Proses Analisis Bisnis Dengan Metode Olap,” JATI (Jurnal Mhs. Tek. Inform., vol. 8, no. 4, pp. 5906–5913, 2024, doi: 10.36040/jati.v8i4.10112.
[42] A. S. Hutagaol, V. Samantha, T. M. Salsabila, W. Wasino, and J. T. Beng, “Perancangan Dashboard Monitoring Untuk Monthly Report Pemesanan Hotel dengan Microsoft Power BI,” Jutisi J. Ilm. Tek. Inform. dan Sist. Inf., vol. 13, no. 3, 2024, doi: 10.35889/jutisi.v13i3.2379.
[43] A. Yulianto, “Implementasi Power BI untuk Analisis Visual Data Kebakaran: Studi Kasus Kota Administratif DKI Jakarta,” J. Ris. Jakarta, vol. 18, no. 1, 2025, doi: 10.37439/jurnaldrd.v18i1.119.
[44] I. D. G. D. B. Muku, I. P. A. Bayupati, and A. A. N. H. Susila, “Pengembangan Sistem Business Intelligence Dalam Monitoring Performa Perusahaan Multi Company,” SINTECH (Science Inf. Technol. J., vol. 6, no. 2, pp. 99–106, 2023, doi: 10.31598/sintechjournal.v6i2.1394.
[45] Y. Eirlangga, A. Pramana Gusman, and T. Farhan Satria, “Aplikasi Cerdas Prediksi Keberlanjutan UMKM dengan Extreme Learning Machine dan Power BI,” J. Pustaka AI (Pusat Akses Kaji. Teknol. Artif. Intell., vol. 5, no. 3, pp. 538–549, 2025, doi: 10.55382/jurnalpustakaai.v5i3.1448.
[46] T. Tasriq and S. O. Kunang, “Penerapan Metode Double Exponential Smoothing Dan Visualisasi Dashboard Untuk Menganalisa Data Transaksi Penjualan Pada Kemitraan Pt Natural Nusantara (Studi Kasus : Stockis Bg.3005 Muara Enim),” JIPI (Jurnal Ilm. Penelit. dan Pembelajaran Inform., vol. 8, no. 1, pp. 254–265, 2023, doi: 10.29100/jipi.v8i1.3441.
[47] M. A. Lubis and K. D. Tania, “Implementation of Business Intelligence for Data Visualization at PT PP London Sumatra Indonesia,” Sistemasi, vol. 13, no. 6, p. 2601, 2024, doi: 10.32520/stmsi.v13i6.4663.
[48] A. Fadhila, Y. Setiawan, and N. Ramadani, “A Business Intelligence Approach to Visualizing and Mapping Families at Risk of Stunting Using Microsoft Power BI: Evidence from Bengkulu,” INOVTEK Polbeng - Seri Inform., vol. 11, no. 3, pp. 805–816, 2026, doi: 10.35314/t5xvwd61.
[49] Murtiwiyati Murtiwiyati, Hansel Agathon, and Leli Safitri, “Implementasi Data Warehouse dan Business Intelligence Menggunakan Pentaho dan Metabase untuk Membuat Dahboard Visualisasi Kinerja Penjualan E-Commerce Wish,” J. Penelit. Teknol. Inf. dan Sains, vol. 2, no. 4, pp. 100–109, 2024, doi: 10.54066/jptis.v2i4.2783.
[50] F. K. Senduk, R. Waluyo, and K. N. Isnaini, “Data Analysis using Business Intelligence and Tableau for Visualizing Indonesia’s Poverty Line,” Sistemasi, vol. 14, no. 3, p. 1122, 2025, doi: 10.32520/stmsi.v14i3.4993.
[51] M. Saputra and Tony, “Rancang Bangun Dashboard Penjualan pada PT. XYZ dengan Microsoft PowerBI,” J. Ilmu Komput. dan Sist. Inf., vol. 11, no. 2, 2023, doi: 10.24912/jiksi.v11i2.26028.
[52] K. Olivia and F. S. Papilaya, “Application of OLAP based Business Intelligence and Predictive Analysis (Random Forest Classifier and ARIMA) in a Fintech P2P Lending Company,” Sistemasi, vol. 14, no. 6, p. 2846, 2025, doi: 10.32520/stmsi.v14i6.5663.
[53] A. Maharani, H. Maulana, and R. Dwicahya Supriatman, “Analisis Penerapan Business Intelligence Dalam Tren Pasar Dengan Cobit 2019,” J. Mhs. Sist. Inf. Galuh, vol. 2, no. 1, pp. 72–85, 2025, doi: 10.25157/jmsig.v2i1.5449.
Published
Issue
Section
License
Copyright (c) 2026 Mohammad Khoirun Nizam, Khoirul Mufid (Penulis)
This work is licensed under a Creative Commons Attribution 4.0 International License.
