Designing Warehouse Dashboards Based on the Industrial Logistics Performance Index

Main Article Content

Pawarit Phrapathomnawee
Kanate Puntusavase

Abstract

Nowadays, technology has become important to business operations, business strategy, and management. However, organizations or executives are unable to extract, use data or understand and interpret data effectively. This research aims to design a logistics management dashboard based on logistics performance index for warehouse departments in the industrial sector. The sample industrial factory is the one which manufactures cleaning agents and imports machinery products. This dashboard design uses index that are derived from considering 9 logistics activities together with a 3-dimensional perspective, including cost, time, and reliability dimensions. The dashboard is designed in 3 user perspectives. The results revealed that the dashboard showing results of index can be divided into 3 parts: for overall viewing, for analysis, and for operations. This caused action, resulting in the value of product holdings per sale decreasing from 2.08 times to 1.90 times. The average storage period for finished goods decreased from 468 days to 450 days, which is consistent with the satisfaction assessment results. The mean score of the users’ satisfaction was 3.56 out of 4 with the standard deviation of 0.13. The dashboard design for this warehouse can be used as a guideline for designing dashboards for other tasks, starting from using the index in this business. This will allow the application of data for development in actual business.               

Article Details

How to Cite
Phrapathomnawee, P., & Puntusavase, K. . (2025). Designing Warehouse Dashboards Based on the Industrial Logistics Performance Index. JOURNAL OF SOUTHERN TECHNOLOGY, 18(2), 121–135. retrieved from https://so04.tci-thaijo.org/index.php/journal_sct/article/view/272424
Section
Research Manuscript

References

Bhargava, M. G., Kiran, T. P. S., & Rao, D. R. (2018). Analysis and design of visualization of educational institution database using power BI tool. Double Blind Peer Reviewed International Research Journal, 18(4), 1-7.

Halim, K. K., Halim, S., & Felecia. (2019). Business intelligence for designing restaurant marketing strategy: A Case Study. In Procedia Computer Science, 161, 615–622.

Huang, L. H. (2019). Building A Sales Dashboard for A Sales Department by Using Power BI. Laurea University of Applied Sciences.

Kaewwit, R. (2011). Business intelligence development with data warehouse. Executive Journal, 31(1), 160-165. [in Thai]

Mulik, T., Malusare, P., Takalkar, O., & Patil, M. (2018). Business intelligence: dashboard. International Journal of Engineering Research & Technology (IJERT) ICONECT' 14 Conference Proceedings, 14, 169-173.

Pipatjessadakul, P., & Pinngern, U. (2019). Development of business intelligence systems to support electrical distribution. Journal of Project in Computer Science and Information Technology, 5(2), 48-56. [in Thai]

Ploywattanawong, K., Kannika, T., & Pangjikri, D. (2020). Plan report created on dashboard phase 1. The International and National Conference on Business Administration and Accountancy 2020 (p. 278-286) [In Thai]

Sampantvorabutr, A., & Adsavakulchai, S. (2015). Data warehouse system for performance assessment of internal auditors: case study in internal auditor department, Bangkok metropolitan administration. Journal of Science and Technology University of the Thai Chamber of Commerce, 2(1), 19-32. [in Thai]

Srichai, C. (2012). Organization environments Influencing Business Intelligence Usage in Thailand SMEs. National Institute of Development Administration. [in Thai]

Tiangsombun, P., & Chirawichitchai, N. (2018). Business intelligence systems to support executive forecasting and decisions making case study: healthcare. Veridian E-Journal, Science and Technology Silpakorn University, 5(4), 16-30. [in Thai]

Young, G. W., & Kitchin, R. (2020). Creating design guidelines for building city dashboards from a user's perspectives. International Journal of Human-Computer Studies, 140, 1-17.