oracle project analytics 8 30 9 30 oracle report manager 9 30 10 00 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Oracle Project Analytics 8:30 – 9:30 Oracle Report Manager 9:30 – 10:00 PowerPoint Presentation
Download Presentation
Oracle Project Analytics 8:30 – 9:30 Oracle Report Manager 9:30 – 10:00

Loading in 2 Seconds...

play fullscreen
1 / 42

Oracle Project Analytics 8:30 – 9:30 Oracle Report Manager 9:30 – 10:00 - PowerPoint PPT Presentation


  • 163 Views
  • Uploaded on

Oracle Project Analytics 8:30 – 9:30 Oracle Report Manager 9:30 – 10:00. Brad Holzer Larry Enright.

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 'Oracle Project Analytics 8:30 – 9:30 Oracle Report Manager 9:30 – 10:00' - Albert_Lan


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
oracle project analytics 8 30 9 30 oracle report manager 9 30 10 00

Oracle Project Analytics 8:30 – 9:30Oracle Report Manager 9:30 – 10:00

Brad Holzer

Larry Enright

slide2

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions.The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

© 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION

"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

oracle project analytics

Oracle Project Analytics

Brad Holzer

Senior Sales Consultant

program agenda
Program Agenda

<Insert Picture Here>

  • Oracle EPM & BI Overview
  • Value of Prebuilt Oracle BI Applications
  • Project Analytics Demonstration
    • Dashboards & Reports
    • Ad Hoc Reporting
  • Q&A

© 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION

"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

who d you vote for
Who’d you vote for?

?

?

© 2006 Oracle Corporation – Proprietary and Confidential

oracle bi applications complete pre built best practice analytics
Oracle BI ApplicationsComplete, Pre-built, Best Practice Analytics

ConsumerSector

Insurance

& Health

Complex

Mfg

FinancialServices

HighTech

LifeSciences

Public Sector

Travel& Trans

Comms& Media

Auto

Energy

Projects

Sales

Service &Contact Center

Funding &Agreements

BudgetsAnalysis

Revenue Analysis

Billing Analysis

Cost Analysis

ProfitabilityAnalysis

ServiceEffectiveness

Customer Satisfaction

ResolutionRates

Service RepEfficiency

Service Cost

Churn & Service Trends

Marketing

Procurement & Spend

Supply Chain & Order Management

Financials

HumanResources

Direct / Indirect Spend

Buyer Productivity

Off Contract Purchases

Supplier Performance

Purchase Cycle Time

Employee Expenses

Revenue andBacklog

Inventory

FulfillmentStatus

CustomerStatus

Order Cycle Time

BOM Analysis

PipelineAnalysis

ForecastAccuracy

Sales Team Effectiveness

Up-sell/ Cross-sell

Cycle Times

Lead Conversion

Campaign Effectiveness

CustomerInsight

Product Propensity

Loyalty &Attrition

Market Basket Analysis

Campaign ROI

General

Ledger

Accounts

Receivable

Accounts

Payable

Cash Flow

Profitability

Expense

Management

Employee Productivity

Compensation

Compliance Reporting

WorkforceProfile

RetentionAnalysis

Return on Human Capital

and Other Operational & Analytic Sources

Source adapters:

Oracle BI Suite Enterprise Edition Plus

© 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION

"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

slide7

An enterprise performance management (EPM) system brings the management processes under a single umbrella, connecting financial and operational decisions and ctivities with transactional systems to form a comprehensive management picture.

  • EPM comprises all performance-related strategic, financial, and operational management processes an organization undertakes.
  • EPM consists of all methodologies, systems, metric
  • and structures to support the management processes.

Only an EPM system, which includes operational BI applications as well as financial performance management

applications, can create that critical link between the operational systems and management systems that enables insight to action.

© 2006 Oracle Corporation – Proprietary and Confidential

slide8

EPM WORKSPACE

Web

Search

Alerts

Mobile

Desktop

Office

Performance Management

Applications

BI Applications

BI Applications

Business Intelligence Foundation

Fusion Middleware

OLAP

Data Warehouse

Data Mart

Business

Process

OLTP & ODS

Systems

SAP, Oracle, Siebel,

PeopleSoft, Custom

Excel

XML

Enterprise Performance Management System

slide9

Enterprise Performance Management SystemMarket Leading Applications

EPM Workspace

EPM Workspace

PERFORMANCE MANAGEMENT APPLICATIONS

BI Applications

