Deriving Performance Metrics From Project Plans to Provide KPIs for Management Information
Download
1 / 27

Deriving Performance Metrics From Project Plans to Provide KPIs for Management Information - PowerPoint PPT Presentation


  • 101 Views
  • Uploaded on

Deriving Performance Metrics From Project Plans to Provide KPIs for Management Information. Primavera SIG October 2013. Overview. Amey has defined metrics for improved management information New innovative approach which allows early warning of issues

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about ' Deriving Performance Metrics From Project Plans to Provide KPIs for Management Information' - clover


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  • Primavera SIG October 2013


Overview
Overview KPIs for Management Information

  • Amey has defined metrics for improved management information

  • New innovative approach which allows early warning of issues

  • Senior managers can manage by exception and not get buried in detail

  • Use of web based dashboards within Primavera P6


Bryan Lambe – Amey

Andy Robinson - RPCuk


  • Agenda KPIs for Management Information

  • Amey company overview

  • Amey – Project landscape

  • Challenges in planning and managing projects

  • “Don’t get bogged down in detail” - Managing by exception

  • Agreeing sensible metrics

  • Defining data requirements

  • Developing the dashboards

  • Future enhancements planned

  • Question and Answers


  • Amey works with public and private sector clients, supporting them to deliver services to the public more effectively.

  • We operate across three principal sectors:- Transport, Social and Environmental Infrastructure.

  • Amey delivers a comprehensive highways infrastructure service to clients across the UK including local authorities, the Highways Agency, Transport for London and Transport Scotland.

  • Our Rail team is made up of diverse and highly skilled engineers, inspectors, examiners and project managers.

  • We deliver expert consultancy on a range of rail projects from specialist tasks to major multidisciplinary programmes, in accordance with the Network Rail GRIP process.

  • Amey supports public and private sector clients in the delivery of effective service

  • Three principal sectors: Transport, Social and Environmental Infrastructure

  • Comprehensive highways infrastructure service to clients across the UK including the Highways Agency, Transport for London, Transport Scotland and local authorities

  • Our Rail team is made up of diverse and highly skilled engineers, inspectors, examiners and project managers

  • We deliver expert consultancy on a range of rail projects from specialist tasks to major multidisciplinary programmes, in accordance with the Network Rail GRIP process


