Using Power BI to Apply Business Intelligence to Product Sales

Annabella Dian Dameria Sinambela; Almira Zahra; Jajam Khaerul Jaman

doi:10.32520/stmsi.v13i2.3036

Using Power BI to Apply Business Intelligence to Product Sales

Annabella Dian Dameria Sinambela, Almira Zahra, Jajam Khaerul Jaman

Abstract

This research aims to investigate the use of Power BI, which is one of the leading tools in the BI industry, in applying Business Intelligence in the context of product sales. Business Intelligence (BI) is a solution used to address the needs of companies with a focus on data analysis and access to support better decision making. The main goal is to help companies in the decision-making process through steps such as designing databases, Data Warehouse, and report generation. The result of this research is the analysis of reports showing product sales with the lowest contribution compared to other areas. Therefore, products that have the lowest contribution need special attention. One of the efforts that can be made is to carry out promotions and provide discounts to increase the number of orders from customers in a wider area.

Full Text:

PDF

References

Sunyoto, Danang, and Agus Mulyono. Manajemen Bisnis Ritel. Edited by Kalijaga, Magister A. Eureka Media Aksara, 2022.

Arifin, Z., & Sugiharto, A. (2013). Rancang Bangun Sistem Business Intelligence Universitas Sebagai Pendukung Pengambilan Keputusan Akademik. Jurnal Sistem Informasi Bisnis, 3(1), 30-40.

Han, J., Kamber, M., & Pei, J. (2012). Data mining concepts and techniques third edition. University of Illinois at Urbana-Champaign Micheline Kamber Jian Pei Simon Fraser University.

Wijaya. R., Pudjoatmodjo. B., “Implementasi Data Mart Kepegawaian Menggunakan Tiga Domain (Studi Kasus di Dinas Pertanian Kabupaten Bandung),” SENAPATI 2015, pp. 175-180, 2015.

Prayoga. D.R., “Dashboard System Business Intelligence untuk Analisis dan Monitoring di Apotik RSJ Tampan Berbasis Web,” skripsi, UIN SUSKA, Riau, 2021.

Ardista. N., Purbandini. P., Taufik. T., “Rancang Bangun Data warehouse untuk Pembuatan Laporan dan Analisis pada Data Kunjungan Pasien Rawat Jalan Rumah Sakit Universitas Airlangga Berbasis Online Analytical Processing (OLAP),” Journal of Information System Engineering and Business Intellligence, vol. 3(1), pp. 40-51, 2017.

D. Aryanti and J. Setiawan, “Visualisasi Data Penjualan dan Produksi PT Nitto Alam Indonesia Periode 2014-2018”, Ultima InfoSys : Jurnal Ilmu Sistem Informasi, vol. 9, no. 2, pp. 86-91, Mar. 2019.

Eko siswanto, Eka Satria Wibawa, and Z. Mustofa, “Implementasi Aplikasi Sistem Peramalan Persedian Barang Menggunakan Metode Single Moving Average Berbasis Web,” Elkom J. Elektron. dan Komput., vol. 14, no. 2, pp. 224–233, 2021, doi: 10.51903/elkom.v14i2.515.

S. M. Abdullah and Widya Novianti, “Perancangan Sistem Informasi Peramalan Penjualan Meubel Menggunakan Metode Moving Average (Studi Kasus Toko Meubel Sumber Rejeki ),” Inf. Interaktif, vol. 7, no. 2, pp. 96–100, 2022.

W. Febiyanti, K. Ghozali, and A. S. Indrawanti, “Rancang Bangun Aplikasi Dashboard Penjualan, Logistik dan Tenaga Kerja di Pt. XYZ,” J. Tek. ITS, vol. 11, no. 2, 2022, doi: 10.12962/j23373539.v11i2.85815.

J. N. A. Aziza, “Perbandingan Metode Moving Average, Single Exponential Smoothing, dan Double Exponential Smoothing Pada Peramalan Permintaan Tabung Gas LPG PT Petrogas Prima Services,” J. Teknol. dan Manaj. Ind. Terap., vol. 1, no. I, pp. 35–41, 2022, doi: 10.55826/tmit.v1ii.8.

A. Nurkholis and P. S. Oktora, “Sistem Persediaan Obat Menggunakan Metode Moving Average Dan Fixed Time Period With Safety Stock,” J. Sains Komput. Inform., vol. 6, no. 2, pp. 1134–1145, 2022.

Y. Aisyah, S. Anwar, and - Samidi, “Pembuatan Data Warehouse secara Berjenjang dari Data Transaksi dengan ETL Script PHP,” Techno.Com, vol. 22, no. 3, pp. 609–621, 2023, doi: 10.33633/tc.v22i3.8084.

A. F. Karami, “Perancangan Arsitektur Data Warehouse Pada Industri Perkebunan Kelapa Sawit,” JATISI (Jurnal Tek. Inform. dan Sist. Informasi), vol. 9, no. 2, pp. 973–983, 2022, doi: 10.35957/jatisi.v9i2.1834.

Heru Stiawan et al., “Model Visualisasi Informasi Dashboard Pada Pemetaan Tanaman Obat Dan Langka Kabupaten Kediri Menggunakan Microsoft Power Bi,” J. Inform. Teknol. dan Sains, vol. 4, no. 4, pp. 366–371, 2022, doi: 10.51401/jinteks.v4i4.2056.

DOI: https://doi.org/10.32520/stmsi.v13i2.3036

Article Metrics

Abstract view : 139 times
PDF - 46 times

Refbacks

There are currently no refbacks.

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

Username
Password
Remember me