better insights, better decisions and faster actions with ...€¦ · better insights, better...
TRANSCRIPT
John Morris, ON Semiconductor
Jamal Syed, National BI Practice Lead, Emerging Solutions
Manan Goel, Director, BI Product Marketing, Oracle
Better Insights, Better Decisions and Faster Actions with Oracle BI
Confidential Proprietary
ON Semiconductor & OBIEE BI Perspectives 2011
September 2011
Confidential Proprietary
• Headquarters: Phoenix, AZ
• Employees: ~21,000 globally
• Revenue: ~$3.6Bn(1)
• Market Capitalization: ~$3.8Bn(2)
• Ticker: ONNN
• Founded: Spun-off from Motorola 1999, IPO 2000
ON Semiconductor Today
(1) Based on Q2 2011 annualized revenues.
(2) Based on closing stock price on August 3, 2011
Confidential Proprietary
Leadership Position in Focus End-Markets
Analog ASIC #1
PC Core Power (DCDC) #1
Power Adapters (ACDC) #1
Protection #1
Op Amp #1
Linear VREG #1
Industrial ASIC #1
Hearing Aid SOC #1
Market Leader
Computing
LED Lighting Smart Grid
Wired & Wireless
Comm.
Industrial /
Medical /
Mil-Aero
Automotive Consumer
Confidential Proprietary
Successful Acquisitions Expand Solutions in Target Markets
2007 2006
October 10, 2008
May 15, 2006
Oregon Fabrication Facility
June 9, 2010 November 4, 2009
December 31, 2007
CPU Voltage and PC
Thermal
Monitoring Business
March 17, 2008
January 27, 2010 January 1, 2011
2008 2009 2010 2011
February 27, 2011
CMOS Image Sensor
Business Unit
Confidential Proprietary
OBIEE Projects @ ON Semi
• ERP standard & ad hoc reporting
– Project Scope: Transitioning from legacy Oracle Discoverer reporting environment to
Oracle Business Intelligence 11g platform for all our ERP reporting
– OBI module used: Built using BI Publisher
– Duration: 9 months
– Launched: March 2011
• Sales & Operations Planning dashboard
– Project Scope: Creating new analytic dashboards for revenue, demand, and supply
chain capacity planning
– OBI module used: Built using Answers and Dashboards
– Timeline: 4 months
– Launched: April 2011
Confidential Proprietary
Lessons & Learning
Lesson Learned How to address
Make sure you have strong business
involvement providing requirements
Well-defined, business-driven requirements before even thinking about the technical
details. Identify the go to person/people for resolving disputes or unclear requirements
Using the right part of the platform
for the need
Based on the needs, selecting the right part of the platform for each project. Created a “Tools-
Capability Matrix” to help with this
Prototype often More important for BI applications because so much may be assumed by people who aren’t
inclined to think about dashboards
Get your data in order Define the data sources and strategy for supporting the project. Will the reports pull from
multiple databases or will the data be staged in a mart?
Define the governance model to be
used
Decide how these reports will be maintained, updated, governed after Go Live. Will they
be centrally maintained by IT, by a specific business team, or otherwise? And for which levels
of the data and application?
Build your Foundation Focusing on a few projects to help us gain experience and to build the foundation for
future, larger scale adoption and expansion
Confidential Proprietary
BI Foundation Deliverables
• “BI Basics” communication sessions for IT and business teams
• OBIEE database & application environments
• Configuration management and deployment & RPD Consolidation
• Technical features POCs
• Documentation standards
• Design and code review standards
• Design templates and accelerators for new projects
– ETL/batch job templates
– GUI/Report template standards
– Governance models
Business Intelligence Case Study for SUPERVALU
Tuesday, September 20, 2011
Jamal Syed
© 2010 Emerging Solutions. All rights reserved. Confidential and proprietary information. www.emergenow.com
• A major retail and supply chain company
• Approximately 2500 stores, 900 in-store pharmacies and 2500
affiliates through the supply chain operations.
• A leader in supply chain operations such as grocery distribution,
produce distribution, independent sales and marketing, supply
chain technology, third party logistics.
• Growth through mergers and acquisitions (differentiating factor
from other major retail chains)
Firm Profile
© 2010 Emerging Solutions. All rights reserved. Confidential and proprietary information. www.emergenow.com
Engagement Drivers
• One of the biggest challenges at Supervalu is the analysis of claims data utilized by several departments in making crucial business decisions.
• Safety group utilizes this data to analyze and take action on safety measures in stores to reduce claims and related expenses for Supervalu.
• Current toolsets and data fragmentation make the business process difficult
• Business has no direct access to data
• Emerging Solutions first implemented a CRP with OBIEE
• Feedback and interest initiated a phased BI framework implementation with Safety group as the first customers
© 2010 Emerging Solutions. All rights reserved. Confidential and proprietary information. www.emergenow.com
• Data access: Unavailability of claim and financial data to business users
• Multiple data silos: Data reaching business user from multiple systems
• Total IT dependency: Reports had to be run by IT against source systems
• Excel-based reporting: Only reporting tool for business user
• Manual calculations: All KPI calculated manually in Excel
• Only static reports: Business users cannot drill into the actual issues
• Delay in accessing business critical data: Delays from 2-6 weeks
• No standard definitions: Risk of inconsistent calculations and meanings
• Multiple reports for same information: Stitching and recalculation efforts
BI Challenges - Business
© 2010 Emerging Solutions. All rights reserved. Confidential and proprietary information. www.emergenow.com
• Single version of truth
• Timely data for analysis
• BI for everyone
• Scalable solution
Emerging Solutions Engagement Goal
© 2010 Emerging Solutions. All rights reserved. Confidential and proprietary information. www.emergenow.com
BI Optimization Process
Optimizing BI Extend Reach and
Capabilities Build a Framework
for Enterprise BI Align Business and
IT
Govern the Process BI for everyone Build a BICC Establish
Accountability
Measure and Communicate
Success
Empower the People Improve End-User
Adoption Leverage
Technology Train End-
Users Manage Change
Reduce Fragmentation
Agile Development for Quick Wins
Reduce Pain with Standardization
Optimization Roadmap
© 2010 Emerging Solutions. All rights reserved. Confidential and proprietary information. www.emergenow.com
Enablement - A Centralized BI Framework with OBIEE
Reporting Data mart
ODS
DW1
DW2
DW3
ODS
MDS
Presentation Layer
•User Roles, Preference •Simplified View •Logical SQL Interface
Logical Business Layer •Dimensions •Hierarchy •Measures •Calculations •Aggregation Rules •Time Series
Physical Layer •Map Physical Data •Connections •Schema
OBIEE
Spreadsheets
© 2010 Emerging Solutions. All rights reserved. Confidential and proprietary information. www.emergenow.com
High-level Engagement Steps Requirements Gathering
Data Model and Subject Area Build
Data Source Analysis and Mapping
ETL (Informatica)
Business Model Build
User Roles and Groups
Standardized User Layer Build
Interactive Dashboard Build (OBIEE)
Schedule Formatted Report Build
(BI Publisher)
© 2010 Emerging Solutions. All rights reserved. Confidential and proprietary information. www.emergenow.com
Emerging Solutions Value-add
• With the implementation of the data mart framework and OBIEE the
reporting times for Safety has been reduced from 2-6 weeks to a
single day
• The phased approach of implementation introduced instant
gratification and built the groundwork for further integration and
enhancements
P 18
Chicago
20 North Wacker Drive, Suite 1870
Chicago, IL 60606
312-669-9600
Minneapolis
Two Carlson Parkway, Suite 205
Plymouth, MN 55447
763-278-9700
www.emergenow.com
© 2010 Emerging Solutions. All rights reserved. Confidential and proprietary information. www.emergenow.com
Thanks!
Jamal Syed Emerging Solutions – National Practice Lead, BI