Project portfolio monitoring for national ministry

data

Objective

A national ministry of roads wants to track the progress and quality of all federal road building projects.

Requirements:

  • Bi-weekly aggregation of data from multiple sources (decentral project status reports, time sheets, budget and spending from central IT systems, lab results from web service)
  • Multiple reports/analyses with individual filters to provide both high level overviews and drill-down to projects/suppliers
2

Technical solution

  • Small Excel-based survey distributed to project manager for bi-weekly completion
  • Central Excel tool to consolidate data from all sources and provide reporting
impact

Result

  • Ministry achieved full transparency of all on-going projects
  • The tool facilitates stakeholder involvement across all levels, especially between vendor and project management
  • Powerful reporting functionality allows for cross-vendor comparison, supporting vendor assessment for future projects
Industry
Public Services
Tool type
Dashboards & heatmaps
Project duration
3 months
d2i effort
10 MD
Data volume
120 projects
Biweekly reporting
15 KPIs
Tools involved
Excel
No images found.
Cookies make it easier for us to provide you with our services. With the usage of our services you permit us to use cookies.
Ok