Mike - we are new to Workfront and not yet live, however below are the elements I currently include on my monthly PMO Scorecard. I am hoping to report similar information from Workfront though I anticipate many calculations will continue to be excel based. NOTE: Timeframe is indicated at the beginning of each item. FYI, the trending information helps with staffing decisions.
YTD: Planned to Actual Project Status (The majority of our projects are identified in Annual Planning which includes anticipated Kick Off/Deploy Quarters)
Pending
Active
Deployed or Closed
Total Projects (may vary due to unanticipated projects added during quarterly review cycle)
12 Month Trending: # of Active Projects
12 Month Trending: # of Deployments/Cumulative # of Deployments
3 Month Trending: Projects by Project Life Cycle Phase (rolling 3 month trending)
YTD: PMO Transformational Hours by Functional Areas (Marketing, Finance, Legal, Operations,...etc)
Our PMO include PM, BA, QA, and Data Analyst (Reporting) roles.
This reports helps business leaders connect the work of the project teams to their area of business
Business Intelligence (Reports, Data Requests, Consulting Requests)
Beth Ann Fox Royal Neighbors of America