Transcript Reliance Presentation template

Heterogeneous Data Sources and Their Integration
Leveraging Oracle BI Apps / OBIEE
Vinay Dhingra
BI Practice Manager, Apps Associates
Date: 24-09-2011
Confidential
Slide 1
Agenda
 Introduction
 Challenges faced in Successful Implementation of BI
 BI Products Levels of Maturity
 Oracle BI Application Architecture
 Our Company: Apps Associates
 Q&A
Confidential
Slide 2
Introduction
Vinay Dhingra
BI Practice Manager, Apps Associates
 12+ years of experience as BI Architect, Tech lead, PM, etc.
 Practice Manager with Apps Associates managing 50+ consultants
 Lead Consultant/Architect in Core Engineering group at Oracle for
Financial and HR Analytics
 Consultant in US with KPI Partners and started the BI GDC for them
 Holds Bachelor degree in Mechanical Engineering
 Vinay has participated in over 20 Business Intelligence implementation
/ upgrades
 Lead the first Oracle BI Financial Analytics implementation in 2008
Confidential
Slide 3
Today’s Discussion
Heterogeneous Data Sources and Their Integration Leveraging
Oracle BI Apps / OBIEE
What is BI ?
What is involved
in BI ?
Key challenges
faced by
organization in
Implementation
Confidential
 Business Intelligence (BI) is a broad category of applications and
technologies for gathering, storing, analyzing and providing access to
data to help enterprise users make better business decisions.
 BI Applications includes the activities of decision support system, query
and reporting, online analytical processing (OLAP), statistical analysis,
forecasting and data mining.
 Build Robust Data Warehouse Architecture
 Integration of Heterogeneous Data Source System
 Performance
 Scalability
Slide 4
Heterogeneous Data Sources
Multiple
Applications
Multiple
Databases/Files
Multiple Domains
Data Flow across
Multiple
Applications
Confidential
 Transactional data stored in multiple applications such as
Oracle EBS, PeopleSoft, Siebel, JD Edwards, SAP or home
grown custom applications…..
 Data is stored in multiple databases such as Oracle, SQL
Server, DB2, Teradata, MySQL, Access, Excel ....
 Financials, HRMS, Order, Management, Procurement, Planning,
Manufacturing, Inventory Control, CRM…etc.
 Flow of data across multiple applications
Slide 5
BI Solutions – Level of Maturity
3
Business Value
Level 3 : Plug and play
technology
More efficient & faster
Ex: Oracle BI Apps/OBIEE
2
Level 2 : Automated tools
created domain based
intelligent reporting sets ex.
Purchasing Intelligence
Ex: Daily Business
Intelligence
1
Level 1 : Limited technology to
extract relevant data
Time consuming & lot of
manual effort required
Ex: Discoverer/Oracle DWH
Level of Sophistication
Confidential
Slide 6
1st Level of Maturity: Ex. Oracle Discoverer
1
Discoverer
Adhoc
Reporting
Challenges:
• Oracle DB only
EBS OLTP Data
• Challenging to configure
• Difficult to use
Confidential
Source: Oracle
Slide 7
2nd Level of Maturity: Ex. Oracle DBI
2
EBS Apps
DBI
• Utilizes EBS Instance
• Created via Concurrent
job extracts
• Drill to Transactional
data
MVs
Challenges:
• Contention with OLTP
users (limited scalability)
• Limited configurability
EBS OLTP Data
Confidential
Source: Oracle
• No Adhoc capability
Slide 8
3rd
Level of Maturity: Ex. Oracle BI Apps
3
EBS Apps
DBI
Oracle buys Siebel, introduces new set ofDiscoverer
BI
Tools – Oracle Business Intelligence Suite
Enterprise Edition
MVs
EBS OLTP Data
Confidential
Source: Oracle
Slide
Oracle BI Applications - Detailed
Single- and multi-source Analytic Apps Built on BI Suite EE
Sales
Service &
Contact
Center
Order
Management
& Fulfillment
Marketing
Supply
Chain
Financials
Human
Resources
Oracle BI Applications
Interactive
Dashboards
Reporting &
Publishing
Ad-hoc
Analysis
Proactive
Detection
and Alerts
Disconnected
Analytics
MS Office
Plug-in
Web
Services
Oracle BI Suite EE
BAW Schema
Packaged
ETL Maps
Confidential
Source: Oracle
Universal
Adapters
IVR, ACD, CTI
Hyperion
MS Excel
Other Data Sources
Slide 10
Oracle BI Apps Core Proposition –Fin. Analytics
Confidential
Slide 11
Heterogeneous Data Extraction and Loading
Business Analytics
Warehouse
Load
Source Independent Load
Staging Tables
Source Dependent Extract
 Is source-specific and supports
universal business adaptors
 Is extensible
Confidential
SQL
ABAP
Oracle
App Layer
 Is lightweight and designed for
performance and parallelism
SQL
Siebel
OLTP
 Converts source-specific data to
universal staging table format
Power
Connect
App Layer
SQL
Power
Connect
SQL
 Exposes simplified business
entities from complex source
systems
PeopleSoft
Extract
Other
SAP
Slide 12
Heterogeneous Data Extraction and Loading
 Encapsulates warehouse load
Business Analytics
Warehouse
logic
 Handles:
– Slowly changing dimensions
Load
Source Independent Load
– Key lookup resolution / surrogate
key generation
– Insert/update strategies
Staging Tables
– Currency conversion
– Data consolidation
 Uses bulk loaders on all database
platforms
Source Dependent Extract
SQL
ABAP
App Layer
Oracle
SQL
SQL
Siebel
OLTP
PeopleSoft
Confidential
Power
Connect
App Layer
SQL
Power
Connect
Extract
Other
SAP
Slide 13
Oracle Data Warehouse Administration Console
Confidential
Slide 14
About Apps Associates
 In operation since 2002 with consistent yearover-year growth, privately held
−
2011 Inc 500/5000 list of fastest growing U.S.
companies
 Offices in USA – MA (HQ), New York, Atlanta,
Germany and India
−
Over 400 employees with strong local
presence
 Core Specializations: E-Business Suite, Oracle
Business Intelligence, Microsoft Applications,
Hyperion, Integration & Fusion Middleware,
Infrastructure Services
 Founded by former Oracle Consulting Service
employees
Confidential
Slide 15
Service Offering (All)
E-Business Suite Consulting
Fusion Middleware
 Release 12 Upgrades and
Implementation
 SOA, Process Management
 EBS Managed Services
 Remote DBA Service
Business Intelligence/EPM*
 OBI-EE, BI Applications
 Web Services
E-Business Suite Integrated Product**
 ShipConsole
**Product is Oracle Validated
 Hyperion
Technical Services
 Oracle Data Integrator (ODI)
 Remote DBA Services
 BI Publisher
 Microsoft Development & Support
*BI Pillar Partner
Contact Information:
Pavan Kanugo:(M) +91 770 265 5583
Practice Director
[email protected]
www.AppsAssociates.com
Locations:
Boston I New York I Germany I India
Confidential
Slide 16
BI Engagement Type Experience
Confidential
Slide 17
BI Solution Footprint Experience
Confidential
Slide 18
Questions?