KMITL Innovation Expo 2025 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

VulnaChat: Vulnerability Chatbot

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

VulnaChat: Vulnerability Chatbot

This capstone project develops an AI-powered chatbot to address cybersecurity vulnerabilities, leveraging the Common Vulnerabilities and Exposures (CVE) system and the Common Vulnerability Scoring System (CVSS). The chatbot will provide accessible and informative support for understanding and mitigating these vulnerabilities, potentially leading to significant improvements in cybersecurity practices.

Read more
Development of media for youth ‘Khun Chang Khun Phaen : Khun Chang Dedicate The Petition’ to facilitate creative tourism and economy in Suphanburi

คณะสถาปัตยกรรม ศิลปะและการออกแบบ

Development of media for youth ‘Khun Chang Khun Phaen : Khun Chang Dedicate The Petition’ to facilitate creative tourism and economy in Suphanburi

-

Read more
EV conversion for a pick-up truck taxi

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

EV conversion for a pick-up truck taxi

ยานยนต์ไฟฟ้าดัดแปลง

Read more