Effectiveness of Power BI Supporting Project Management for Installation of Aseptic Beverage Filling System

Abstract

This research aimed to apply Microsoft Power BI to monitor and analyze the performance of aseptic beverage filling system installation projects. A simulated project dataset for the year 2024 was used as a case study to evaluate the program’s ability to store, integrate, and analyze project information in terms of both timeline and budget. The results of the study indicate that the operation of Power BI, through its connection with a Microsoft Excel database, allows data to be modified and updated continuously. In addition, Power BI is capable of presenting project data in the form of comprehensive interactive dashboards, enabling effective visualization and analysis of 26 simulated projects through 3 types of dashboards: (1) Overall project performance, which summarizes project management outcomes in terms of project planning, project status, and project managers’ workload (2) Overall project timeline, which summarizes project implementation plans according to key time periods and(3) Overall project budget utilization, which compares project budgets for procurement, transportation, installation, and customer training, and is used to monitor project performance across the four quarters of the year 2024. The research findings confirm that Power BI can present project performance in a complete and easily understandable dashboard format. Furthermore, when the dashboard outputs in Power BI were compared with the underlying database, the results showed that the data displayed on the Power BI dashboards were consistent with the data stored in Microsoft Excel. This demonstrates that Power BI is stable in linking data with Microsoft Excel and is a highly capable tool for managing projects with repetitive workflows. It effectively supports progress tracking, budget analysis, and decision-making in project management.