Financial

Reporting &

Compliance

Strategy

Management

Business

Planning

Profitability

Management

Business Intelligence Foundation

Fusion Middleware

OLAP

Data Warehouse

Data Mart

Business

Process

Excel

XML

OLTP & ODS

Systems

SAP, Oracle, Siebel,

PeopleSoft, Custom

comprehensive bi applications
Comprehensive BI Applications

EPM Workspace

Performance Management

Applications

Business Intelligence Foundation

Fusion Middleware

BI APPLICATIONS

Finance

Sales

Contact Center

Procurement & Spend

Service

Marketing

HR

Supply Chain & Order Mgmt

OLAP

Data Warehouse

Data Mart

Business

Process

OLTP & ODS

Systems

SAP, Oracle, Siebel,

PeopleSoft, Custom

Excel

XML

© 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION

"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

slide11

EPM Workspace

Performance Management

Applications

BUSINESS INTELLIGENCE FOUNDATION

Common Enterprise Information Model

BI Server

Predictive Analytics

Essbase

Fusion Middleware

OLAP

Data Warehouse

Data Mart

Business

Process

OLTP & ODS

Systems

SAP, Oracle, Siebel,

PeopleSoft, Custom

Excel

XML

Enterprise Performance Management SystemMarket Leading EPM & Comprehensive Analytic Applications

BI APPLICATIONS

PERFORMANCE MANAGEMENT APPLICATIONS

Financial

Reporting &

Compliance

Strategy

Management

Business

Planning

Profitability

Management

Order

Mgmt.

Supply

Chain

Service

HR

Finance

Sales

Mrktg

Projects

enterprise performance management system leverages fusion middleware

EPM Workspace

Performance Management

Applications

BI Applications

Business Intelligence Foundation

FUSION MIDDLEWARE

Data

Quality

Data

Integration

Business Process

Management

Identity

Management

Content

Management

MDM

SOA

OLAP

Data Warehouse

Data Mart

Business

Process

OLTP & ODS

Systems

SAP, Oracle, Siebel,

PeopleSoft, Custom

Excel

XML

Enterprise Performance Management SystemLeverages Fusion Middleware
comprehensive bi applications1
Comprehensive BI Applications

EPM Workspace

Performance Management

Applications

Business Intelligence Foundation

Fusion Middleware

BI APPLICATIONS

Finance

Sales

Contact Center

Procurement & Spend

Service

Marketing

HR

Supply Chain & Order Mgmt

OLAP

Data Warehouse

Data Mart

Business

Process

OLTP & ODS

Systems

SAP, Oracle, Siebel,

PeopleSoft, Custom

Excel

XML

© 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION

"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

oracle project analytics single and multi source analytic apps built on bi suite ee

Proactive

Detection

and Alerts

Actionable

Dashboards

Reporting &

Publishing

Ad-hoc Analysis

Disconnected

Analytics

MS Office

Plug-in

WebServices

Oracle BI Suite EE Plus

Oracle Project AnalyticsSingle- and multi-source Analytic Apps Built on BI Suite EE

Sales

Service &Contact Center

Marketing

Supply Chain &

Order Management

Procurement

and

Spend

Financials

HumanResources

Projects

Oracle BI Applications

Legacy

Project Management, Budget Management, and Accounting

Systems

DW Schema

Packaged

ETL Maps

UniversalAdapters

© 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION

"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

oracle project analytics1

Pre-mapped metadata, including embedded best practice calculations, and over 500 pre-built metrics for the project organization.

3

  • Presentation Layer
  • Logical Business Mode
  • Physical Sources

Pre-built ETL to extract data from a large number of operational tables and load it into the DW, sourced from CRM, ERP, and other sources.

A “best practice” library of over 100 pre-built intelligence dashboards, reports and alerts for project managers, program managers, project accountants, and executives

2

4

Oracle Project Analytics

Pre-built warehouse with 7 star-schemas designed for analysis and reporting on Project funding, agreements, budgets, costing, billings, revenue, performance and profitability data.

1

© 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION

"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

oracle bi applications complete pre built best practice analytics1
Oracle BI ApplicationsComplete, Pre-built, Best Practice Analytics

ConsumerSector

Insurance

& Health

Complex

Mfg

FinancialServices

HighTech

LifeSciences

Public Sector

Travel& Trans

Comms& Media

Auto

Energy

Projects

Sales

Service &Contact Center

Funding &Agreements

BudgetsAnalysis

