Perancangan Prototipe Business Intelligence Dashboard Penjualan PT ABC

Bryan Jordan Goh, Dedi Trisnawarman

Abstract


In a competitive business era, efficient and informative sales data management is essential for company success. The purpose of developing this sales dashboard prototype is to monitor sales data, integrate data from various sources, and make smarter business decisions. PT ABC, as a company engaged in milk sales, realizes the importance of timely monitoring of sales data and accurate analysis. The method used in the development of the dashboard is the SDLC prototyping method. The initial stages include needs identification, then design, followed by the creation of an initial prototype that is used to get feedback from stakeholders. The prototype will be designed using Power BI tools then the prototype results will be improved based on feedback. Through this design, the needs of decision makers will be better understood. The result of the design is sales data visualization based on Key Performance Indicators, namely sales targets and sales growth.

Keywords


Dashboard; Prototyping SDLC; Business Intelligence; ETL; Power BI.

Full Text:

PDF

References


Afrizal, W., Lubis, M., & Musnansyah, A. 2021. Design Approach in Document Management System: The Development of EZDESK Dashboard. MATEC Web of Conferences, 348, 01006. https://doi.org/10.1051/matecconf/202134801006

Aginsha, A. G., & Noranita, B. 2021. Designing a performance dashboard as a monitoring tool at PT Sun Star Motor MT Haryono Semarang: data approach. Journal of Physics: Conference Series, 1918(4), 042133. https://doi.org/10.1088/1742-6596/1918/4/042133

Alan Dennis, Barbara Wixom, & David Tegarden. 2015. Systems Analysis and Design: An Object-Oriented Approach with UML (5th ed.).

Aprillia, D. A., Noranita, B., & Nugraheni, D. M. K. 2021. Dashboard Design as Monitoring System Distribution of Government Assistance at Balai Besar Perikanan Budidaya Air Payau (BBPBAP) Jepara, Central Java. 2021 5th International Conference on Informatics and Computational Sciences (ICICoS), 187–192. https://doi.org/10.1109/ICICoS53627.2021.9651776

Astriana Mulyani. 2023. Visualisasi Data Ticketing Servicedesk Dengan Dashboard Pada PT Brantas Abipraya (Persero). Journal of Information System, Applied, Management, Accounting and Research., 7(2).

Chai, L., Li, J., Tangpong, C., & Clauss, T. 2020. The interplays of coopetition, conflicts, trust, and efficiency process innovation in vertical B2B relationships. Industrial Marketing Management, 85, 269–280. https://doi.org/10.1016/j.indmarman.2019.11.004

Farizki, R., Mualiman, L., Wicaksono, F., De Jesus, F. S., Autonomous, M., & Cuong, V. H. 2022. Web-Based Electronic Goods Sales Application Design. International Journal of Social Service and Research, 2(8), 729–735. https://doi.org/10.46799/ijssr.v2i8.155

Fernandes, E., Moro, S., Cortez, P., Batista, F., & Ribeiro, R. 2021. A data-driven approach to measure restaurant performance by combining online reviews with historical sales data. International Journal of Hospitality Management, 94, 102830. https://doi.org/10.1016/j.ijhm.2020.102830

Kevin, F. 2023. Perancangan Dashboard Laporan Penjualan Pada Toko HBI. Jurnal Ilmu Komputer Dan Sistem Informasi, 11(1). https://doi.org/10.24912/jiksi.v11i1.24147

Li, Q. 2022. Evaluation of Artificial Intelligence Models and Wireless Network Applications for Enterprise Sales Management Innovation under the New Retail Format. Wireless Communications and Mobile Computing, 2022, 1–10. https://doi.org/10.1155/2022/8576677

Massaro, A., Maritati, V., & Galiano, A. 2018. Data Mining Model Performance of Sales Predictive Algorithms Based on Rapidminer Workflows. International Journal of Computer Science and Information Technology, 10(3), 39–56. https://doi.org/10.5121/ijcsit.2018.10303.

Puji Saputra, & Kurniati. 2020. Dashboard Business Intelligence untuk Monitoring Siswa siswi baru pada SMA Negeri 1 Lubai. Bina Darma Conference on Computer Science, 2(5).

Sadikin, M., & SK, P. 2018. The Implementation of E-Learning System Governance to Deal with User Need, Institution Objective, and Regulation Compliance. TELKOMNIKA (Telecommunication Computing Electronics and Control), 16(3), 1332. https://doi.org/10.12928/telkomnika.v16i3.8699

Saputra, M., & Tony. 2023. Rancang Bangun Dashboard Penjualan pada PT. XYZ dengan Microsoft PowerBI. Jurnal Ilmu Komputer Dan Sistem Informasi, 11(2). https://doi.org/10.24912/jiksi.v11i2.26028

Spakova, A., & Uhanova, M. 2019. An Overview And Evaluation Of Black-Boxtesting Methods For System Testing. Proceedings of the International Conferences Big Data Analytics, Data Mining and Computational Intelligence 2019; and Theory and Practice in Modern Computing 2019, 225–229. https://doi.org/10.33965/tpmc2019_201907C030

Thomas Connolly, & Carolyn Begg. 2015. Database Systems: A Practical Approach to Design, Implementation, and Management, sixth edition, global edition, 6th ed., Pearson.

Triana, Y. S., & Retnowardhani, A. 2019. Enhance interval width of crime forecasting with ARIMA model-fuzzy alpha cut. TELKOMNIKA (Telecommunication Computing Electronics and Control), 17(3), 1193. https://doi.org/10.12928/telkomnika.v17i3.12233

Veza, O. V., Arifin, N. Y., Saro, D., & Adam, R. 2020. Dashboard Monitoring Kinerja Aparatur Sipil Negara Pada Dinas Pengelolaan Pajak Provinsi Kepulauan Riau. Elkom : Jurnal Elektronika Dan Komputer, 13(2). https://journal.stekom.ac.id/index.php/elkom/article/view/265

Vial, G. 2019. Understanding digital transformation: A review and a research agenda. The Journal of Strategic Information Systems, 28(2), 118–144. https://doi.org/10.1016/j.jsis.2019.01.003

Wardani, N. F., Lazuardi, L., & Kurniawan, M. F. 2022. Hambatan Pemanfaatan Dashboard Jkn Sebagai Sumber Informasi Dalam Pengambilan Kebijakan oleh Dinas Kesehatan (Studi di Dinas Kesehatan Provinsi Lampung dan Kota Bandar Lampung). Jurnal Manajemen Pelayanan Kesehatan (The Indonesian Journal of Health Service Management), 25(03), 83–89. https://doi.org/10.22146/jmpk.v25i03.5124




DOI: http://dx.doi.org/10.33087/jiubj.v24i1.4704

Refbacks

  • There are currently no refbacks.


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

ADRESS JOURNAL

JURNAL ILMIAH UNIVERSITAS BATANGHARI JAMBI (JIUBJ)
Published by Lembaga Penelitian dan Pengabdian kepada Masyarakat
Adress: Jl.Slamet Ryadi, Broni-Jambi, Kec.Telanaipura, Kodepos: 36122, email: jiubj.unbari@gmail.com, Phone: 0741-670700

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