deck overview audience: general audience not familiar with oracle product strategy time: 1.0 – 1.5...
TRANSCRIPT
Deck Overview
Audience:• General Audience not familiar with Oracle Product Strategy
Time: • 1.0 – 1.5 Hours
Presentation Goals:• The goal of this deck is to explain at a high level Oracle’s BI
Strategy and Products. The slides within this deck provide the presenter with standard slides across BI Suite, BI Applications and Enterprise Performance Management.
Last Updated 5/23/2007
<Insert Picture Here>
Oracle BI Strategy and ProductsPresenter
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.
Business Intelligence is the #1 Priority
“…the most important technology in 2007 is business intelligence”
Source: CIO Insight, “The Future of I.T.: What's on Tap for 2007 and Beyond,” January 16, 2007
To:From:
Product Strategy Drivers
Pervasive useAnalysts
Real-time, predictive dataHistorical data
Unified infrastructure and prebuilt analytic solutions
Analytic tools
Insight-driven business process optimization
Reporting results
Unified, enterprise viewFragmented view
Enterprise Performance Management System
Planning silos with limited BI
Oracle’s Product Strategy
• Integrated Business Intelligence Database• Business Intelligence & Data Mining Functions Integrated in
Database
• Integrated Business Intelligence Tools• Best-of-Breed, Next Generation Business Intelligence
Technology Platform
• Integrated Analytic Applications• Enterprise Wide, Industry Specific Analytic and Corporate
Performance Management Applications
Exploits Any Information Technology Environment
The Industry’s Most Comprehensive BI Solution
Oracle OLAPOracle Data MiningOracle PartitioningOWB/ODI
ORACLE DATABASE with DATA WAREHOUSING OPTIONSORACLE DATABASE with DATA WAREHOUSING OPTIONS
ORACLE BUSINESS INTELLIGENCE SUITEORACLE BUSINESS INTELLIGENCE SUITE
Oracle BI Suite Standard EditionOracle BI Suite Enterprise Edition
BI ApplicationsMulti-source
ORACLE BUSINESS INTELLIGENCE APPLICATIONSORACLE BUSINESS INTELLIGENCE APPLICATIONS
BI Applications For DBI
Performance Management
BI Applications for EPM
Oracle BI Suite SE1
BI SE and BI EE Interop and MigrationPaths for BI SE (Discoverer) Customers
1. Stay on BI SE forever• 10.1.2.2 just delivered (Calculated Members)• 10.1.2.3 and 11g in progress• Dedicated development team• Lifetime support
2. Use both to gain new function• Leverage Disco EULs as a data source• Discoverer analysis surfaced in Dashboards• Use Delivers for alerting
3. Migrate SE to EE• Metadata migration utility, methodology, and Oracle
Consulting services
Oracle BI Suite Enterprise EditionUnified Business Intelligence Infrastructure
Ad-hoc Analysis
ProactiveDetectionand Alerts
MS OfficePlug-in
Reporting & Publishing
Interactive Dashboards
DisconnectedAnalytics
OLTP & ODSSystems
Data WarehouseData Mart
SAP, OraclePeopleSoft, Siebel,
Custom Apps
FilesExcelXML
BusinessProcess
WebServices
OracleBI Server
Multidimensional Calculation and Integration Engine
Intelligent Caching Services
Intelligent Request Generation and Optimized Data Access Services
Common Enterprise Information Model
Common Enterprise Information ModelEnables Consistency, Security, Reuse, Flexibility
Presentation Layer
Physical Layer
Semantic Object Layer
• User roles, preferences• Simplified view• Logical SQL interface
• Dimensions• Hierarchies• Measures• Calculations• Aggregation Rules• Time Series
• Map Physical Data• Connections• Schema
Role-based views of the information
Consistent definition of business measures, metrics, calculations
Model once, deploy anywhere
Across any data sources
Ad Hoc Analysis
Formatted Reports
Common Enterprise Information Model“Model once, deploy everywhere”
Information consistency Information availabilityEliminates data silos Increased user adoptionGreater Leverage in IT
Oracle BI EE Server
Common Enterprise Information Model
Proactive Alerts
Interactive Dashboards
Disconnected Analytics
Microsoft Office
Business Processes
Oracle BI ServerNext-Generation BI Server
• Common Enterprise Information Model
• Advanced calculation & federation engine
• Intelligent request generation and optimized, distributed data access
• Analytical and Operational reach
• Mission critical scalability and performance
Oracle BI EE End User Products
Other 3rd Party Tools
Native RDBMS• Oracle• SQL Server• DB2• TeradataODBC
Multi-dimensional• XMLA• Oracle OLAP Option• MS Analysis Services• SAP BW
Other• XML,• Excel• Text
End User ProductsEnterprise Edition
Oracle Delivers
• Guided experience leads user from insight to action
• Intuitive and interactive dashboards/scorecards• Personalized, function-specific and role-based
Oracle InteractiveDashboards
Oracle Answers
• Powerful ad-hoc analysis via 100% Web UI• Zero training environment• Create, modify and author analysis, pivots and
dashboards
• Dynamic problem/opportunity detection and notification
• Automated analytic workflows and processes• Tailored delivery for wide range of mobile
devices
Oracle BI Publisher
• Uses Word and Adobe as report layout tools• Many sophisticated outputs• Extract once, Publish many times
Enhances Existing Customer Investments“Hot-Pluggable” Integration with Heterogeneous Systems
SecuritySecurity Data AccessData Access ETLETL
OracleKerberosiPlanetMSFT ADNovellCustom Others ..
Oracle RDBMSOracle OLAP OptionMicrosoft SQL Server
& Analysis ServicesIBM DB2TeradataEssbaseSAP BWXML, Excel, TextOthers ..
Oracle Data Integrator (Sunopsis)
Oracle Warehouse Builder
InformaticaAscentialOthers ..
Any JSR 168 Portal
Oracle BI, HYSL, BOBJ, COGN, MSTR, Actuate ..
Oracle EBS, Siebel, SAP, PeopleSoft, JD Edwards ..
Excel, Outlook,Lotus Notes ..
PortalsPortals Analytic ToolsAnalytic Toolsand Reportingand Reporting
ApplicationsApplications Desktop ToolsDesktop Tools
Oracle BI Server
Common Enterprise Information Model
Oracle BI ApplicationsSingle or Multi-source Analytic Apps Built on OBIEE
Oracle BI Suite EE
Ad-hoc Analysis
ProactiveDetectionand Alerts
MS OfficePlug-in
Reporting & Publishing
Interactive Dashboards
DisconnectedAnalytics
WebServices
SalesService &Contact Center
Marketing
Order Management& Fulfillment
Supply Chain
FinancialsHuman
Resources
PackagedETL Maps
UniversalAdapters
IVR, ACD, CTIHyperionMS Excel
Other Data SourcesDW Schema
Oracle BI Applications
Oracle BI ApplicationsMulti-Source Analytics with Single Architecture
Travel& TransTravel
& TransAutoAuto Comms& MediaComms& Media
ComplexMfg
ComplexMfg
ConsumerSector
ConsumerSector EnergyEnergy Financial
ServicesFinancialServices
HighTechHighTech
Insurance& Health
Insurance& Health
LifeSciences
LifeSciences
Public SectorPublic Sector
Other Operational & Analytic Sources
Oracle BI Suite Enterprise Edition
Prebuilt adapters:
SalesService &Contact Center
MarketingOrder
Management& Fulfillment
Supply Chain
FinancialsHuman
Resources
PipelineAnalysis
TriangulatedForecasting
Sales Team Effectiveness
Up-sell / Cross-sell
Cycle TimeAnalysis
Lead Conversion
Employee Productivity
Compensation Analysis
HR Compliance Reporting
WorkforceProfile
TurnoverTrends
Return on Human Capital
A/R & A/PAnalysis
GL / BalanceSheet Analysis
Customer & ProductProfitability
P&L Analysis
ExpenseManagement
Cash FlowAnalysis
Supplier Performance
Spend Analysis
Procurement Cycle Times
Inventory Availability
EmployeeExpenses
BOM Analysis
OrderLinearity
Ordersvs. Available
Inventory
Cycle TimeAnalysis
BacklogAnalysis
FulfillmentStatus
CustomerReceivables
Campaign Scorecard
Response Rates
Product Propensity
Loyalty andAttrition
Market Basket Analysis
Campaign ROI
Churn Propensity
Customer Satisfaction
ResolutionRates
Service RepEffectiveness
Service CostAnalysis
ServiceTrends
How do I reduce agent turnover and staffing costs?
What is the impact of my average handle time, average queue hold time and one-and-done rate on customer satisfaction?
Ser
vice
S
ervi
ce
Customers
Sal
esS
ales
Mar
keti
ng
Mar
keti
ng
Dis
trib
uti
on
Dis
trib
uti
on
Fin
ance
Fin
ance
HR
/ W
ork
forc
eH
R /
Wo
rkfo
rce
Op
erat
ion
sO
per
atio
ns
Pro
cure
men
tP
rocu
rem
ent
Customers
Customers
Suppliers
Suppliers
Suppliers
Advanced Analysis Often Spans Heterogeneous Data Sources
How does call center agent tenure, training, & compensation affect efficiency and cross-selling performance?
Oracle BI ApplicationsMulti-Source Analytics with Single Architecture
Travel& TransTravel
& TransAutoAuto Comms& MediaComms& Media
ComplexMfg
ComplexMfg
ConsumerSector
ConsumerSector EnergyEnergy Financial
ServicesFinancialServices
HighTechHighTech
Insurance& Health
Insurance& Health
LifeSciences
LifeSciences
Public SectorPublic Sector
Other Operational & Analytic Sources
Oracle BI Suite Enterprise Edition
Prebuilt adapters:
Sales MarketingOrder
Management& Fulfillment
Supply Chain
FinancialsHuman
Resources
PipelineAnalysis
TriangulatedForecasting
Sales Team Effectiveness
Up-sell / Cross-sell
Cycle TimeAnalysis
Lead Conversion
Employee Productivity
Compensation Analysis
HR Compliance Reporting
WorkforceProfile
TurnoverTrends
Return on Human Capital
A/R & A/PAnalysis
GL / BalanceSheet Analysis
Customer & ProductProfitability
P&L Analysis
ExpenseManagement
Cash FlowAnalysis
Supplier Performance
Spend Analysis
Procurement Cycle Times
Inventory Availability
EmployeeExpenses
BOM Analysis
OrderLinearity
Ordersvs. Available
Inventory
Cycle TimeAnalysis
BacklogAnalysis
FulfillmentStatus
CustomerReceivables
Campaign Scorecard
Response Rates
Product Propensity
Loyalty andAttrition
Market Basket Analysis
Campaign ROI
Service &Contact Center
Churn Propensity
Customer Satisfaction
ResolutionRates
Service RepEffectiveness
Service CostAnalysis
ServiceTrends
Prebuilt ETL to extract data from over 3,000 operational tables and load it into the DW, sourced from CRM systems, call center telephony middleware and other sources
1
Service Analytics utilizes ETL routines that extract data from 2,000+ operational tables and load it into 15 star-schemas available for immediate analysis
2
Pre-mapped metadata, defining real-time access to analytical and operational sources, embedded best practice calculations and metrics for the contact center
3
A “best practice” library of over 150 prebuilt role-based intelligence dashboards, reports and alerts for service and contact center agents, managers and executives
4
Business AnalyticsWarehouse
Presentation Layer Logical Business
Model Physical Sources
Service and Contact Center Analytics
Example: Analytic Workflows
Business Objectives /
Issues
GainInsights
Take ActionTarget collection efforts to reduce overdue balances
Drill toOverdue Invoice Detail
Who are the Customersand Collectors?
How long is the underlying Overdue
Balance pending?
Is Overdue Balancestrending up?
Is DSO on target?
Maximize Cash Flow
Drill toDue Balances by Region
What is the aging ofDue Balances?
Are Payment Termsin compliance?
Is DPO on target?
• Business Function: Receivables
• Role: Director, Credits & Collections
• Objectives:• 1) Maximize Cash Flow• 2) Control Risk of
Receivables Portfolio
Example: Analytic WorkflowsBusiness
Objectives / Issues
GainInsights
Take ActionTarget collection efforts to reduce overdue balances
Drill toOverdue Invoice Detail
Who are the Customers?
How long is the underlying Overdue
Balance pending?
Is Overdue Balancestrending up?
Is DSO on target?
Maximize Cash Flow
Drill to D
etail
Build from Scratchwith Traditional BI Tools Oracle Analytic Applications
Prebuilt Business Adapters for Oracle, PeopleSoft, Siebel, SAP, others
Prebuilt DW design, adapts to your EDW
Role-based dashboards and thousands of pre-defined metrics
Easy to use, easy to adapt
Weeks or Months
Back-end ETL andMapping
DW Design
Define Metrics& Dashboards
Back-end ETL andMapping
DW Design
Define Metrics& Dashboards
Training / Roll-out
Training / Rollout
Months or Years
Oracle Analytic Applicationssolutions approach:
• Faster time to value• Lower TCO• Assured business value
Source: Patricia Seybold Research, Gartner, Merrill Lynch, Oracle Analysis
Speeds Time To Value and Lowers TCO
Enterprise Performance Management SystemIntegrates Transaction, Intelligence, Financial Systems
Enterprise Resource Planning Systems
Operational Business
Intelligence Systems
Enterprise Performance Management
System
Financial Performance Management
Systems
Oracle BI Product StrategyKey Product Differentiators
• Enterprise Semantic Model• Cross-Source Model Centric vs. Single Source Reporting
• Pervasive Business Insight• Empower Business Users with Embedded Insight
• Real Time Predictive Insight • Activity Monitoring and Predictive Analytics
• Business Process Optimization • Sense & Respond with Intelligent Business Processes
• Fastest Time to Value & Lowest TCO• Pre-packaged Performance Management & Analytic Applications• Across Siebel, Peoplesoft, e-Business Suite, JDEdwards, & SAP
<Insert Picture Here>
Oracle and Hyperion
Enterprise Performance Management SystemOracle with Hyperion
InsightPerformance
Action
SetGoals
Plan
Monitor
Analyze
Report
Align
The New, Extended Oracle BIA System for Enterprise Performance Management
BI Tools and Foundation
BI and Performance Management Applications
Oracle Business Intelligence
Best-of-breed Business Intelligence Tools
Integrated BI Foundation Enterprise Semantic Model
Operational Business Intelligence Applications
Performance Management Applications Integrated with each other
Works with any information technology environment – Oracle, non-Oracle, or mixed
Hot-Pluggable
Oracle Business Intelligence Tools & FoundationExtended and Unified Business Intelligence Infrastructure
Ad-hoc Analysis
Interactive Dashboards
ProactiveDetectionand Alerts
MS Office& OutlookIntegration
Reporting & Publishing
Disconnected& MobileAnalytics
OLTP & ODSSystems
Data WarehouseData Mart
SAP, OraclePeopleSoft, Siebel,
Custom Apps
FilesExcelXML
BusinessProcess
Multidimensional Calculation and Integration Engine
Integrated Security, User Management, Personalization
Intelligent Request Generation and Optimized Data Access Services
Essbase
Common Enterprise Information Model
Essbase Analytics
Data Integration
Oracle Business Intelligence ApplicationsAn Enterprise Performance Management System
Oracle Business Intelligence Foundation
OLTP & ODSSystems
Data WarehouseData Mart
SAP, OraclePeopleSoft, Siebel,
Custom Apps
FilesExcelXML
BusinessProcess
Essbase
Common Enterprise Information Model
Reporting
Sales &Marketing
Modeling Planning BudgetingFinancial
ManagementConsolidation Scorecards
Verticals
PlanningAnalytic Apps
HumanResources
Order Management& Fulfillment
SupplyChain
FinancialAnalytics
Scorecarding