Revenue Analysis

Billing Analysis

Cost Analysis

ProfitabilityAnalysis

ServiceEffectiveness

Customer Satisfaction

ResolutionRates

Service RepEfficiency

Service Cost

Churn & Service Trends

Marketing

Procurement & Spend

Supply Chain & Order Management

Financials

HumanResources

Direct / Indirect Spend

Buyer Productivity

Off Contract Purchases

Supplier Performance

Purchase Cycle Time

Employee Expenses

Revenue andBacklog

Inventory

FulfillmentStatus

CustomerStatus

Order Cycle Time

BOM Analysis

PipelineAnalysis

ForecastAccuracy

Sales Team Effectiveness

Up-sell/ Cross-sell

Cycle Times

Lead Conversion

Campaign Effectiveness

CustomerInsight

Product Propensity

Loyalty &Attrition

Market Basket Analysis

Campaign ROI

General

Ledger

Accounts

Receivable

Accounts

Payable

Cash Flow

Profitability

Expense

Management

Employee Productivity

Compensation

Compliance Reporting

WorkforceProfile

RetentionAnalysis

Return on Human Capital

and Other Operational & Analytic Sources

Source adapters:

Oracle BI Suite Enterprise Edition Plus

© 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION

"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

oracle bi applications complete pre built best practice analytics2
Oracle BI ApplicationsComplete, Pre-built, Best Practice Analytics

ConsumerSector

Insurance

& Health

Complex

Mfg

FinancialServices

HighTech

LifeSciences

Public Sector

Travel& Trans

Comms& Media

Auto

Energy

Projects

Sales

Service &Contact Center

Funding &Agreements

BudgetsAnalysis

Revenue Analysis

Billing Analysis

Cost Analysis

ProfitabilityAnalysis

ServiceEffectiveness

Customer Satisfaction

ResolutionRates

Service RepEfficiency

Service Cost

Churn & Service Trends

Marketing

Procurement & Spend

Supply Chain & Order Management

Financials

HumanResources

Direct / Indirect Spend

Buyer Productivity

Off Contract Purchases

Supplier Performance

Purchase Cycle Time

Employee Expenses

Revenue andBacklog

Inventory

FulfillmentStatus

CustomerStatus

Order Cycle Time

BOM Analysis

Campaign Effectiveness

CustomerInsight

Product Propensity

Loyalty &Attrition

Market Basket Analysis

Campaign ROI

General

Ledger

Accounts

Receivable

Accounts

Payable

Cash Flow

Profitability

Expense

Management

Employee Productivity

Compensation

Compliance Reporting

WorkforceProfile

RetentionAnalysis

Return on Human Capital

and Other Operational & Analytic Sources

Source adapters:

Oracle BI Suite Enterprise Edition Plus

© 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION

"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

oracle project analytics business need drive intelligent decisions with the insight
Oracle Project Analytics: Business NeedDrive Intelligent Decisions With The Insight
  • Improve Cash Flow - For a $200M project revenue based company, reducing receivables one day > $500k in cash flow
  • Accelerate Deliveries - 10% acceleration of a 16 mo. project with 40% margin and est. rev of $20M = $1M Cash Flow
  • Lower operational costs - Organization can save up to 30-60% in time dedicated to reporting/ communicating status
  • Improve Margins by increasing visibility into change impact
  • Reduce project & financial risk by drilling down and identifying underlying issues

© 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION

"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

slide19

Dashboards

Dashboard

Pages

Roles

Flexible Dashboard

Parameters

Integration with Financial Analytics

Charts/Graphs

Reports based on

Multiple Sources

Integration with Procurement

and Spend Analytics

© 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION

"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

decision workflows actionable analytics
Decision Workflows – Actionable Analytics

Business

Objectives/

Issues

Improve Project

Performance

Is Financial

performance on target?

NOT REALLY

Drill toDetail

Are Project costs

under control?

NO

Gain

Insights

Why? What is the cost

variance?

Why? What is source of

variance?

Who? Which resources is

causing cost variances

TakeAction

Target effortsto reduce theproject costs

© 2008 Oracle Corporation – Proprietary and Confidential FOR INTERNAL USE ONLY, NOT APPROVED FOR EXTERNAL DISTRIBUTION

"This information is not a commitment to deliver any material, code, or functionality. The development, release, and timing of any features or functionality described remains at the sole discretion of Oracle"

slide21

<Insert Picture Here>

Project Analytics

Demonstration

