deltek insight 2010: costpoint analytics: delivering analytical dashboards for executives

CP- 131: Costpoint Analytics: Delivering Analytical Dashboards for Executives

1

Presented by:

Nikki Mehta, Director, Product Marketing

Rick Miller, Director, Product Management

Agenda

• Performance Management Overview• What are Analytics Dashboards?• Costpoint Analytics: The First Phase• Live Product Demo

Copyright © 2010 Deltek, Inc. 2

Performance Management Overview


Performance Management Cycle

2008 Deltek, Inc. 4

STRATEGY

EXECUTION2009 by TDWI (The Data Warehousing Institute TM)

a division of 1105 Media, Inc.

Performance Management


Enterprise AnalyticsCostpoint Analytics

• Role Based Dashboards, out of the box metrics

• Robust ad-hoc, drill down, & trending analysis

• Synthesize Information across Multiple Data Sources

• Powered by QlikView

Enterprise ReportingDeltek Performance Mgt. (DPM)

• Ad-Hoc Query Generation

• Self Service Report Authoring

• Supported by Reporting Models on top of Transactional Costpoint database

• Reporting against multiple data sources

• Powered by IBM/Cognos

Budgeting & PlanningCostpoint Budgeting & Planning

• Create & manage project & organizational budgets

• See project status & costs in real time

• Fully integrated

• 180 reports

Project Lifecycle

PerformanceManagement

BusinessDevelopment

ProjectInitiation

Performance& Delivery

Post Performance& Support

Extensive use of data, statistical and quantitative analysis, and fact based

management to drive business decisions and actions.

What is Analytics?

2009 Deltek, Inc • CONFIDENTIAL • All Rights Reserved. 7

“40% of business decisions are not based on data and facts; but on gut instinct.”

Competing on Analytics


NETFLIX

What is Netflix’s Core Competency?

A) First to Offer Unlimited Rentals for Set Monthly Fees – No Late Fees, No Due Dates

B) Analyzes Customer Choices on movies and recommends films that both match customer preferences and optimize inventory conditions.


Costpoint Analytics “The First Phase”

Analytics for Executives and Operational Managers

To Manage the Growth and Financial Viability, Executives and Operational Managers need:

1. Complete View of the Business Outlook: What is my revenue and profitability? How healthy is the backlog? Am I winning enough new business?

2. Focus In and Contain Costs: Are actual rates in line with projections or out of control?

3. Proactively Manage Risks: Do the historical trends align with future forecasts? How do I influence the future for positive results?

4. A Solution that is Easy to Use and Customize: Do I have to go IT to make changes to graphs, charts, and visuals?

Executive Goals


Goal #1: Complete View of the Business Outlook

“I need visibility to key performance metrics to ensure the firm is focused on the right projects and the right resources.”

Time

Time & Expense

Too Much Data, Not enough Information

© 2009 Deltek, Inc. All Rights Reserved

13

Change or Delay

People

Silkroad

CP Payroll

CP HR

Organization

CostpointCore

EnterprisePlanner

Projects

Cobra/MPM

EnterprisePlanner

OpenPlan

GovWin Winsight

Business Development

Executives/Finance

HR ManagersProgram Managers

Time

Time & Expense

How do I turn data into information for decision making?

© 2009 Deltek, Inc. All Rights Reserved

14

Change or Delay

People

Silkroad

CP Payroll

CP HR

Organization

CostpointCore

EnterprisePlanner

Projects

Cobra/MPM

EnterprisePlanner

OpenPlan

GovWin Winsight


Executives/Finance

HR ManagersProgram Managers

Inaccuracy – Rework – Time Loss

Visibility to Key Performance Metrics

Key Pain Points:– I have too much data, not enough information. It takes too much

time – weeks – to get the information I need.– Is my company meeting it’s financial, staffing, & project objectives?– I need fast and easy access to key company metrics. I want to

know what’s going on, so I can make proactive decisions and stay profitable.

Executive and Operational Manager Dashboard: – Visibility to key operational metrics – Drill down to charts, graphs, and grid-like reports– Compare actuals to budgets & forecast

Benefits:– Provides greater visibility into the company’s health. Am I invested

in the right projects?– Uses real time actual data – Make Faster Decisions


Project Lifecycle- Key Metrics

Backlog & End of Contracts Adjustments

Projects at Risk

Indirect Rates


Project InitiationPerformance &

DeliveryPost Performance

& Support

Profit

BacklogPipeline /

Opportunities

Win Business

Labor Utilization

Revenue

Summary Dashboard

Goal #2: Cost Containment “I need to able to further analyze the data to better understand how did we get here.”

Analysis – Are we going in the right direction?

• Key Pain Points:– My rates are too high and I’m losing money; or My rates are

too low and I’m leaving money on the table.– How can I analyze the data to better understand how I am

trending?

