Digital Project Controls Using Primavera P6, EcoSys, and Power BI in Large-Scale EPC Projects

References

[1] Oesterreich TD, Teuteberg F. Understanding the implications of digitisation and automation in the context of Industry 4.0: A triangulation approach and elements of a research agenda for the construction industry. Computers in Industry. 2016;83:121–139. https://doi.org/10.1016/j.compind.2016.09.006

[2] Olanipekun AO, Sutrisna M. Facilitating digital transformation in construction—A systematic review of the current state of the art. Frontiers in Built Environment. 2021;7:660758. https://doi.org/10.3389/fbuil.2021.660758

[3] Whyte J. How digital information transforms project delivery models. Project Management Journal. 2019;50(2):177–194. https://doi.org/10.1177/8756972818823304

[4] Sacks R, Brilakis I, Pikas E, Xie HS, Girolami M. Construction with digital twin information systems. Data-Centric Engineering. 2020;1:e14. https://doi.org/10.1017/dce.2020.16

[5] Boje C, Guerriero A, Kubicki S, Rezgui Y. Towards a semantic construction digital twin: Directions for future research. Automation in Construction. 2020;114:103179. https://doi.org/10.1016/j.autcon.2020.103179

[6] Pan Y, Zhang L. Roles of artificial intelligence in construction engineering and management: A critical review and future trends. Automation in Construction. 2021;122:103517. https://www.sciencedirect.com/science/article/abs/pii/S0926580520310979

[7] Kassem M, Ahmed AL. Digital transformation through building information modelling: Spanning the macro-micro divide. Technological Forecasting and Social Change. 2022. https://doi.org/10.1016/j.techfore.2022.122006

[8] Vandevoorde S, Vanhoucke M. A comparison of different project duration forecasting methods using earned value metrics. International Journal of Project Management. 2006;24(4):289–302. https://doi.org/10.1016/j.ijproman.2005.10.004

[9] Batselier J, Vanhoucke M. Evaluation of deterministic state-of-the-art forecasting approaches for project duration based on earned value management. International Journal of Project Management. 2015. https://doi.org/10.1016/j.ijproman.2015.04.003

[10] Chen X, Chang-Richards AY, Pelosi A, Jia Y, Shen X, Siddiqui MK, et al. Implementation of technologies in the construction industry: A systematic review. Engineering, Construction and Architectural Management. 2022;29(8):3181–3209. https://doi.org/10.1108/ECAM-02-2021-0172

[11] Zhang L, Li Y, Pan Y, Ding L. Advanced informatic technologies for intelligent construction: A review. Engineering Applications of Artificial Intelligence. 2024:109104. https://www.sciencedirect.com/science/article/pii/S0952197624012624

[12] Oracle. Oracle Primavera P6 EPPM version 26 documentation—Integration guides. https://docs.oracle.com/en/industries/construction-engineering/primavera-p6-project/26/integration.html

[13] Hexagon. Integrating EcoSys with P6 Connector, version 2.0. 2025. https://docs.hexagonppm.com/r/en-US/Integrating-EcoSys-with-P6-Connector-2.0/Version-2.0/1236458

[14] Hexagon. EcoSys integration methods, version 8.6. https://docs.hexagonppm.com/r/en-US/EcoSys-Integration-Methods/Version-8.6/871885

[15] Hexagon. Forecasts. EcoSys Projects Help, version 4.11. https://docs.hexagonppm.com/r/en-US/EcoSys-Projects-Help-4.11/Version-4.11/1268705

[16] Hexagon. Create forecast change. EcoSys Projects Help, version 3.02. https://docs.hexagonppm.com/r/en-US/EcoSys-Projects-Help-3.02/Version-3.02/1254120

[17] Oracle. Available columns of the Activities page. Primavera P6 Help. https://docs.oracle.com/cd/F51301_01/p6help/en/47261.htm

[18] Microsoft. Understand star schema and the importance for Power BI. Microsoft Learn. https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

[19] Microsoft. Configure scheduled refresh. Microsoft Learn. https://learn.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

[20] Microsoft. Configure incremental refresh and real-time data for Power BI semantic models. Microsoft Learn. https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-overview

[21] Microsoft. Row-level security (RLS) guidance in Power BI Desktop. Microsoft Learn. https://learn.microsoft.com/en-us/power-bi/guidance/rls-guidance

[22] Microsoft. Many-to-many relationship guidance. Microsoft Learn. https://learn.microsoft.com/en-us/power-bi/guidance/relationships-many-to-many

[23] Microsoft. Data sources in Power BI Desktop. Microsoft Learn. https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-data-sources

[24] Microsoft. On-premises data gateways in Power BI. Microsoft Learn. https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem

[25] Microsoft. Active vs inactive relationship guidance. Microsoft Learn. https://learn.microsoft.com/en-us/power-bi/guidance/relationships-active-inactive

@article{1724306,
      author = {Mohammed Shahabaaz Ahmed},
      title = {Digital Project Controls Using Primavera P6, EcoSys, and Power BI in Large-Scale EPC Projects},
      journal = {Iconic Research And Engineering Journals},
      year = {2026},
      volume = {10},
      number = {4},
      pages = {3522-3533},
      issn = {2456-8880},
      url = {https://www.irejournals.com/formatedpaper/1724306.pdf},
      abstract = {Large engineering, procurement, and construction projects depend on consistent information about scope, dates, expenditure, progress, and emerging changes. Nevertheless, the systems supporting these functions frequently operate with different reporting periods, coding structures, and approval rules. This structured narrative review examines how Primavera P6, EcoSys, and Power BI can be configured as complementary components of an integrated project controls environment. Peer-reviewed construction and project management literature is interpreted alongside official software documentation. The analysis distinguishes schedule calculation, commercial control, and management reporting, and develops a framework connecting these functions through controlled identifiers, period snapshots, reconciliation, and accountable decisions. The principal finding is conceptual: technical connectivity can improve access to information, but reliable control also requires compatible measurement rules and explicit ownership of each data domain. A proposed integration architecture, a measurement matrix, and a transparent arithmetic illustration demonstrate how reporting errors can arise even when individual source records are correct. The paper identifies implementation priorities for large EPC organizations and discusses their relevance to Saudi industrial programs. It concludes that integration should be assessed through traceability, reconciliation quality, forecasting discipline, and the closure of management actions. No project-level performance improvement is estimated because an implementation dataset was not available.},
      keywords = {digital project controls; Primavera P6; EcoSys; Power BI; EPC projects; earned value management; data governance; Saudi Arabia},
      month = {October},
  }