Business Intelligence

1
Business Intelligence

• Susan Doniz Firka
• Associate Director Business Intelligence
• Procter Gamble

2
Agenda

• What is BI?
• Why BI?
• How is BI being used in industries?
• Where are the challenges?
• QA

3
What is Business Intelligence?

• DATA
• KNOWLEDGE
• ACTION

4
How does it work?
Executive
Detect
Objectives
Strategies Best Practises
Operational
Key Performance Indicators (KPIs)
Explain
Causal Measures of KPIs
Seamless link
Seamless link
Ad Hoc
Transactional Reporting
5
Prework required
6
Simple Intuitive Tools Dashboards

• Provide One-Stop Shopping to deliver key
  information to decision-makers
• Simple Graphical interface to flag issues
  opportunities
• Role-based information and modules
• Eliminate information clutter by eliminating
  in-control data

7
Information week 2006
8
Why invest in BI?Bottomline

• 81 Executives2 state that timely, high quality
  easy to access data would increase profits
• 23 of companies use causal models1 Of those
  Return on Equity and Assets are 5 3 more
  respectively of those that do not use causal
  models

1 Harvard Business Review Survey 2 CIO Insight
9
Predictive Business Management
Explain
React
Predict
Focus on Key Business Drivers
Reporting What Happened?
Predict the Future Act
10
Predictive Business Management
Explain
React
Predict
Focus on Key Business Drivers
Reporting What Happened?
Predict the Future Act
11
Benefits

• Power user community freed up from the
  mundane and enabled to leverage their intellect
  and experience in discovering knowledge and solid
  strategies.
• Corporate IQ grows as intelligence building
  ways are captured and propagated across company
  and knowledge is preserved
• Decision makers attention gets focused on the
  few areas where the biggest problem or
  opportunity exists despite of the future raw
  data complexity explosion

12
How Business use BI scorecards
Information week 2006
13
Example Scorecards
14
Key Business Drivers Dashboard Example

• 1. Executive looks at OGSM measures on their
  Cockpit in portal

2. Double-click on profit shows that
Realization/SU is the issue
3. Double-click on Real/SU shows the control
chart.
15
(No Transcript)
16
Ease of Use/Skill Development

• Critical to define the WHO
• Prime Prospect User
• Use of KPIs

17
Data Quality

• Start with KPIs
• Amount of data/standardization of data
• High Level endorsement of Single version of the
  truth and Reward systems
• Garbage in Garbage out

18
Challenge ROI
19
Who are the leaders in the BI space?
20
Questions?