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

THE DEVELOPMENT OF WASTE SLAG DRAINAGE FLOORING MATERIALS

วิทยาลัยนวัตกรรมการผลิตขั้นสูง

THE DEVELOPMENT OF WASTE SLAG DRAINAGE FLOORING MATERIALS

The objective of this research is to utilize waste slag in industrial applications and help mitigate flooding, water accumulation, and ponding issues. Currently, slag from the steel smelting or refining process is commonly used as a component in construction materials, such as road surfaces. However, slag has properties that make it difficult for water to permeate, leading to poor drainage and increased flooding problems. This study focuses on improving the properties of pavement materials to enhance their strength and water permeability. This can be achieved through physical structural modifications or the addition of chemical agents such as HPMC, which increases void spaces to facilitate water absorption and drainage according to required standards. The utilization of waste slag not only helps reduce production costs and improve material performance but also minimizes environmental impacts and promotes the sustainable use of resources.

Read more
Fundamentals of Managing Technology Ventures

คณะบริหารธุรกิจ

Fundamentals of Managing Technology Ventures

This book introduces basic management concepts that are applicable to technological innovation development. It encompasses various tech settings like Agro & Health tech, in addition to the more commonly referred digital sector.

Read more
Urban Farming Innovation Learning Center

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

Urban Farming Innovation Learning Center

From the current situation and uncertainty; leads to the concept of food security. It is the application of innovation and technology to create high productivity in a limited area. The unused buildings in urban areas were renovated for planting, created as a learning area for planting in urban area. The different methods of growing plants were presented. There are 35 planting innovations for disseminating knowledge, to create food security, self-reliant, supports sustainable living.

Read more