Designing a Model for Preparing Reports on the Automatic Earned Value Management Progress by the Integration of Primavera P6, SQL Database, and Power BI: A Case Study of a Six-Storey Concrete Building in Mashhad, Iran

Authors: Hamed Zolfaghari, Mojtaba Kord

Abstract:

Project planners and controllers are frequently faced with the challenge of inadequate software for the preparation of automatic project progress reports based on actual project information updates. They usually make dashboards in Microsoft Excel, which is local and not applicable online. Another shortcoming is that Microsoft project does not store the data in database, so the data cannot automatically be imported from Microsoft Project into Microsoft Excel. This study aimed to propose a model for the preparation of reports on automatic online project progress based on actual project information updates by the integration of Primavera P6, SQL database, and Power BI (Business Intelligence) for a construction project. The designed model could be applicable to project planners and controller agents by enabling them to prepare project reports automatically and immediately after updating the project schedule using actual information. To develop the model, the data were entered into P6, and the information was stored on the SQL database. The proposed model could prepare a wide range of reports, such as earned value management, Human Resource (HR) reports, and financial, physical, and risk reports automatically on the Power BI application. Furthermore, the reports could be published and shared online.

Keywords: Primavera P6, SQL, Power BI, Earned Value Management, Integration Management.

References:

[1] Hindu Odugu, Aravindan Achuthan, Impact of prefabrication technology on profitability using Primavera p6, Materials Today: Proceedings, 2020.
[2] O.M. Yigitbasioglu, O. Velcu, A review of dashboards in performance management: Implications for design and research, Int. J. Account. Inf. Syst. 13 (2012) 41–59.
[3] Brian Larson, Data Analysis with Microsoft Power Bi, 2020
[4] Samir El-Omari, Osama Moselhi, Integrating automated data acquisition technologies for progress reporting of construction projects ,2011
[5] A.A.D.A.J. Perera, K. Imriyas, An integrated construction project cost information system using MS AccessTM and MS ProjectTM, 2004.
[6] Emad Elbeltagi, Mahmoud Dawood, Integrated visualized time control system for repetitive construction projects,2011
[7] Mario Nadj, Alexander Maedche, Christian Schieder, The Effect of Interactive Analytical Dashboard Features on Situation Awareness and Task Performance, 2020.
[8] PMBOK6, 2017
[9] Mithun Murali M, Kollam, Review of work progress by Earned Value Analysis,2018
[10] A. Naderpour, M. Mofid, Improving Construction Management of an Educational Center by Applying Earned Value Technique, 2011.