• Built In & Ad Hoc Analysis with Every Dashboard– Analyze Rates by Pool Names (6 types of pool)– Drill down by Organization, Division, Account , Project – Compare Rate Performance by Actuals, Budgeted, &

Provisional or Target– View Trends for Specific Pools

• Benefits:– Take corrective actions to ensure your actuals are in line with

projections and approved rates. – Ability to quantify non-project profitability impact.– Looking at everything one way can mask critical flaws until it’s

too late. Analysis can help unmask critical flaws.


Product Demo

• Indirect Rate Dashboard Example

• Example Ad Hoc Analysis


Goal #3Proactively Identify Risks and Influence the Future for Positive Results

“I need to be able identify trends and adjust course.”

What do we know?


The extraordinary is now ordinary


Causing Many to Question Traditional Management Practices


Focus on Failure

• What are my critical failure factors?

– Do I have the right balance of backlog and new projects?

– How is direct or indirect labor impacting my organizational goals?

– Are my projects profitable?

– How much has been billed above the funded or contract value?

– Does the cost exceed budget by 5%?

– Does revenue exceed funded or contract value?

• Benefits:– Identifies negative trends, allowing immediate response

and correction – Prevent Risks before they happen

26 2009 Deltek, Inc • CONFIDENTIAL • All Rights Reserved. 26

Goal #4: Intuitive like the MAC

“I need solution that is intuitive, easy to use, and easy to customize to meet the needs of different users ”

Costpoint Analytics Delivers..


Easy of Use as Consumer App Single User Interface for Dashboard &

Analysis Enables real-time associative search

and analysis

Easy of Deployment Single Integrated Stack Built in Dashboards & Metric

Calculations Built in Drill downs to Charts and Grid

Reports Integrated Costpoint Models

Easy of Customization Create or modify existing dashboards Change charts, graphs, & visualizations Change or modify calculations/metrics Pull data from 3rd party sources

Deltek Costpoint® Budgeting & Planning

Deltek Costpoint® CRM

Products

Deltek Costpoint®

Analytics

Deltek Costpoint®

Integrated Solution


Costpoint Analytics

Integrated Stack

Single User Interface for Dashboards and Analysis

Deltek Costpoint® Budgeting & Planning

Deltek Costpoint® CRM

Deltek Costpoint®

Multiple Data Sources

Traditional Online Analytical Processing

(OLAP ) Solution

Transformation Layer (ETL)

Data Warehouse

OLAP Cubes

Design ToolSeparate User Interface for Dashboards and Analysis


Associative Analysis: …Costpoint Analytics Works The Way Your Mind Thinks

YOU think in non-linear paths by building associations

There is business value to that …


Achieving The Impossible:Customer Experience

Findings from IDC/QlikTech Joint Survey

BI Initiative Success and Satisfaction• 96% of customers are satisfied with QlikView

ROI (Return On Investment)• 186% Return On Investment• 6.5 month payback period

Time to Value

44% deployed QlikView in 1 Month

77% deployed QlikView in 3 Months

50% reduction in information access and analysis time

-100 0 100

Costpoint Analytics Strategy

Deltek Sources

CostpointCore

Costpoint HR &

Materials

Deltek Time & Expense

CRMEVM

Budgeting

Third Party Sources

HR

MS ProjectExcel

Role Based Analytics

Executive Project Mgmt HRBus Dev

Dashboards/ KPIs

Drill to Details

Ad Hoc Analysis

Notifications/ Alerts

What If Analysis

Manufacturing

CRM

Costpoint Analytics Summary

2008 Deltek, Inc. 35

Executive Pain Points:

• Too Much Data, Inconsistent

• Actionable information delivered in context

• Exception reporting of critical performance issues

• How is current performance impacting future?

Targeted Personas::– CEO, Senior Executives, Divisional VPs,

Operational Managers

Description• Out of the Box, Highly Configurable

• Corporate/Project Performance Center

– Top projects at risk, most profitable, etc…

– Trending with Budgets and Actuals

– Industry benchmark comparisons

• Built In Alerts and Notifications

• Ad Hoc Analysis

How do I learn more?

• Come & see us at the Solutions Pavilion – Costpoint Analytics Kiosk

• CP-132 Costpoint Analytics: How to Build & Deploy Customized Dashboards – Advanced Session– Wednesday, May 19 10:00 AM - 11:00 AM

– Wednesday, May 19 5:45 PM - 6:45 PM

• CP-137 The Power of Data Visualization with Analytics– Tuesday, May 18 3:45 PM - 4:45 PM

• Innovations Labs – Costpoint Analytics on a iPAD!


Any Questions?

Product Requirements


deltek insight 2010: costpoint analytics: delivering analytical dashboards for executives

Technology

analytics dashboards

multiple data sources

costpoint analyticsthe

extensive use of data

key performance metricsto

business decisionsare

new business

project status costs