Using Data Analytics and Visualization Dashboard for Engineering, Procurement, and Construction Project's Performance Assessment

Abstract

This study demonstrates the application of design principles for tools in Engineering, Procurement, and Construction (EPC) projects for project management purposes. It advocates the use of proper data analytics and visualization that can be implemented to support effective project progress reporting as well as performance monitoring. At first, an Entity Relationship Diagram (ERD) of the collected data was developed, and then the database was retrieved into the Microsoft Power BI for analysis and visualization. The project's relevant details were visualized and analyzed in terms of the major key performance indications that help evaluate the current situation of projects and aids in future decision making for project performance and portfolio management. A real case of a construction company has been selected and examined. Analytical results support finding the story behind the data. On the other hand, the effects point out that the use of the suitable facts analytics method coupled with the right analytics method and appropriate data visualization software would result in optimum use of information for future aspiration of project success and proper project progress reporting and performance evaluation. It will help companies to transfer from traditional data storage style to big data analytics and powerful use of enterprise business data for companies' growth and success in the field of EPC projects and the construction industries as a whole. Furthermore, it can be used for quicker and extra decisive choices aiming to keep projects on music about their security performance, scheduled time, cost, and great level. Using the proposed dashboard is creating a summary of the accessible records that prints a photo of how initiatives and portfolios are performing, permitting decision-makers to take their future strategic steps aiming for the improvement of their initiatives and accordingly success in their cutting-edge and future endeavors to reap the objective of all stakeholders of this organization. In this paper, it was demonstrated that the visualization of the contractor's performance and KPI are bringing assurance on contractor performance in addition to daily operational monitoring. Furthermore, it helps managers in organizing the workload to ensure the project's completion timely and meeting the customer demand as expected.