Energy
HSE & Project Intelligence for major capital plant construction
Primary Area
Data Delivery & Transformation
Service Area
Program Reporting
Products Used
Power BI
Roles Impacted
Capital Portfolio Managers, Project Managers, Project Coordinators, Construction Team Lead
Impact Highlight
80% reduction of time for executive report assembly
Opportunity
A Petrochemical company building a major polyurethane complex faced fragmented, slow‑moving information flows. Weekly, monthly, and quarterly safety and status reports were manually stitched together from 34 site teams using Excel, Word, PowerPoint, and verbal updates, delaying insight and heightening risk.
34 independent construction teams maintained disconnected spreadsheets and slide decks.
20 labor hours per reporting cycle were spent assembling packs.
No single source of truth; data discrepancies stalled leadership reviews.
Decision‑making lagged up to two weeks, impacting schedule and safety responsiveness.
Traceability for regulatory compliance audits was limited and error‑prone.
Solution
Our team convened site leaders, HSE specialists, and report developers to redesign information flow end‑to‑end. Using Dataflows and Power Automate on the Power Platform, we automated collection, validation, and visualization while embedding governance and collaboration.
Provided standardized KPI definitions to the governance council.
Collected source files in SharePoint Online, ingested them with Power Automate into a Fabric Lakehouse.
Modeled data in a Power BI semantic layer with audience security, delivering live dashboards.
Unified schedule reporting into Project Online.
Automated approvals and escalations through Power Automate and Adaptive Cards in Teams.
Impact
The program office received trusted HSE and program progress metrics, freeing leaders to act instead of compile—fulfilling Innovations24’s pledge to advance visions and realize requirements. Reporting is continuous, actionable, and scalable to future megaprojects.
~80 % reduction in manual report assembly.
Weekly status cycle shrank from one day to one hour; safety alerts surface within 15 minutes.
Audit preparation time fell by 80%, due to a seamless audit trail.
Steering‑committee decisions accelerated from monthly to bi-weekly without extra meetings.