oracle bi applications and bi mobile application designer

Copyright © 2014 Oracle and/or its affiliates. All rights reserved. |

Oracle BI Applications and BI Mobile Application Designer

Cesar Ortiz Leitender Systemberater Oracle 21 October 2014

Oracle Confidential – Internal/Restricted/Highly Restricted


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 decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

Oracle Confidential – Internal/Restricted/Highly Restricted 3


Program Agenda

Overview of BI Applications

Oracle BI Mobile

Live

1

2

3

Oracle Confidential – Internal/Restricted/Highly Restricted 4


In The

Cloud

On-

Premise

Oracle Business Analytics Strategy

Any

Data

Packaged Analytic

Applications

Engineered

Systems

Overview

Full Suite of

Analytic

Tools

5 Oracle OpenWorld

2014


BI Applications drive success with Oracle’s Applications

Oracle OpenWorld 2014

80+ Topic specific applications

8000+ Business Metrics

4000+ Customers

$M’s Saved via operational insights & in technical costs

6


Oracle BI Applications Product Family

CRM ANALYTICS

ORACLE BUSINESS INTELLIGENCE FOUNDATION AND OTHER OPERATIONAL AND ANALYTIC SOURCES

SOURCE ADAPTERS:

SALES

• Pipeline Analysis

• Forecast Accuracy

• Up-sell/Cross-sell

• Cycle Times

• Lead Conversion

• Sales Team Effectiveness

MARKETING

• Campaign Effectiveness

• Customer Insight

• Product Propensity

• Market Basket Analysis

• Campaign ROI

SERVICE &

CONTACT CENTER

• Service Effectiveness

• Customer Satisfaction

• Resolution Rates

• Service Rep Efficiency

• Service Cost

• Service Trends

PRICE

• Price Segments

• Price Waterfall Analysis

• Deal Life Cycle

• Deal Desk Analysis

• Product Pricing Performance

LOYALTY

• Member Demographics

• Membership Trends

• Promotion Cost

• Promotion Effectiveness

• Points Analysis

ERP ANALYTICS

FINANCIALS

• General Ledger

• Accounts Receivable

• Accounts Payable

• Fixed Assets

• Profitability

• Expense Management

PROCUREMENT &

SPEND

• Direct & Indir Spend

• Sourcing

• Buyer Productivity

• Contract Compliance

• Supplier Perf.

• Purch. Cycle Time

• Employee Expense

SUPPLY CHAIN &

ORDER MGMT

• Revenue & Backlog

• Inventory Analysis

• Fulfillment Status

• Customer Status

• Order Cycle Time

• BOM Analysis

PROJECTS

• Project Funding and Budget

• Product Cost

• Project Revenue

• Project Billing

• Project Profitability

• Resource Mgmt

HUMAN

RESOURCES

• Empl. Productivity

• Compensation

• Talent Management

• Recruiting Analysis

• Learning Analysis

• Workforce Profile

• Time & Labor

MANUFACTURING

• Plan to Produce

• Work Orders

• Inventory and WIP

• Quality, Resource Usage

• Bill of Material

• Costing

• Kanban

ENTERPRISE ASSET

MANAGEMENT

• Maintenance History

• Maintenance Costing

• Asset Genealogy

• Breakdown & Preventive

• Quality

• Inventory

STUDENT

INFORMATION

• Admissions and Recruiting

• Student Records

• Student Financials

http://www.siebel.com/

http://www.peoplesoft.com/corp/en/public_index.jsp


Pre-Built Analytic Warehouse 1. 2.

Best Practice Metrics 3.

Certified Application Integration

Oracle BI Apps: Deeper than Dashboards

• Business Analytics Warehouse

• Over 300 star schemas

• Designed for analysis and reporting

• Pre-mapped integration

• Fusion, EBS, PSFT, SEBL , JDE, IBM

• Role-based Security

• Over 10,000 metrics

• Additional pre-defined calculations

• Based on best practices

• Over 500 Dashboards and Pages

• Over 3,000 reports

• Across Lines of Business

Role-Based Dashboards 4.


Pre-Built Analytic Warehouse 1.

with over 25 star-schemas designed

for analysis and reporting on FA

2.

Role-Based Dashboards (60+) Best Practice Metrics (800+) 3. 4.

metadata, metrics, calculations for

financial analysts, executives, etc.

Pre-built ETL, extract data from PSFT, EBS, JD Edwards, Fusion and other sources

500+ reports, alerts for CFO, Finance

Controller, F. Analyst and AR/AP Managers

Certified Application Integration

Oracle BI Apps: Financial Analytics (FA) By Numbers


Financial Analytics Sample Analysis and Metrics

Sample Reports Sample Metrics

• Profitability Margins Trend

• Customer Profitability Statement

• Top 10 Revenue contributing Products

• AR Payments Overdue Aging Report

• AR Payments Due Aging Trend

• Invoice Transaction Efficiency

• DSO Quarterly Trend

• Current Assets Composition

• Top 10 Categories by Expense Variance

• Expense vs. Budget by Cost Center

• Total Cost Center Expenses Trend

• Gross Margin vs. Cash Margin

• Invoice Transaction Efficiency

• Top 10 Suppliers by # of invoices

• Top 10 Suppliers by Discount offered

• AP Holds by Type

• Gain or Loss on Retirements Trends

Receivables Payables

• DSO

• Credit Limit Used %

• AR Aging 1-30 Amt

• AR Overdue 1-30 Am

• AR Payment Days

• AR Weighted Days

• AR Avg Invoice Amt

• AR Credit Memo Amt

• Times Paid Before Due

• DPO

• Total AP Overdue Amt

