Industry: Top 5 National Commercial Construction Leader
Users/Teams: Schedulers, Project Managers, Executives, Data/IT
Technology Stack:
- Power Automate: Automated workflows to streamline the ingestion of granular Primavera P6 data in near-real-time, eliminating reliance on manual exports.
- Power Apps: Custom interface for schedulers to validate data, input commentary, and ensure alignment of fields, improving data accuracy before reporting.
- Azure SQL Database: Managed a versioned data model with timestamped records that provide full historical tracking and auditability over 24 months.
- Power BI: Delivered dynamic, role-based dashboards replacing static Excel reports, enhancing visualization, interactivity, and user adoption.
- Primavera P6 API: Provided direct programmatic access to project management data replacing brittle and rigid Azure Data Factory pipelines.
Challenge:
The construction leader’s existing system depended on manual exports from Primavera P6 and rigid Azure Data Factory (ADF) batch pipelines that processed tens of thousands of rows per project with significant latency. P6 API complexity across multiple related tables (Tasks, Task Resources, Resource Assignments) made automation brittle and difficult to maintain. Additionally, the lack of historical snapshots meant that field value updates overwrote previous data, hampering audits and traceability. Heavy dependency on Excel for data manipulation slowed down analysis and obscured important scheduler commentary and context, reducing confidence. Overall delays in data preparation and report generation impeded timely project decision-making.
Solution:
eSoftware Associates implemented a hybrid Microsoft-native architecture integrating Power Platform and Azure services for streamlined, scalable, and auditable P6 data integration and reporting.
Key solution components included:
- Power Automate flows configured to extract detailed P6 data nearly in real-time, reducing dependence on manual exports and batch pipelines.
- Power Apps applications enabling schedulers to review, validate, add commentary, and align data fields before committing to reporting datasets.
- Azure SQL implementing a sophisticated versioned data model with month and version IDs, supporting snapshot retention over 24 months and full historical audit trails.
- Power BI dashboards designed with role-based, dynamic filtering that replaced 15+ static Excel reports with interactive visualizations tailored for different user groups.
- Embedded data logic to accurately separate labor versus material resources and sum craft hours with finish-date calculations aligned to legacy reports.
Impact:
The modernization initiative delivered significant operational and financial benefits:
- Reduced analysis preparation time from approximately 5 days to less than 1 day, achieving a 90% increase in speed.
- Estimated annual cost savings of about $1.4 million by automating workflows and eliminating manual efforts.
- Scaled data ingestion and refresh processes to handle around 1.5 million activity and resource rows per cycle efficiently.
- Expanded historical data retention capabilities to maintain 24 months of versioned snapshots, enhancing auditability and compliance.
- Reduced manual data preparation by roughly 70% with automated pipelines, validations, and user-driven data quality controls.
- Transitioned reporting from more than 15 static Excel reports to over 10 real-time, role-based Power BI dashboards, improving data trust and adoption among users.
Summary:
By replacing manual exports and brittle Azure Data Factory pipelines with a modern, flexible hybrid architecture using Power Automate, Power Apps, Azure SQL, Power BI, and Primavera P6 API, the client transformed their enterprise-scale project data integration and reporting. This solution enhanced scalability, auditability, and responsiveness while delivering substantial cost savings and user empowerment. eSoftware Associates continues to support the client’s data modernization journey by advancing analytics and workflow automation across their projects.
Ready to replace slow and manual exports with auditable, real-time reporting? We can help you implement a Microsoft-native architecture that scales.