Implementasi Business Intelligence Untuk Analisis Data Kinerja Penjualan Menggunakan Power BI
DOI:
https://doi.org/10.47065/bulletincsr.v6i1.849Keywords:
Data Analysis; Business Intelligence; Data Visualization; Decision Making; Power BIAbstract
This study aims to apply the concept of Business Intelligence (BI) by implementing it using the Power BI tools to analyze furniture sales data. The BI approash uses technology and analytical methods to analyze, integrate, and present information needed by company. Power BI is a BI platform for interactive data visualization. This approach involves the process of collecting and integrating data, which is then presented in the form of interactive and easy-to-understand visualizations. The research methods used include a literature study related to BI concepts and technology, as well as experiment using Power BI to analyze sales data with various key performance indicators (KPIs) such as growth sales, average purchase value, profit margin, etc. the results will be interpreted to obtain valuable information for more accurate business decision making. This research is expected to provide a better understanding of the application of BI using Power BI in sales data analysis and can be used as a basis for companies in making accurate and effective business decisions to achieve company targets.
Downloads
References
F. Abu, “The implementation of lean manufacturing in the furniture industry: A review and analysis on the motives, barriers, challenges, and the applications,” J. Clean. Prod., vol. 234, pp. 660–680, 2019, doi: 10.1016/j.jclepro.2019.06.279.
A. Wibowo, Industri 4.0. Penerbit Yayasan Prima Agus Teknik, 2024.
H. Liao, “Reimagining multi-criterion decision making by data-driven methods based on machine learning: A literature review,” Inf. Fusion, vol. 100, 2023, doi: 10.1016/j.inffus.2023.101970.
U. S. Sulistyawati, “Decoding Big Data?: Mengubah Data Menjadi Keunggulan Kompetitif dalam Pengambilan Keputusan Bisnis Abstrak,” J. Manaj. dan Teknol., vol. 1, no. 2, pp. 58–71, 2024.
N. L. S. Thatavarthi and S. R. Koppanathi, “Leveraging Journal of Core Engineering & Management,” Int. J. Core Eng. Manag. ISSN No 2348-9510, vol. 6, no. 09, pp. 47–56, 2020.
R. Akbar, M. Silvana, M. Jannah, and M. H. Hersyah, “Implementation of Business Intelligence for Sales Data Management Using Interactive Dashboard Visualization in XYZ Stores,” Int. Conf. Inf. Technol. Syst. Innov., pp. 2020–2022, 2020.
K. SM and M. Belwal, “Performance Dashboard,” Int. Conf. Smart Technol. Smart Nation, pp. 1–7, 2017.
N. A. El-Adaileh and S. Foster, “Successful business intelligence implementation: a systematic literature review,” J. Work Appl. Manag., vol. 11, no. 2, pp. 121–132, 2019, doi: 10.1108/JWAM-09-2019-0027.
Sudaryono, “Implementation of Information Planning and Strategies Industrial Technology 4.0 to Improve Business Intelligence Performance on Official Site APTISI,” Journal of Physics Conference Series, vol. 1179, no. 1. 2019. doi: 10.1088/1742-6596/1179/1/012111.
R. Kimball and M. Ross, The data warehouse toolkit: The definitive guide to dimensional modeling. John Wiley & Sons, 2013.
L. T. Moss and S. Atre, Business intelligence roadmap: the complete project lifecycle for decision-support applications. Addison-Wesley Professional, 2003.
T. Tumini and E. S. Subekti, “Implementasi business intelligence untuk menganalisis data proses manufaktur menggunakan google data studio,” J. Ilm. Tek. Inform. dan Komun., vol. 3, no. 3, pp. 143–151, 2023.
I. G. I. Sudipa, I. B. G. Sarasvananda, H. Prayitno, I. N. T. A. Putra, R. Darmawan, and D. A. WP, Teknik Visualisasi Data. PT. Sonpedia Publishing Indonesia, 2023.
J. Moore, “Data visualization in support of executive decision making,” Interdiscip. J. Inf. Knowl. Manag., vol. 12, pp. 125–138, 2017, doi: 10.28945/3687.
E. Marvaro and R. S. Samosir, “Penerapan Business Intelligence dan Visualisasi Informasi di CV. Mitra Makmur Dengan Menggunakan Dashboard Tableau,” J. Sains dan Teknol., vol. 8, no. 2, pp. 2775–5576, 2021, doi: https://doi.org/10.53008/kalbiscientia.v8i2.197.
M. A. Lubis and K. D. Tania, “Implementasi Business Intelligence untuk Visualisasi Data pada PT PP London Sumatra Indonesia,” J. Sist. Inf., vol. 13, no. 6, pp. 2601–2615, 2024.
Tumini Tumini and Endang Sri Subekti, “Implementasi Business Intelligence Untuk Menganalisis Data Proses Manufaktur Menggunakan Google Data Studio,” J. Ilm. Tek. Inform. dan Komun., vol. 3, no. 3 SE-Articles, pp. 143–151, Sep. 2023, doi: 10.55606/juitik.v3i3.625.
J. G. Stadler, K. Donlon, J. D. Siewert, T. Franken, and N. E. Lewis, “Improving the Efficiency and Ease of Healthcare Analysis Through Use of Data Visualization Dashboards,” vol. 4, no. 2, pp. 129–135, 2016, doi: 10.1089/big.2015.0059.
Y. P. Tsang, “Unlocking the power of big data analytics in new product development: An intelligent product design framework in the furniture industry,” J. Manuf. Syst., vol. 62, pp. 777–791, 2022, doi: 10.1016/j.jmsy.2021.02.003.
E. Camizuli and E. J. Carranza, “Exploratory data analysis (EDA),” Encycl. Archaeol. Sci., pp. 1–7, 2018.
J. A. Chiprés, “Exploratory and spatial data analysis (EDA-SDA) for determining regional background levels and anomalies of potentially toxic elements in soils from Catorce-Matehuala, Mexico,” Appl. Geochemistry, vol. 24, no. 8, pp. 1579–1589, 2009, doi: 10.1016/j.apgeochem.2009.04.022.
M. Apoorva, "Global Superstore Dataset," Kaggle.com. Accessed: Sept. 4, 2024. [Online]. Available: https://www.kaggle.com/datasets/apoorvaappz/global-super-store-dataset/data
Microsoft, "What is Power BI," Microsoft.com. Accessed: Feb. 10, 2025. [Online]. Available: https://learn.microsoft.com/en-us/power-bi/fundamentals/power-bi-overview
Kementrian Pendidikan Tinggi, Sains, dan Teknologi Republik Indonesia, "Elastisitas Permintaan dan Penawaran," Kemdiktisaintek.com. Accessed: Feb. 2, 2025. [Online]. Available: https://lmsspada.kemdiktisaintek.go.id/mod/resource/view.php?id=110491
R. Antoni and M. Meyer, "5 Easy Ways to Calculate Shipping Cost to Sales Ratio," BeProfit. Accessed: Feb. 2, 2025. [Online]. Tersedia: https://beprofit.co/a/blog/easy-ways-to-calculate-shiping-cost-to-sales-ratio
I. Ismail, "Average Order Value: Pengertian, Manfaat, dan Cara Menghitungnya," bliss.id. Accessed: Feb. 2, 2025 [Online]. Available: https://bliss.id/blog/pengertian-average-order-value/
Bila bermanfaat silahkan share artikel ini
Berikan Komentar Anda terhadap artikel Implementasi Business Intelligence Untuk Analisis Data Kinerja Penjualan Menggunakan Power BI
ARTICLE HISTORY
How to Cite
Issue
Section
Copyright (c) 2025 Nur Andhini Putri, Karnadi
This work is licensed under a Creative Commons Attribution 4.0 International License.
Authors who publish with this journal agree to the following terms:
- Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under Creative Commons Attribution 4.0 International License that allows others to share the work with an acknowledgment of the work's authorship and initial publication in this journal.
- Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal.
- Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work (Refer to The Effect of Open Access).
