Rancang Bangun Dashboard Business Intelligence untuk Monitoring Kinerja Penjualan Queen Cell
DOI:
https://doi.org/10.62007/joumi.v4i2.818Keywords:
Business Intelligence, Dashboard, Data Warehouse, Sales Performance Monitoring, VisualizationAbstract
Advancements in information technology encourage business owners to leverage data as a foundation for more effective and accurate decision-making. Queen Cell is a business specializing in the sale of mobile phones and accessories, generating daily sales transaction data. However, sales information is currently presented using conventional methods, complicating performance monitoring and sales evaluation. This study aims to design a Business Intelligence dashboard for monitoring Queen Cell's sales performance, capable of presenting sales data in a visual, interactive, and easily understandable format to support decision-making. The research employs the Research and Development (R&D) method, encompassing stages such as needs identification, data collection, requirements analysis, interface design, prototype creation using the Figma platform, and evaluation and validation. The dashboard is designed to display Key Performance Indicators (KPIs), including total profit, total revenue, units sold, average margin, sales trends, profit composition by product category, and profit comparison per product. Evaluation results indicate that the dashboard prototype achieved a feasibility score of 95% (classified as "Highly Feasible"), thereby satisfying criteria regarding ease of use, visual quality, information clarity, and alignment with user needs. The resulting dashboard presents sales information in a structured and informative manner, enabling the Queen Cell owner to monitor sales performance, evaluate business operations, and support decision-making that is effective, efficient, and data-driven. This prototype is expected to serve as a reference for the development of the Business Intelligence system during the implementation phase.
References
Abhirama, F. A., Wijoyo, S. H., & Setiawan, N. Y. (2026). Pengembangan dashboard business intelligence untuk monitoring penjualan dengan metode Kimball (Studi kasus: UD. Dewi 2F Motor). Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer, 10(13).
Alya, B. Z., Hanum, F., & Rizal, M. (2026). Peran teknologi informasi dalam pengembangan sistem informasi akuntansi dalam meningkatkan kinerja perusahaan: Studi literatur tahun 2023–2025. Jurnal Ilmu Ekonomi dan Bisnis, 4(1), 18–26.
Dipura, S., & Soediantono, D. (2022). Benefits of key performance indicators (KPI) and proposed applications in the defense industry: A literature review. International Journal of Social and Management Studies, 3(4), 23–33.
Gonçalves, C. T., Gonçalves, M. J. A., & Campante, M. I. (2023). Developing integrated performance dashboards visualisations using Power BI as a platform. Information, 14(11), Article 614. https://doi.org/10.3390/info14110614
Hermawan, E., & Rahayu, S. (2026). Perancangan sistem monitoring kinerja berbasis data menggunakan Looker Data Studio pada PT PLN (Persero) ULP Cakranegara. Jurnal Riset Kajian Teknologi dan Lingkungan, 9(1), 155–164.
Islam, M. A. (2026). A systematic review of AI-driven business intelligence architectures for data-informed strategic decision-making methods (2019–2026). American Journal of Advanced Technology and Engineering Solutions, 6(1), 583–621.
Jabar, A. A., Wijaya, R. F., & Wahyuni, S. (2025). Dashboard visualisasi data kecerdasan bisnis untuk mendukung pengambilan keputusan bisnis pada PT BMPT. DJTechno: Jurnal Teknologi Informasi, 6(1), 75–89.
Khasanah, T. N., Putri, N. H., Amalia, S., Rahmadani, R. P., Sujarwo, B., & Arifin, M. (2025). Implementasi dashboard business intelligence menggunakan Looker Studio untuk evaluasi kinerja penjualan elektronik. TEKNOFILE: Jurnal Sistem Informasi, 3(12), 940–945.
Lederman, D., & Maloney, W. F. (2003). R&D and development. SSRN. https://doi.org/10.2139/ssrn.402480
Mahendra, D. R., Pramono, D., & Purnomo, W. (2025). Sistem informasi inventory bahan baku dan penjualan roti terintegrasi dengan payment gateway berbasis website (Studi kasus CV. Family Bakery). Jurnal Pengembangan Teknologi Informasi dan Ilmu Komputer.
Maryadi, M., Asqolani, A., & Sopian, S. (2025). Collaboration business intelligence prototype for the synergy of empowering MSMEs in the government agencies. Jurnal Siasat Bisnis, 27–40.
Nascimento, M. G., Moura, R. J., Valença, G., Fraga, G., Macedo, R., & Andrade, E. (2026). Implementation and validation of a business intelligence dashboard for business process monitoring. Simpósio Brasileiro de Sistemas de Informação (SBSI), 851–870.
Negara, R. P., Astuti, R., Anam, K., Dana, R. D., & Rinaldi, A. R. (2026). Perancangan dashboard business intelligence menggunakan Power BI untuk analisis tren penjualan (Studi kasus: Coffee Shop XYZ). Journal of Computer Science and Artificial Intelligence (JCSAI), 3(3).
Purwanto, E., Utomo, B. P. C., & Permatasari, H. (2022). Prototype sistem informasi monitoring penjualan. Jurnal Teknologi Informasi dan Ilmu Komputer, 9(4), 761–768.
Rasim, R., Mugiarso, M., Handayani, D., & Lubis, H. (2025). Rancang bangun sistem informasi monitoring dan analisis kinerja penjualan menggunakan metode Rapid Application Development (RAD). Journal of Information System, Informatics and Computing, 9(2), 266–274.
Resty, A. (2022). Sistem data penjualan dan monitoring stok barang pada Toko Keripik Aiza. JUKI: Jurnal Komputer dan Informatika, 4(2), 76–85.
Setiawan, I., & Purba, H. H. (2020). A systematic literature review of key performance indicators (KPIs) implementation. Journal of Industrial Engineering & Management Research, 1(3), 200–208.
Wang, P., Rui, X., Gu, J., Huang, K., Zhou, L., & Jiang, M. (2025). Fast parametric modeling of visualized simulation and design for tracked vehicle system. Advances in Engineering Software, 201, Article 103852.
Downloads
Published
How to Cite
Issue
Section
License
Copyright (c) 2026 Akhmadi Wirawan, Elita Yuni Setiyarini
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