© 2006 Oracle Corporation – Proprietary and Confidential

report manager overview

Report Manager Overview

Larry Enright – Applications Sales Consultant

safe harbor statement
Safe Harbor Statement

The following is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decision. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

© 2006 Oracle Corporation – Proprietary and Confidential

slide24
First let me introduce myself

Brittni

Tammy

Dean

Derek

Larry

© 2006 Oracle Corporation – Proprietary and Confidential

slide25

Before

Today

Who is Larry Enright

1980

College Graduate

1992

Oracle Applications

1995

Applications Consultant

2005

Joined Oracle

© 2006 Oracle Corporation – Proprietary and Confidential

slide26

Before

Today

Industry Experience

Oil & Gas, Manufacturing, Mining, Distribution, Retail, Financial, Software

What else about Larry Enright

Oracle Applications

Customer

Over 10 Implementations

(Character / Client Server

Web Based)

Customers

Revenue Over Billion to Under 50 Million

Before

© 2006 Oracle Corporation – Proprietary and Confidential

slide27

Almost 30 year of IT experience

© 2006 Oracle Corporation – Proprietary and Confidential

slide28

16 of those 30 years are with Oracle and Oracle Applications

© 2006 Oracle Corporation – Proprietary and Confidential

slide29

Oracle isn’t the only team that I’m responsible for

© 2006 Oracle Corporation – Proprietary and Confidential

agenda
Agenda

<Insert Picture Here>

  • Report Manager Overview
    • Repository Management
    • Submission Flows
    • User to Value Security
    • FSG Template Editor
    • Profile Options
  • Demonstration
  • Questions and Answers

© 2006 Oracle Corporation – Proprietary and Confidential

report manager overview repository management
Report Manager OverviewRepository Management
  • Capabilities
    • View Reports
    • Create SSWA Menus
    • Update Publishing Options
    • Move Folders/Reports
    • Add Folders
    • Archive/Delete Reports/Folders

© 2006 Oracle Corporation – Proprietary and Confidential

report manager overview fsg submission
Report ManagerOverviewFSG Submission
  • Capabilities
    • Submit Defined FSG Reports and publish to Report Manager Repository
    • Can burst report through Content Set page expansion on a segment

© 2006 Oracle Corporation – Proprietary and Confidential

report manager overview ad hoc fsg submission
Report Manager OverviewAd Hoc FSG Submission
  • Capabilities
    • Submit Ad Hoc FSG Report by selecting existing FSG components and publishing into the Repository

© 2006 Oracle Corporation – Proprietary and Confidential

report manager overview standard report submission srs
Report Manager OverviewStandard Report Submission (SRS)
  • Capabilities
    • Submit SRS Reports (XML Output) and publish to Repository
    • Provides LOV for Report Parameters as defined in Applications

© 2006 Oracle Corporation – Proprietary and Confidential

report manager overview file upload
Report ManagerOverviewFile Upload
  • Capabilities
    • Upload 3rd Party Files into the Repository

© 2006 Oracle Corporation – Proprietary and Confidential

report manager overview report set request set publishing
Report Manager OverviewReport Set/Request Set Publishing
  • Capabilities
    • Publish previously submitted Report Set or Request Set into the Repository
    • Can save a template of publishing options to apply to a set whenever it is published

© 2006 Oracle Corporation – Proprietary and Confidential

report manager overview user to value security
Report Manager OverviewUser to Value Security
  • Capabilities
    • Security system unique to the Report Manager application
    • Controls what expanded values a user can view

© 2006 Oracle Corporation – Proprietary and Confidential

report manager overview fsg template editor
Report Manager OverviewFSG Template Editor
  • Capabilities
    • Create custom Templates for FSG Reports
    • A template is automatically generated generated based on the FSG Report Definition
    • Provides interface to provide layout and control fonts, colours, etc.

© 2006 Oracle Corporation – Proprietary and Confidential

report manager overview profile options
Report ManagerOverviewProfile Options

© 2006 Oracle Corporation – Proprietary and Confidential

slide40

<Insert Picture Here>

Report Manager

Demonstration

© 2006 Oracle Corporation – Proprietary and Confidential

for more information
For More Information
  • Report Manager About Document
    • Metalink Note 378338.1
  • Report Manager Users Guide

© 2006 Oracle Corporation – Proprietary and Confidential

slide42

<Insert Picture Here>

Questions & Answers

© 2006 Oracle Corporation – Proprietary and Confidential