High Tech Company Extracts Data from MS Project Plans for Managing Milestones
A High Tech engineering and manufacturing company wanted to manage its projects at different levels: task level for project managers and milestone level for program leaders without maintaining 2 separate plans.
ProjectLead designed and developed a custom project dashboard in Excel which downloaded project milestone data from over 50 project plans stored and maintained in MS Project.
ProjectLead defined and built custom fields in Excel for program leaders to capture additional project data and custom charts for viewing of milestone projections to schedule goals graphically.
ProjectLead designed and developed an upload of updated project data from Excel into the corporate portfolio management system.
RESULTS
Right-Leveling Information
Projects were able to be viewed at the detail needed by each level in the organization.
Elimination of Redundant Systems / Maintenance
Maintaining dates only in MS Project and uploading to other systems eliminated the need for double or triple data entry.
Graphical View of Potential Schedule Problems
Visualizing schedule problems at a milestone and graphical level helped leaders see where future problems might materialize.
Comments