a single version of the truth diebold shares its global vision for bi
TRANSCRIPT
Tina Suttle, Manager, Business Intelligence, Diebold, Incorporated Brad Reinders, Principal, Business Information Management, Capgemini Oracle Open World Tuesday, October 4, 2011
Business Intelligence at Diebold, Incorporated
| Sector, Alliance, Offering
Diebold, Incorporated
§ Global leader in providing • Integrated self-service delivery • Security systems and services.
§ $2.7 Billion company § More than 16,000 associates with representation in nearly 90 countries
worldwide § Headquartered in Canton, Ohio, USA. § Been in business for more than 150 years § My role: Manager, Business Intelligence
3
| Sector, Alliance, Offering
History of BI at Diebold
§ Diebold Brazil only true BI deployment until 2007 § Reports, reports, reports – worldwide § Established a BI focus in 2006 § Developed a global information strategy and vision § Along with two highly experienced BI and Technical analysts:
• Deployed limited BI infrastructure • Built BI development methodology • Developed ETL framework
§ Began BI development in 2007 § Current BI Team
• 10 in U.S. • 4 in India • Consultants & Contractors as needed
4
| Sector, Alliance, Offering
BI Vision / Evolution 2006 - 2010
Insert "Title, Author, Date"
5 © 2011 Capgemini. All rights reserved.
5 “Awareness” “Insight” “Action” “Automation”
Reporting
2006
ü Global eBiz Rptg ü Global Decision Support Team ü Global BI Team ü BI Dev Methodology ü BI Tool Evaluation ü Global Data Architecture ü Discoverer
BI / DW Foundation
ü Global BI Data Arch & Infrastructure ü Initial Data Marts ü OBI Framework evaluation & acquisition ü OBI EE Infra ü Initial Data Marts:
• HR DM • Safety DM • Service Perf
2007
Global BI Data Marts
2008
ü Add’l Data Mart dev • Spend Analytics • Rev / Cost • Sales / Mktg • Add’l Service
ü OBI EE Dashboards ü Assess / Acquire OBI Prebuilt Apps (2009/2010) ü Oracle Rollouts – Reporting Package ü BI / Reporting Dashboards
BI, Executive Dashboards
2009 ü Additional Data Mart Deployment
• Sales • Add’l Service
ü Additional BI / Reporting Delivery Dashboards ü Separate Reporting Instance ü Scorecard development ü Business Activity Monitoring (BAM) ü Data Mining Functionality
BI / Business Alignment
2010-Beyond
ü Business driven BI ü BI driven business ü BI à Customers ü Additional Data Mart Deployment
• Supply Chain • Add’l Service
ü Additional BI / Reporting & Dashboards ü BI Applications Deployment
• GL • Sales
“BI Excellence”
Prebuilt Analytics
| Sector, Alliance, Offering
Oracle BI Applications Acquisition
§ Why acquire Oracle BI Applications? • Needed to deploy faster; provide more content • Prebuilt data mappings from Oracle eBusiness Suite • Universal adaptors for non-eBiz sources • Upgrades to E-Business Suite supported in pre-built model. • Role and function based interactive dashboards based on best practices and
analytic workflows. • Consistency in look &functionality of analytics applications
§ Applications acquired: • Financials • Procurement and Spend Analytics • Supply Chain • Sales
6
| Sector, Alliance, Offering
Business Intelligence Data Flow
Insert "Title, Author, Date"
7 © 2011 Capgemini. All rights reserved.
Staging Area
Data Source 2
Data Warehouse
Data Source 3
Data Source 4
Dashboards
Data Source 1
| Sector, Alliance, Offering
Prebuilt Analytics – What we bought--
Insert "Title, Author, Date"
8 © 2011 Capgemini. All rights reserved.
Staging Area
Data Warehouse
Dashboards
Oracle R12
Baan
CARMS
Oracle 11.5.10
| Sector, Alliance, Offering
Prebuilt Analytics – What we bought--
Insert "Title, Author, Date"
9 © 2011 Capgemini. All rights reserved.
Staging Area
Data Warehouse
Dashboards
Oracle R12
Baan
CARMS
Oracle 11.5.10
Oracle BI / Analytic Applications Purchased: Financials (AR, AP, GL) Sales (customized adaptors for Oracle EBS source) Supply Chain Procurement / Spend
Adaptors – prebuilt mappings to Oracle ERP sources
| Sector, Alliance, Offering
10 © 2011 Capgemini. All rights reserved.
Napolean’s Victory at Battle of Austerlitz
What
¤ Austria and Russia form Third Coalition against French Empire
¤ Date was chosen for battle - December 2, 1805
What Happened
¤ Russia did not show
Then What
¤ Austrian forces lost the battle:
¤ 20,000 fled
¤ 10,000 killed
¤ 40,000 captured
Why did it Happen
¤ Gregorian (Austria) versus Julian (Russia) calendars
The Point
¤ Early example of data quality issue.
| Sector, Alliance, Offering
Prebuilt Analytics – Non-Supported Source Systems
Insert "Title, Author, Date"
11 © 2011 Capgemini. All rights reserved.
ETL
OBIEE
EBS
Sales Analytics
Oracle BI Apps
Data Warehouse
Universal Adapters
| Sector, Alliance, Offering
Prebuilt Analytics – Non-Supported Source Systems
Insert "Title, Author, Date"
12 © 2011 Capgemini. All rights reserved.
ETL
OBIEE
EBS
Sales Analytics
Oracle BI Apps
Data Warehouse
Customized Siebel Adapters
| Sector, Alliance, Offering
Prebuilt Analytics – Joining Custom Data Warehouse
Insert "Title, Author, Date"
13 © 2011 Capgemini. All rights reserved.
ETL
OBIEE
Source
ETL
OBIEE
Source
Custom
Oracle BI Apps
Data Warehouse
Data Warehouse
| Sector, Alliance, Offering
Data Warehouse
Prebuilt Analytics – Joining Custom Data Warehouse
Insert "Title, Author, Date"
14 © 2011 Capgemini. All rights reserved.
ETL
OBIEE
Source
Could rebuild it
ETL
OBIEE
Source
Custom
Oracle BI Apps
Data Warehouse
| Sector, Alliance, Offering
Prebuilt Analytics – Joining Custom Data Warehouse
Insert "Title, Author, Date"
15 © 2011 Capgemini. All rights reserved.
ETL
OBIEE
Source
Combing Using OBIEE – Single metadata (rpd)
ETL
OBIEE
Source
Custom
Oracle BI Apps
Data Warehouse
Data Warehouse
| Sector, Alliance, Offering
Prebuilt Analytics – Joining Custom Data Warehouse
Insert "Title, Author, Date"
16 © 2011 Capgemini. All rights reserved.
ETL
OBIEE
Source
Combing Using OBIEE – Better performance in same database instance
ETL
Data Warehouse
OBIEE
Source
Custom
Oracle BI Apps
| Sector, Alliance, Offering
Prebuilt Analytics – Master Data
Insert "Title, Author, Date"
17 © 2011 Capgemini. All rights reserved.
ETL
OBIEE
Sources
Use Master Data from common source Delete or Duplicate Source System ID
ETL Sources
Custom
Oracle BI Apps
| Sector, Alliance, Offering
Prebuilt Analytics – Load Strategy for Global Users
Insert "Title, Author, Date"
18 © 2011 Capgemini. All rights reserved.
ETL
OBIEE
Source
Load while users are online Two risks: - Performance - Data
Oracle BI Apps
Data Warehouse
| Sector, Alliance, Offering
Prebuilt Analytics – Load Strategy for Global Users
Insert "Title, Author, Date"
19 © 2011 Capgemini. All rights reserved.
ETL
Instance 1
OBIEE
Source
Load while users are online Rotating Data Warehouse Instances - Mitigates Both Risks - Expensive
Oracle BI Apps
Instance 2
| Sector, Alliance, Offering
Prebuilt Analytics – Load Strategy for Global Users
Insert "Title, Author, Date"
20 © 2011 Capgemini. All rights reserved.
ETL Data
Warehouse
OBIEE
Source
Dedicated RAC Nodes – one for ETL and one for OBIEE Solves Performance Risk Does not solve Data Risk
Oracle BI Apps
Node 1 Node 2
| Sector, Alliance, Offering
Oracle BI Applications Multilingual
1. Application Metadata • Buttons, menus
2. Web Catalog Metadata • Report names, dashboard names
3. Repository Metadata • Columns names, descriptions
4. Multilingual Data • Your data
21
| Sector, Alliance, Offering
Oracle BI Applications Localization
1. Application Metadata • Out of box support – can add or change • Browser Language Setting or Session Variable
2. Web Catalog Metadata • Manual translation • Placed in OBIEE directory
3. Repository Metadata • Manual translation • Placed in table
4. Multilingual Data • Dimension data – multiple columns or translation table • Fact data – as it comes in
23
| Sector, Alliance, Offering
Tips
§ Dedicated resources • BI DBA and Infrastructure • Can move to shared services for support
§ Phased approach § Business involvement/ownership
• Diebold business owns reports and dashboards • Dedicated power user/plus backup • High user adoption • IT owns infrastructure and framework • Organized, trained, prepared
24
| Sector, Alliance, Offering
Implementation Partner Selected
§ Premier Oracle Partner, brought into Diebold by Oracle: BI Consulting Group – now Capgemini
§ Successful relationship since 2007 • Training • OBIEE deployment and tuning • Data modeling / architecture assistance
§ Engaged BICG/Capgemini in 2010 & 2011 for deployment of: • Sales • GL • Oversight of Supply Chain, AR, AP, and Procurement/Spend Analytics
25
| Sector, Alliance, Offering
“Prebuilt” Approach
§ Methodology for Oracle Business Intelligence (MOBI) § Oracle BI Applications are first installed “out of the box” § Conference Room Pilot conducted to provide “hands on” review of BI
Apps for the business § Business Requirements defined § Roadmap developed for configuring and deploying BI Apps based on
business requirements § Project Management assistance § Training / Knowledge Transfer
26
| Sector, Alliance, Offering
The Diebold Data Warehouse now
§ 7 Custom Data Marts § 2 prebuilt BI Applications modules § 5 other prebuilt BI Application modules in various stages of deployment,
along with expansion of installed data marts both custom and prebuilt § Most data marts have 25 – 200 users, one has 1200 and one has 4500
users § Front end à OBIEE § Ad hoc Analysis à Discoverer, OBIEE/Answers § Implemented Exadata in April 2011, improved performance immensely
27
| Sector, Alliance, Offering
OBIEE Run Times Before/After Exadata Implementation
Insert "Title, Author, Date"
28 © 2011 Capgemini. All rights reserved.
0
20
40
60
80
100
120
140
1/31/2011 2/28/2011
3/31/2011 4/30/2011
5/31/2011 6/30/2011
7/31/2011 8/31/2011
Average Seconds
Exadata installed April 26, 2011, Number of queries run up 23%
| Sector, Alliance, Offering
The future of BI at Diebold
§ Continue rollout of Oracle BI Applications • “Out of the box” Approach • Enable Power Business Analysts to develop dashboards
§ Transition custom BI to Oracle BI Applications, where appropriate § Investigating Mobile BI using OBIEE § Drive cultural change
• Reports, reports, reports à BI, BI, BI • Self service BI • Near real time – only when necessary
§ Strengthen partnership with the business: Business driven BI; BI driven Business
29
| Sector, Alliance, Offering Insert "Title, Author, Date"
30 © 2011 Capgemini. All rights reserved.
Thank you for attending. § Visit the Capgemini Business Information
Management booth #313
§ You could win an Apple i-Pad.
§ Visit the booth and register to WIN!!
| Sector, Alliance, Offering
Q & A
Insert "Title, Author, Date"
31 © 2011 Capgemini. All rights reserved.