What did we need to do
What did we need to do? KPIs for Management Information

  • Review Project Planning and Control

  • Use industry-recognised Project Planning software:

    • Microsoft Project (MSP)

    • Asta Power Project

    • Oracle Primavera.

  • Previous versions of Primavera use standalone programming tools

  • Oracle Primavera P6 8.2 Enterprise Project Portfolio Management (EPPM ) allows multiple user access to a database through a WEB based Cloud Environment.


  • What drives our project management
    What drives our Project Management? KPIs for Management Information

    • Client based funding model doesn’t directly tie to project level activity

    • Need to match project delivery schedule to financial allocation schedule

    • Projects can be very large – 80,000 activities

    • Need to improve project budgeting process

    • Better tracking of project costs – budget versus actual

    • Portfolio analysis by project phase to improve future effectiveness


    Why oracle primavera landscape
    Why Oracle Primavera Landscape? KPIs for Management Information

    • Amey chose Oracle Primavera because:

    • It is easily configurable to our business needs

    • It provides a standard approach to using the software for new and existing users

    • It uses templates to allow standardised project creation, with automated project financial integration

    • It uses dashboard tracking and reporting at portfolio and project level

    • It allows us to see where are we and what will happen

    • It helps with further project planning and control for today’s needs and tomorrow’s requirements


    Standard approach to using primavera new and existing users
    Standard approach to using KPIs for Management InformationPrimavera:new and existing users

    • Benefits are:

    • Ease of use

    • Project data readily available to all users, at all levels

    • Improved reporting accuracy

    • Ability to develop through future enhancements

    • Standard application and user processes


    Standard approach to using primavera ease of use standard application views
    Standard approach to using KPIs for Management InformationPrimavera:ease of use – standard application views


    Standardised project creation using templates
    Standardised project KPIs for Management Informationcreation:using templates

    • Benefits are:

    • Standardised reporting

    • Easy to update activity via data export / import

    • Enable standardised performance measurements

    • Removal of data entry duplication

    • Standard project level data (e.g. Project Manager allocation by project)


    Template milestones
    Template Milestones KPIs for Management Information


    Template summary bar view to wbs
    Template Summary Bar View to WBS KPIs for Management Information


    Automated project financial integration
    Automated project financial KPIs for Management Informationintegration

    • Benefits are:

    • Forecast directly connected to the schedule

    • All project data within the same tool

    • No requirement for bespoke applications (SAP and P6 are standard off the shelf products)

    • Reduction in user effort to ensure financial and schedule data are aligned


    Automated project financial integration1
    Automated project financial KPIs for Management Informationintegration

    • Forecast directly connected to the schedule

    Forecast cell made non-editable as dates driven from schedule.


    Standardised project reporting
    Standardised project KPIs for Management Informationreporting

    • Benefits are:

    • All project performance and tracking data are reported are within the same tool

    • No additional user effort is required to produce these reports

    • Reporting via dashboards

    • Project positive and negative variances are quickly identified which provides more time to implement corrective actions


    Defining key metrics
    Defining Key Metrics KPIs for Management Information

    • Need to be user definable – no programming

    • Consistent across all projects

    • Based upon project details – no manual intervention Accessed via the web

    • Weighted to take account of project phase


    Management information dashboards the process
    Management Information Dashboards: KPIs for Management Informationthe process

    • Process:

    • Identify key users, stakeholders

    • Define metrics

    • Develop user based weighting rules for indicators

    • Develop filters to segment data

    • Produce dashboards


    Avoid too much detail
    Avoid Too Much Detail KPIs for Management Information

    • Create high level portfolio views to filter project information


    Customise views to suit audience
    Customise Views to Suit Audience KPIs for Management Information


    Role based dashboard views
    Role Based Dashboard Views KPIs for Management Information

    • Final output is the dashboard, which is shared or user specific


    Dashboards track and report performance
    Dashboards: track and report performance KPIs for Management Information

    Standardised performance measurements


    Dashboards track and report performance1
    Dashboards: track KPIs for Management Informationand report performance

    • Simple performance dashboards

    • = Early or as Planned.

    • = Within planned date and plus 1 week.

    • = Within planned date plus 1 week and plus 2 weeks.

    • = Within planned date plus 2 weeks and plus 3 weeks.

    • = Later or equal to planned date plus 4 weeks.


    Dashboards track and report performance2
    Dashboards: track KPIs for Management Informationand report performance

    • Project positive and negative variances quickly identified

    • Allocation cost % Variance-PAF value.

    • Completion Cost % Variance-Allocation.

    • Completion Cost % Variance-Target Price.

    • Target Price % Variance-Allocation.

    • = Allocation cost is equal to or less than PAF value.

    • = Allocation cost is greater than PAF value and less than PAF value plus 10%.

    • = Allocation cost is greater than PAF value plus 10% .

    • = Current forecast is equal to or less than Allocation.

    • = Current forecast is greater than Allocation and less than Allocation plus 20%.

    • = Current forecast is greater than Allocation plus 20%.

    • = Current forecast is equal to or less than Target Price.

    • = Current forecast is greater than Allocation and less than Target Price plus 20%.

    • = Current forecast is greater than Target price plus 20%.

    • = Target Price is equal to or less than Allocation.

    • = Target Price is greater than Allocation and less than Allocation plus 20%.

    • = Target Price is greater than Allocation plus 20%.


    Where are we now and what are the next steps
    Where are we now – KPIs for Management Informationand what are the next steps?

    • Dashboards in use and live across all projects

    • Refining metrics for phase sensitive reporting

    • Reporting being used by senior business managers

    • Incorporate SAP data feed to automatically produce financial metrics

    • Additional metrics to produce forecasted earned value style data


    Summary
    Summary KPIs for Management Information

    • Key facts:

    • Dashboard summaries based upon project detail

    • User defined metrics and weighting algorithms

    • Can be used to compare performance across projects

    • Web access for ease of deployment

    • Key benefits:

    • Dashboards give up to date picture

    • Accurate financial reporting

    • Benchmarking of projects and milestone attainment

    • Early warning for projects requiring attention


    • THANK YOU KPIs for Management Information

    • Any Questions?


    ad