• Overdue Amt to Total %

• AP Due 1-30 Amt

• AP Overdue 1-30 Amt

• AP Avg Invoice Amt

• AP Avg Payment Amt

• AP Payment Days

• AP Weighted Days

GL & Profitability Fixed Assets

• Product Gross Profit

• Customer Gross Margin

• Gross Margin %

• Operating Margin %

• EBT Margin %

• Net Income Margin %

• Return on Equity

• Return on Assets

• Return on Capital

• Gross Book Value

• Net Book Value

• Net Book Value Retired

• Accumulated Depreciation

• Depreciation Amount

• Depreciation Adjustment Amt

• Gain/Loss due to Retirement

• Transfer Amount

• Reclassification Amount


BI Applications 11.1.1.8.1

New Content Enhancements

Financials HR Projects Supply Chain & Order Mgmt Student Information Systems

New TCO and Certifications

Data Lineage Performance and Configuration

Enhancements

New Source Adapters

New Talent Profile Analytics

Procurement and Spend for JDE

Fusion Applications

(HR Analytics Module)

Oracle OpenWorld 2014 11

Data Integration

Oracle Data Integrator

Oracle GoldenGate


BI Apps 11.1.1.7.1 with Oracle Data Integrator and Golden Gate

Next Generation Data Integration

Oracle Data Integrator provides

• In-database E-LT Transformation vs. E-T-L

• Best in class performance, scalability, availability

• Lightweight deployment for lower TCO

• Faster time-to-value through declarative design

Oracle Golden Gate option for BI Apps

• Reduce load on source system by streaming data continuously into persistent store in the DW

• More reliable change data capture and delete support

• Enables near real time DW refresh


Applications CRM Financials Human

Resources

Supply Chain

& Order Mgmt Manufacturing

Enterprise

Asset Mgmt

Procuremen

t

& Spend

Projects Student

EBS R12.x Service & Price only

EBS 11.5.10 Service & Price only Discrete only

PSFT 9.2

PSFT 9.1

PSFT 9.0

PSFT 8.9 796x - Informatica 796x - Informatica 796x - Informatica 796x - Informatica

JDE E1 9.1

JDE E1 9.0

JDE E1 8.12 796x - Informatica 796x - Informatica

JDE E1 8.11SP1 796x - Informatica 796x - Informatica

JDE W A9.2 796x - Informatica

IBM Maximo 7.5 796x - Informatica

Fusion 11.1.1.8

Siebel 8.2.x

Siebel 8.1.x

Siebel 8.0 796x - Informatica

Siebel 7.8 796x - Informatica

Matrix shows operational applications supported by Oracle BI Applications ETL. To see which specific operational application modules are supported, and by which specific BI Apps, see product documentation

BI Applications OLTP Coverage for 11.1.1.8.1

Supported in BI Apps 11.1.1.8.1 - ODI

Supported in other BI Apps Version

Oracle OpenWorld

2014

1

3


Faster Time to Value and Lower TCO

14


Typical Effort & Customization balance

Extension of DW Schema for extension

columns, additional tables, external sources,

aggregates, indices, etc.

Extension of ETL for extension

columns, descriptive flexfields,

additional tables, external sources, etc.

Additional derived metrics, custom drill paths,

exposing extensions in physical, logical and

presentation layer, etc.

Additional dashboards and reports, guided and

conditional navigations, iBots, etc.

Level of

Effort Degree of

Customization

Easy

Moderate

Intermediate

Involved

Dashboards & Reports

OBIEE Metadata

DW Schema

ETL


Oracle’s Integrated Analytic Solution • Sales

• Marketing

• Service

• Contact Center

• Price

• Loyalty

•Financial Services

•Communications

•Healthcare

•Retail

• Financials

• HR

• Procure & Spend

• Projects

• Supply Chain

• Order Mgt

• Logistics

•Financial Close

•Strategic Planning

•Planning & Forecasting

•Profitability Management


Oracle BI Mobile – Complete Mobile Analytics

Extend Oracle BI automatically to mobile devices with no additional development

Build once, consume anywhere, anytime

Full power of Oracle BI on iOS and Android

Optimized for touch-gestures interactions

Offline support

Self-service capability allowing business users to create and distribute targeted mobile apps with zero-coding

Easy to Create

Delightful to Use

Available on Any Device

BI Mobile HD BI Mobile App Designer V2


Oracle Business Intelligence Mobile HD Benefits

• Build once, deploy anywhere

– Reports built in Oracle BI Foundation are immediately available for mobile and any other delivery channel

– Don’t need to develop specifically for mobile

• Oracle BI Mobile is integrated with Oracle BI Foundation Suite – Update a metric in the metadata layer and have it

– Immediately reflected across all reports

– Not a separate server, data store, security layer

– No data movement / no data latency


BI Mobile App Designer Self-service

EXTEND your BI investment with purpose built apps for

ANY LINE OF BUSINESS

Drag and drop design interface makes users SELF

SUFFICIENT

QUICKLY BUILD new apps with text, images, visual

graphs, and tables

NO CODE or installation required

For ANY MOBILE DEVICE


Drill from an Overview to Detail


Present data PowerPoint like with ability visualize and filter data

Combine BI Data with Textual Information


Purposefull built apps, e.g. to present Q3 results to management

Choose Apps from a Library


Exalytics: Performance Without Change to Existing Systems Powered by 12c DB In-Memory Option

• Database In-Memory On Exalytics

– In-Memory Caching with Oracle Business Intelligence

– Superfast Interactive exploration and visualization

• No change to existing systems of record – Least intrusive introduction to DB In-

memory Option

oracle bi applications and bi mobile application designer

Documents