Implementation of A Web-Based Multi-Role Business Intelligence Dashboard for Retail Sales Monitoring at Astra Honda Cooperative
Downloads
The rapid advancement of information technology has encouraged organizations to utilize data as a strategic asset to support business operations and decision-making. Retail sales management in cooperative organizations often faces challenges in monitoring sales performance due to fragmented data sources and limited access to timely information. This study aims to implement a web-based multi-role Business Intelligence dashboard for retail sales monitoring at Astra Honda Cooperative. The system was developed using the CRISP-DM framework, the Python programming language, the Streamlit framework, and a MySQL database. Role-Based Access Control (RBAC) was implemented to provide different access privileges for administrators, cashiers, and managers. The dashboard integrates sales transaction data into a centralized system and presents information through interactive visualizations to support decision-making processes. The implementation results demonstrate that the developed dashboard can facilitate sales monitoring, improve data accessibility, and support managerial decision-making through real-time and historical sales analysis. Therefore, the proposed system provides a practical Business Intelligence solution for retail sales management in cooperative environments.
Adewusi, A. O., Okoli, U. I., Adaga, E., Olorunsogo, T., Asuzu, O. F., & Daraojimba, D. O. (2024). Business intelligence in the era of big data: A review of analytical tools and competitive advantage. Computer Science & IT Research Journal, 5(2), 415–431.
Akbar, R., Rahmadoni, J., & Lubis, H. A. (2022). The implementation of business intelligence on visualisation of transaction data analysis using Dashboard System Case Study: XYZ convenience store. 2022 International Symposium on Information Technology and Digital Innovation (ISITDI), 42–49.
Alqhatani, A., Ashraf, M. S., Ferzund, J., Shaf, A., Abosaq, H. A., Rahman, S., Irfan, M., & Alqhtani, S. M. (2022). 360 retail business analytics by adopting hybrid machine learning and a business intelligence approach. Sustainability, 14(19), 11942.
Altarawneh, H., & Tarawneh, M. M. (2023). Business intelligence and information system management: A conceptual view. Journal of System and Management Sciences, 13(2), 31–44.
Bame, F. U. (2026). Analisis Efektifitas Sistem Pementauan Pengendalian dan Pengawasan ((SISPANDALWAS) Pada Kawasan Konservasi Perairan Daerah Raja Ampat. Universitas Pendidikan Muhammadiyah Sorong.
Biswas, T. R., Hossain, M. Z., & Comite, U. (2024). Role of management information systems in enhancing decision-making in large-scale organizations. Pacific Journal of Business Innovation and Strategy, 1(1), 5–18.
Das, S., Banerjee, K., Nath, S., & Chatterjee, S. (2023). Data visualization approach for business strategy recommendation using Power BI dashboard. International Journal of Latest Engineering Science, 6(5), 1–11.
Duarte, E. P., Sos, S., MPPM, H. T., Purwantoro, I. S. A., Yanto, S., Dewanto, I. H., Sumarno, I. A. P., Wibowo, A., Hartono, U., & Soemantri, A. I. (2025). Manajemen Pertahanan dalam Pengelolaan Sumber Daya Nasional Untuk Pertahanan Negara. Indonesia Emas Group.
Gangula, U. K. R. (2025). Streamlining data management in salesforce: From fragmentation to centralization. J Artif Intell Mach Learn & Data Sci 2025, 3(3), 2783–2789.
Hamdat, A., Ceskakusumadewi, B., Samalam, A. G., Rizal, M., & Lawalata, I. L. D. (2024). The impact of management information systems on decision-making efficiency. Vifada Management and Digital Business, 1(2), 56–74.
Hasibuan, T. H. (2023). Sistem informasi penjualan dalam peningkatan layanan digital berbasis web. Jurnal Ilmiah Teknik Informatika dan Komunikasi, 3(2), 250–257. https://doi.org/10.55606/juitik.v2i2.661
Hidayat, T., Munthe, I. R., & Juledi, A. P. (2024). Analisis data penjualan menggunakan algoritma Apriori pada analisis kopi. Informatika, 12(3), 443–452. https://doi.org/10.36987/informatika.v12i3.6064
Leogrande, A. (2024). Unlocking hidden value: A framework for transforming dark data in organizational decision-making.
Maulana, A., & Sy, S. (2024). Cooperation management system model kerjasama sipil-militer dalam pengelolaan sumber daya nasional. Mega Press Nusantara.
Murugan, S., Daniel, K. L., Ananthi, D. M., Rajkumar, D. P., & Jenitha, S. S. (2024). Retail store sales analysis: Unveiling insights through Power BI business analytics. Proceedings of the International Conference on Innovative Computing & Communication (ICICC 2024).
Önden, A. (2026). A systemic approach to decision support and automation: the role of big data analytics and real-time processing in management information systems. Systems, 14(2), 216.
Rahul, D. Das, Mahmud, I., Aqif, H., Tariquzzaman, M., Akter, S., Osman, F. Y., Shafi, S. Bin, & Sozib, H. M. (2022). The Role of Data Visualization in Business Intelligence: Analyzing Tool Adoption and Decision-Making outcomes in US Companies. Cuestiones De Fisioterapia, 51(3), 310–329.
Rianti, A., Majid, N. W. A., & Fauzi, A. (2023). CRISP-DM: Metodologi proyek data science. Prosiding Seminar Nasional Teknologi Informasi dan Bisnis (SENATIB), 107–114.
Rohid Nur Fajrian, M., Nibross Vroticca, G. A., Pratama, A. R., & Wicaksono, H. (2025). Penerapan dashboard business intelligence untuk meningkatkan penjualan mobil: Studi kasus pada perusahaan XYZ. Saturnus: Jurnal Teknologi dan Sistem Informasi, 3(3), 52–60.
Sanjida Akrer, S., Md Imran, K., & Md, R. (2024). Balancing data accessibility and security in cloud-based business intelligence systems. American Journal of Technology Advancement, 1(6), 60–88.
Shafa, H., & Sultana, M. S. (2024). The influence of secure data systems on fraud detection in business intelligence applications. Journal of Sustainable Development and Policy, 3(04), 133–173.
Shubho, O. Q., Tumpa, Z. N., Dipto, W. I. R., & Alam, M. R. (2022). Real-time data visualization using business intelligence techniques in small and medium enterprises for making a faster decision on sales data. In Decision intelligence analytics and the implementation of strategic business management (pp. 189–198). Springer.
Surwade, N. B., Shiragapur, B., & Hussain, A. (2024). Data visualization and dashboard design for enterprise intelligence. In Metaheuristics for Enterprise Data Intelligence (pp. 71–91). CRC Press.
Copyright (c) 2026 Arya Dimas Cakraningrat, Yustika Erliani
This work is licensed under a Creative Commons Attribution-ShareAlike 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 a Creative Commons Attribution-ShareAlike 4.0 International. that allows others to share the work with an acknowledgement 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 acknowledgement 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.
