Implementasi Business Intelligence pada Sistem Informasi Backstore Berbasis Web untuk Monitoring Operasional Toko Ritel
Implementation of Business Intelligence in a Web-Based Backstore Information System for Retail Store Operational Monitoring
Abstract
Operational management in modern retail stores requires an information system capable of supporting fast, accurate, and integrated data monitoring. However, operational data management in some retail stores is still conducted separately using spreadsheets, resulting in low data integration, delays in information presentation, and limited real-time monitoring capabilities. This study aims to implement Business Intelligence in a web-based backstore information system to support centralized and data-driven retail operational monitoring. The research employed the Waterfall software development approach, which was selected because the system requirements had been clearly identified, allowing the development process to be carried out systematically through the stages of requirements analysis, system design, implementation, testing, and evaluation. The system was developed using PHP, the CodeIgniter 3 framework, MySQL database, and the Model-View-Controller (MVC) architecture. The implementation of Business Intelligence was carried out through a visual dashboard displaying integrated operational indicators, including sales data, keepstock, damaged goods, stock checklist, and petty cash. System testing using the Blackbox Testing method showed that all system functions operated according to user requirements. The results indicate that the system successfully improved operational data integration, accelerated monitoring and data recapitulation processes, and supported more effective and real-time data-driven decision-making within retail store operations.References
[1] A. Shollo and I. Galliers, “Towards an understanding of the role of business intelligence systems in organisational knowing,” Information Systems Journal, vol. 26, no. 4, pp. 339–367, 2021.
[2] R. K. Gupta and S. Sharma, “Real-time data analytics in retail AI solutions and monitoring tools,” Journal of Artificial Intelligence and Technology, vol. 5, no. 2, pp. 45–53, 2023.
[3] Y. Muku, A. Setiawan, and D. Prabowo, “Pengembangan sistem business intelligence dalam monitoring performa perusahaan multi company,” Jurnal Teknologi Informasi dan Komunikasi, vol. 8, no. 1, pp. 12–20, 2023.
[4] S. Anardani, R. Firmansyah, and N. Hidayati, “The implementation of business intelligence to analyze sales trends in the online store using Power BI,” Brilliance: Research of Artificial Intelligence, vol. 4, no. 2, pp. 88–96, 2024.
[5] S. Panda and P. Banerjee, “Integration of business intelligence in modern retail system,” Journal of Emerging Technologies and Innovative Research, vol. 10, no. 10, pp. 310–316, 2023.
[6] A. Dennis, B. H. Wixom, and D. Tegarden, Systems Analysis and Design: An Object-Oriented Approach with UML, 6th ed. Hoboken, NJ, USA: Wiley, 2020.
[7] R. S. Pressman and B. R. Maxim, Software Engineering: A Practitioner’s Approach, 9th ed. New York, NY, USA: McGraw-Hill, 2020.
[8] I. Sommerville, Software Engineering, 10th ed. Boston, MA, USA: Pearson, 2021.
[9] M. A. Mustaqbal, R. F. Firdaus, and H. Rahmadi, “Pengujian aplikasi menggunakan metode Blackbox Testing boundary value analysis,” Jurnal Ilmiah Teknologi Informasi Terapan, vol. 1, no. 3, pp. 31–36, 2021.
[10] M. Alparslan and S. Topaloglu, “Business intelligence and analytics applications in retail industry: A systematic literature review,” Journal of Retailing and Consumer Services, vol. 68, pp. 1–12, 2022.
[11] P. Raut, V. Mangla, and S. Narwane, “Applications of business intelligence for data-driven decision-making in retail sector,” Procedia Computer Science, vol. 218, pp. 1123–1131, 2023.
[12] H. Watson, “Tutorial: Business intelligence dashboards,” Communications of the Association for Information Systems, vol. 51, no. 1, pp. 1–20, 2022.
[13] C. Coronel and S. Morris, Database Systems: Design, Implementation, and Management, 14th ed. Boston, MA, USA: Cengage Learning, 2021.
[14] H. J. Watson and B. H. Wixom, “The current state of business intelligence,” Computer, vol. 40, no. 9, pp. 96–99, 2021.
[15] E. Turban, R. Sharda, and D. Delen, Business Intelligence, Analytics, and Data Science: A Managerial Perspective, 5th ed. Hoboken, NJ, USA: Pearson, 2022.
[16] A. Dennis, B. H. Wixom, and D. Tegarden, Systems Analysis and Design: An Object-Oriented Approach with UML, 6th ed. Hoboken, NJ, USA: Wiley, 2020.
[17] M. Helfert and C. O’Brien, “Data governance for business intelligence systems,” Journal of Decision Systems, vol. 31, no. 2, pp. 85–98, 2022.
[2] R. K. Gupta and S. Sharma, “Real-time data analytics in retail AI solutions and monitoring tools,” Journal of Artificial Intelligence and Technology, vol. 5, no. 2, pp. 45–53, 2023.
[3] Y. Muku, A. Setiawan, and D. Prabowo, “Pengembangan sistem business intelligence dalam monitoring performa perusahaan multi company,” Jurnal Teknologi Informasi dan Komunikasi, vol. 8, no. 1, pp. 12–20, 2023.
[4] S. Anardani, R. Firmansyah, and N. Hidayati, “The implementation of business intelligence to analyze sales trends in the online store using Power BI,” Brilliance: Research of Artificial Intelligence, vol. 4, no. 2, pp. 88–96, 2024.
[5] S. Panda and P. Banerjee, “Integration of business intelligence in modern retail system,” Journal of Emerging Technologies and Innovative Research, vol. 10, no. 10, pp. 310–316, 2023.
[6] A. Dennis, B. H. Wixom, and D. Tegarden, Systems Analysis and Design: An Object-Oriented Approach with UML, 6th ed. Hoboken, NJ, USA: Wiley, 2020.
[7] R. S. Pressman and B. R. Maxim, Software Engineering: A Practitioner’s Approach, 9th ed. New York, NY, USA: McGraw-Hill, 2020.
[8] I. Sommerville, Software Engineering, 10th ed. Boston, MA, USA: Pearson, 2021.
[9] M. A. Mustaqbal, R. F. Firdaus, and H. Rahmadi, “Pengujian aplikasi menggunakan metode Blackbox Testing boundary value analysis,” Jurnal Ilmiah Teknologi Informasi Terapan, vol. 1, no. 3, pp. 31–36, 2021.
[10] M. Alparslan and S. Topaloglu, “Business intelligence and analytics applications in retail industry: A systematic literature review,” Journal of Retailing and Consumer Services, vol. 68, pp. 1–12, 2022.
[11] P. Raut, V. Mangla, and S. Narwane, “Applications of business intelligence for data-driven decision-making in retail sector,” Procedia Computer Science, vol. 218, pp. 1123–1131, 2023.
[12] H. Watson, “Tutorial: Business intelligence dashboards,” Communications of the Association for Information Systems, vol. 51, no. 1, pp. 1–20, 2022.
[13] C. Coronel and S. Morris, Database Systems: Design, Implementation, and Management, 14th ed. Boston, MA, USA: Cengage Learning, 2021.
[14] H. J. Watson and B. H. Wixom, “The current state of business intelligence,” Computer, vol. 40, no. 9, pp. 96–99, 2021.
[15] E. Turban, R. Sharda, and D. Delen, Business Intelligence, Analytics, and Data Science: A Managerial Perspective, 5th ed. Hoboken, NJ, USA: Pearson, 2022.
[16] A. Dennis, B. H. Wixom, and D. Tegarden, Systems Analysis and Design: An Object-Oriented Approach with UML, 6th ed. Hoboken, NJ, USA: Wiley, 2020.
[17] M. Helfert and C. O’Brien, “Data governance for business intelligence systems,” Journal of Decision Systems, vol. 31, no. 2, pp. 85–98, 2022.
Published
2026-06-08
How to Cite
ZAILANI, Mirza Fatqul; ARIFIN, Yoseph Tajul; SAFITRI, Rizky Ade.
Implementasi Business Intelligence pada Sistem Informasi Backstore Berbasis Web untuk Monitoring Operasional Toko Ritel.
INFORMATION SYSTEM FOR EDUCATORS AND PROFESSIONALS : Journal of Information System, [S.l.], v. 11, n. 1, p. 35-48, june 2026.
ISSN 2548-3587.
Available at: <https://ejournal-binainsani.ac.id/index.php/ISBI/article/view/3892>. Date accessed: 05 july 2026.
doi: https://doi.org/10.51211/isbi.v11i1.3892.
Section
Articles
