Description
There is a saying that if it cannot be measured, it cannot be managed. Traditionally, projects have used schedules and budgets to monitor progress.
THE PROJECT
ANALYTICS
FRAMEWORK
Oracle Business Intelligence
by Sid Goel
INTRODUCTION
2
3
© 2012 KPI Partners, Inc.
There is a saying that if it cannot be
measured, it cannot be managed.
Traditionally, projects have used schedules
and budgets to monitor progress. This
only provides part of the answer. It
does not address other variables. Just
because a project comes in on time and
on budget does not mean it is a success.
The deliverables may be of poor quality,
and there may be dozens of outstanding
issues.
A much broader view is required
to insure a project’s ultimate success. The
Project Analytics framework presented here
details the elements of a complete project
analytics framework and how Oracle
Project Analytics meets the needs of this
framework.
Share
4
© 2012 KPI Partners, Inc.
KPI Partners is an Oracle Partner who specializes in Oracle Business
Intelligence (BI) and Oracle Enterprise Performance Management so-
lutions. The award-winning staf at KPI Partners comes directly from
the product engineering departments at Oracle, Siebel, and Hyperion.
In addition to consulting services, KPI Partners ofers training, support,
and exclusive pre-packaged analytic solution extensions for Oracle
Business Intelligence.
KPI Partners works with both corporate technology departments and
corporate business units to develop value-added business intelligence
solutions, not just new technology deployments.
About KPI
Share
Table of Contents
CHAPTER 1
Project Defnition
11 Project Types
14 Project Progress
16 Project Analytics Framework
CHAPTER 2
Metrics
19 Schedule
20 Scope
22 Resource
23 Quality
24 Cost
26 Revenue
27 Financial Performance Management
CHAPTER 3
Project Reporting Strategy
30 Top Down Approach
31 Bottom Up Approach
33 Both Approaches
5
© 2012 KPI Partners, Inc.
CHAPTER 4
Project Analytics Solution
34 World Class Project Analytics
36 Oracle Project Analytics
41 Out of the Box Metrics
43 Data Integration Options
44 Deployment Options
CHAPTER 5
Case Study
30 Oracle Project Analytics and Earned
Value Management from PeopleSoft,
Primavera and Legacy Application
CHAPTER 6
Summary
51 The Project Analytics Framework
Share
CHAPTER 1
PROJECT
DEFINITION
6
Many of us at KPI Partners have been
involved with Project Management
in various industries - including
manufacturing, service and construction.
In addition, KPI Partners is a project-based
business and experiences frsthand many of
the same challenges described here.
In our experience, the defnition of what
constitutes a project varies widely between
departments, industries and even among
project managers.
A Project Analytics system helps to manage
projects by providing key information to all
key project stakeholders, at the right time,
to make proactive and informed project
decisions.
7
© 2012 KPI Partners, Inc.
Share
8
© 2012 KPI Partners, Inc.
A project is often defned as a fnite
endeavor, having specifc start and
completion dates, undertaken to create a
unique product or service which add value
in terms of additional revenue or reduced
cost. All projects have constraints like
dates, budgets, resources, etc. All projects
also have goals and objectives.
Do you know how many projects are
underway at your company? Current
economic conditions require resources
from diferent teams to bond together
for mission-critical activities. These are
projects and tracking performance is a
huge priority.
Share
9
© 2012 KPI Partners, Inc.
The primary goal of a Project Analytics
system is to help project stakeholders meet
project objectives in an optimized manner
while honoring the project constraints.
Project Analytics systems help to manage
projects by providing key information
about the project to the diferent key
stakeholders including:
• The project team members.
• The benefciary of the project
(i.e., employees or customers).
• The project sponsors or steering
committee.
• The project funding source (i.e., internal
or external).
Share
10
© 2012 KPI Partners, Inc.
• The project cost manager (could be
internal fnance department or
customer’s fnance department).
• The project revenue manager for
customer funded projects.
All stakeholders will have diferent
informational needs that a Project Analytics
system needs to satisfy. One primary
determinant of stakeholder need is the
type of project being analyzed. In KPI
Partners’ experience with hundreds of
projects across multiple industries, we
have identifed four main project types.
These project types and the industries that
they are commonly associated with are
described in the next section.
Share
End Of Preview
1
Download The Entire E-Book At
www.kpipartners.com
www.kpipartners.com
doc_949726235.pdf
There is a saying that if it cannot be measured, it cannot be managed. Traditionally, projects have used schedules and budgets to monitor progress.
THE PROJECT
ANALYTICS
FRAMEWORK
Oracle Business Intelligence
by Sid Goel
INTRODUCTION
2
3
© 2012 KPI Partners, Inc.
There is a saying that if it cannot be
measured, it cannot be managed.
Traditionally, projects have used schedules
and budgets to monitor progress. This
only provides part of the answer. It
does not address other variables. Just
because a project comes in on time and
on budget does not mean it is a success.
The deliverables may be of poor quality,
and there may be dozens of outstanding
issues.
A much broader view is required
to insure a project’s ultimate success. The
Project Analytics framework presented here
details the elements of a complete project
analytics framework and how Oracle
Project Analytics meets the needs of this
framework.
Share
4
© 2012 KPI Partners, Inc.
KPI Partners is an Oracle Partner who specializes in Oracle Business
Intelligence (BI) and Oracle Enterprise Performance Management so-
lutions. The award-winning staf at KPI Partners comes directly from
the product engineering departments at Oracle, Siebel, and Hyperion.
In addition to consulting services, KPI Partners ofers training, support,
and exclusive pre-packaged analytic solution extensions for Oracle
Business Intelligence.
KPI Partners works with both corporate technology departments and
corporate business units to develop value-added business intelligence
solutions, not just new technology deployments.
About KPI
Share
Table of Contents
CHAPTER 1
Project Defnition
11 Project Types
14 Project Progress
16 Project Analytics Framework
CHAPTER 2
Metrics
19 Schedule
20 Scope
22 Resource
23 Quality
24 Cost
26 Revenue
27 Financial Performance Management
CHAPTER 3
Project Reporting Strategy
30 Top Down Approach
31 Bottom Up Approach
33 Both Approaches
5
© 2012 KPI Partners, Inc.
CHAPTER 4
Project Analytics Solution
34 World Class Project Analytics
36 Oracle Project Analytics
41 Out of the Box Metrics
43 Data Integration Options
44 Deployment Options
CHAPTER 5
Case Study
30 Oracle Project Analytics and Earned
Value Management from PeopleSoft,
Primavera and Legacy Application
CHAPTER 6
Summary
51 The Project Analytics Framework
Share
CHAPTER 1
PROJECT
DEFINITION
6
Many of us at KPI Partners have been
involved with Project Management
in various industries - including
manufacturing, service and construction.
In addition, KPI Partners is a project-based
business and experiences frsthand many of
the same challenges described here.
In our experience, the defnition of what
constitutes a project varies widely between
departments, industries and even among
project managers.
A Project Analytics system helps to manage
projects by providing key information to all
key project stakeholders, at the right time,
to make proactive and informed project
decisions.
7
© 2012 KPI Partners, Inc.
Share
8
© 2012 KPI Partners, Inc.
A project is often defned as a fnite
endeavor, having specifc start and
completion dates, undertaken to create a
unique product or service which add value
in terms of additional revenue or reduced
cost. All projects have constraints like
dates, budgets, resources, etc. All projects
also have goals and objectives.
Do you know how many projects are
underway at your company? Current
economic conditions require resources
from diferent teams to bond together
for mission-critical activities. These are
projects and tracking performance is a
huge priority.
Share
9
© 2012 KPI Partners, Inc.
The primary goal of a Project Analytics
system is to help project stakeholders meet
project objectives in an optimized manner
while honoring the project constraints.
Project Analytics systems help to manage
projects by providing key information
about the project to the diferent key
stakeholders including:
• The project team members.
• The benefciary of the project
(i.e., employees or customers).
• The project sponsors or steering
committee.
• The project funding source (i.e., internal
or external).
Share
10
© 2012 KPI Partners, Inc.
• The project cost manager (could be
internal fnance department or
customer’s fnance department).
• The project revenue manager for
customer funded projects.
All stakeholders will have diferent
informational needs that a Project Analytics
system needs to satisfy. One primary
determinant of stakeholder need is the
type of project being analyzed. In KPI
Partners’ experience with hundreds of
projects across multiple industries, we
have identifed four main project types.
These project types and the industries that
they are commonly associated with are
described in the next section.
Share
End Of Preview
1
Download The Entire E-Book At
www.kpipartners.com
www.kpipartners.com
doc_949726235.pdf