Design and Implementation of an AI-Integrated Power BI Dashboard for Data-Driven Logistics Management: A Case Study of Ninja Van Pengkalan Chepa
DOI:
https://doi.org/10.11113/ijic.v16n1-2.700Keywords:
Ninja Van, Data visualization, Logistics Dashboard, Customer Segmentation, AI Chatbot, Business IntelligenceAbstract
The exponential growth of e-commerce has intensified operational demands on courier and logistics services, making real-time performance monitoring and customer insight generation vital for competitiveness. In Malaysia, regional hubs such as Ninja Van Pengkalan Chepa (TrustCo) face recurring challenges, including parcel overload during peak seasons, manual reporting processes, and limited visibility into customer behavior. This study addresses these issues through the novel development of an integrated Power BI dashboard enhanced with AI chatbot capabilities, specifically tailored for regional courier operations, a combination not previously implemented in Malaysia’s logistics context. Employing a design and development research approach based on the Software Development Life Cycle (SDLC) framework with Agile principles, operational data from 2022–2025 including parcel volumes, delivery metrics, and customer feedback were analyzed and visualized. The proposed system integrates three innovative modules: (1) Operational Monitoring, for courier performance tracking; (2) Customer Analytics, enabling demographic segmentation and sentiment analysis; and (3) AI Interaction, introducing natural language query processing through a chatbot interface. User Acceptance Testing (UAT) involving logistics professionals validated the system’s usability, with 86.7% reporting intuitive navigation, 80% confirming data accessibility, and 93.3% verifying filter accuracy.
References
Banerjee, K., Das, S., & Nath, S. (2024). Data visualization approach for business strategy recommendation using a Power BI dashboard. International Journal of Research in Management.
Baskoro, F., Andrahsmara, R. A., Darnoto, B. R. P., & Tofan, Y. A. (2021). A systematic comparison of software requirements classification. IPTEK: The Journal for Technology and Science.
Biedert, R., & Roth-Berghofer, T. R. (2008). Designing a context-sensitive dashboard for an adaptive knowledge worker assistant. Semantic Scholar.
Fazaeli, S., Khodaveisi, T., Vakilzadeh, A. K., Yousefi, M., Ariafar, A., Shokoohizadeh, M., & Mohammad-Pour, S. (2021). Development, implementation, and user evaluation of COVID-19 dashboard in a third-level hospital in Iran.
Jintana, J., Sopadang, A., & Ramingwong, S. (2021). Idea selection of new service for courier business: The opportunity of data analytics. International Journal of Engineering Business Management.
Kallel, M. B. E., Bouajaja, S., & Elloumi, A. (2024). Developing a sales dashboard with Power BI: A case study in a pharmaceutical company. Decision Making Advances.
Kamaruddin, S. A. B., Hashim, H. B., Mohamad, E. J. B., Mohamad, N. H. B., & Mamat, H. B. (2023). Effective visualization electrification system via PSCADA event log in railway industry.
Khalid, A. S., Hassan, N. H., Razak, N. A., & Baharuden, A. F. (2020). Business intelligence dashboard for driver performance in fleet management. In Proceedings of the 2020 11th International Conference on E-Education, E-Business, E-Management, and E-Learning.
Khayashi, F., Jamasb, B., Akbari, R., & Shamsinejadbabaki, P. (2022). Deep learning methods for software requirement classification: A performance study on the PURE dataset.
Khilari, D., Singh, C., & Mane, M. (2022). Business intelligence tool-Power BI for performance management. SSRN Electronic Journal.
Kobi, J. (2024). Developing dashboard analytics and visualization tools for effective performance management and continuous process improvement. International Journal of Innovative Science and Research Technology (IJISRT).
Mahendrawathi, E., Pranantha, D., & Utomo, J. D. (2010). Development of dashboard for hospital logistics management. In 2010 IEEE Conference on Open Systems (ICOS 2010).
Nabil, D. H., Rahman, M. H., Chowdhury, A. H., & Menezes, B. C. (2023). Managing supply chain performance using a real-time Microsoft Power BI dashboard by action design research (ADR) method. Cogent Engineering.
Nova, S. H., Widodo, A. P., & Warsito, B. (2022). Analisis metode agile pada pengembangan sistem informasi berbasis website: Systematic literature review. Techno Com, 21(1).
Panghal, R. (2024). The role of data visualization in decision making: Case of D-Mart. International Journal for Multidisciplinary Research, 6(3).
Riya, Singh, G., Singh, J., & Singh, P. (2022). Preliminary analysis of data visualization based Uber technology using R: A review. In 2022 International Conference on Augmented Intelligence and Sustainable Systems (ICAISS) (pp. 721–725).
Schreiber, A., Von Kurnatowski, L., Meinecke, A., & De Boer, C. (2021). An interactive dashboard for visualizing the provenance of software development processes. In IEEE Working Conference on Software Visualization (pp. 100–104).
Silva, D., Pereira, P., & Amaro, A. (2020). Logistic performance & dashboards: A flexible Power BI solution.
Sindhu, K., Jain, K. A., Sandhya, S., & Nasreen, D. A. (2020). Comparative study and review of principles for dashboard design.
Singh, K. (2021). Agile methodology for product development: A conceptual study. International Journal of Recent Technology and Engineering (IJRTE), 10(1), 209–215.
Sohail, F., Zia, S. S., Qureshi, R., Naseem, M., & Haider, H. (2021). Impact of agile methodology on software development life cycle. Pakistan Journal of Engineering and Technology, 4(2), 153–158.
Tsai, W., Liu, C., Lin, H., Hsu, C., Ma, Y., Chen, C., Huang, C., & Chen, C. (2022). Design and implementation of a comprehensive AI dashboard for real-time prediction of adverse prognosis of ED patients. Healthcare, 10(8), 1498. https://doi.org/10.3390/healthcare10081498
Downloads
Published
Issue
Section
License
Copyright (c) 2026 International Journal of Innovative Computing
This work is licensed under a Creative Commons Attribution 4.0 International License.
