KMITL Expo 2026 LogoKMITL 66th Anniversary Logo

Productivity Improvement in Warehouse Using Power BI and Power Automate

Productivity Improvement in Warehouse Using Power BI and Power Automate

Abstract

This cooperative education project aims to enhance speed and facilitate the verification process for stock issuance, transfers, distributions, and receipts in the warehouse. The primary focus is to address issues related to wasted time and delays in operational processes. Through analysis, it was found that SAP, the current system, involves complex processes requiring specialized expertise. Although the company has developed the iWarehouse system to improve efficiency, delays and procedural complexity persist. To resolve these challenges, Power BI was utilized to visualize data related to stock issuance, transfers, distributions, and receipts, allowing warehouse staff to work more efficiently by minimizing waste and accelerating processes. Additionally, Power Automate was integrated to automate the processing of received stock numbers from emails, reducing errors and delays caused by manual data entry. The results of this improvement indicate a significant increase in employee efficiency and a noticeable reduction in wasted time. Upon project completion, the findings and development approach will be provided to the company for further enhancement.

Objective

เนื่องจากในกระบวนการทำงานในคลังสินค้า ในหน่วยงานส่วนจัดหาและบริหารพัสดุ กรณีศึกษาบริษัท ปตท. จำกัด (มหาชน) ศูนย์ปฏิบัติการชลบุรี มีเวลาสูญเปล่าเกิดขึ้นเป็นจำนวนมาก และมีกระบวนการทำงานที่ซับซ้อน และยังขาดเครื่องมือหรือเทคโนโลยีสมัยใหม่

Other Innovations

Automatic License Plate Recognition Service

คณะวิศวกรรมศาสตร์

Automatic License Plate Recognition Service

This project focuses on the development of an automatic license plate recognition system that supports both standard and special license plates in Thailand. By utilizing Machine Learning technology, the system enhances the efficiency of license plate reading. It can process data from both images and videos. Users can register and subscribe to the service, allowing them to send data for processing through RESTful API, WebSocket, and registered IP cameras.

Read more
Hacking the Show: QoP and Log Data Analyses of Interactive Concert Experiences

วิทยาลัยวิศวกรรมสังคีต

Hacking the Show: QoP and Log Data Analyses of Interactive Concert Experiences

This work attempts to spark conversations about the technical and creative aspects of participatory concert settings. It features the results of two interactive research concerts on basis of audience participation quantities, motion analysis and log data clustering. Ultimately, it poses questions how participatory work can help when teaching interactive technology for the arts and beyond.

Read more
Metaverse Ho Klong For tourism in Phitsanulok Province

คณะเทคโนโลยีสารสนเทศ

Metaverse Ho Klong For tourism in Phitsanulok Province

This research project aims to study and develop a metaverse system for tourism in Horklong Subdistrict, Phitsanulok Province. The primary goal is to create a prototype metaverse system that showcases the cultural and historical tourist attractions in Horklong Subdistrict through virtual reality technology. This will help promote tourism in rural areas that are not yet widely known and enhance the modern promotion of tourist attractions in the province. The development of the metaverse system in this project utilizes virtual reality technology to simulate the experience of touring Horklong Subdistrict via a virtual boat ride. Users will be able to access the system through the Unity platform, which is a tool used to develop 3D and VR applications. The system is designed to allow users to choose to ride a virtual boat and visit various places that have been creatively recreated in a virtual format. These locations are designed and developed using 3D models based on real data collected from the Horklong Subdistrict area. This project is therefore an initiative to sustainably promote cultural and historical tourism in Phitsanulok Province. It has the potential to increase income for local communities as well as to disseminate local knowledge and wisdom to a broader audience. The metaverse system for tourism in Horklong Subdistrict is thus an important project in modernizing the province’s tourism sector and attracting more visitors, both domestically and internationally.

Read more