P6-Calculator and P6-Reporter Makes Power BI Reporting a Breeze
Major North Eastern utility company uses P6-Reporter and P6-Calculator to improve their reporting.
regulatory metrics management
Client Overview
Major North Eastern utility using P6 to plan transmission and distribution maintenance and projects. The team needed to improve their ability to ensure that regulatory deliverables were being met while managing the deliverables in a more balanced and consistent manner.
Challenges
-
With hundreds of projects on the go across several states with different regulatory reporting requirements, setting standards across the team for consolidated management reporting was needed
-
Ensuring that regulatory commitment dates are met within the month, quarter and year was critical but very time consuming to manage
-
Giving the P6 scheduling team a quick way to find missing P6 information for coding and tracking milestone commitment dates was needed
Results
-
Using P6-Calculator to flag and count key in-service milestones within P6 and then snapshotted for use within Power BI
-
P6-Loader was used to cleanup manually created data that was used in the reporting to set up standards
-
P6-Reporter automatically snapshotted the reports every Monday at 8am to give management current reports for the weekly status meeting
-
P6-Calculator did automatic quarterly and monthly flagging for easy data validation across P6 and Power BI
-
Produced overall project metrics, in-service monitoring, construction readiness, and scheduling team production reporting
-
P6-Auditor allows for ongoing metrics for schedule performance on update counts to avoid bottlenecks and back dating tasks
