Business Intelligence

1
Business Intelligence Business Performance
Management

• Presented by Sheryl Chisholm, Adam Lomas, Max
  Upton and Jenna Burge

2
BI and BPM A Video Introduction

• http//www.youtube.com/watch?vod2BlylNkBY

3
Outline

• Business Intelligence and Business Performance
  Management An Overview
• Primary Functions/Tools
• Extract/Transform/Load (ETL) Process
• Case Study
• Questions?

4
Business Intelligence

• A broad category of application programs and
  technologies that allow organizations to gather,
  consolidate, store and analyze organizational
  data to help users make better business decisions.

5
Business Performance Management

• A set of processes that help organizations
  optimize business performance.
• Focused on business processes such as planning
  and forecasting.
• Helps businesses discover efficient use of their
  business units, financial, human and material
  resources.

6
Benefits

• Identify problems and inefficiencies
• Increase value-adding activities
• Exploit opportunities
• Different views of data

• Data integration
• Freedom from IS department
• Return on Investment (ROI)
• Centralized view of financial data

7
Primary Functions and Tools used in Business
Intelligence

• Data warehousing
• OLAP
• End-user
• Data mining

8
Data Warehousing

• Subject-oriented, integrated, time-variant and
  non-volatile collection of data in support of
  management's decision making process.
• Takes information from other systems in an
  integrated fashion
• Metadata
• "One version of the truth

9
Data Warehouse
10
On-line Analytic Processing

• OLAP
• Fast analysis of shared multidimensional data
• Tools
• Slicing and Dicing
• Drilling
• Different views 
• Benefit
• User can look at data in different ways

11
End-User Reporting

• User able to create
• Own queries
• Own reports
• Own views
• Benefit
• User can ask any question
• Designed to be used by non technical users?

12
Data Mining

• Refers to the analysis of the large quantities of
  data stored in computer
• 2 Types of Data mining approaches
• Hypothesis Testing
• Knowledge discovery
• Benefit Organization able to gain the
• desired knowledge

13
Extract/Transform/Load
14
Process Extract-Transform-Load
15
Case Study Virgin Megastores Crescendo

• How BI helps the mammoth entertainment retailer
  understand traffic patterns, identify hot items
  and schedule its employees using nearly
  up-to-the-minute information.

16
Case Study Virgins Crescendo

• The Problem Poor visibility of traffic and sales
  data.

• Most albums do 50 of sales in first 2 weeks of
  release
• Managers only received previous day/weeks
  traffic and sales figures
• No historical comparisons
• No actionable information

17
Case Study Virgins Crescendo

• The Solution Crescendo - Real Time BI

• Combines current and historical store data
• Headquarters information
• Traffic counter
• POS purchasing data
• Inventory and merchandising

18
Case Study Virgins Crescendo

• Key Metrics

• Average per sale
• Sales Compared to Plan
• Browser2Buyer Conversion Rate
• Color coded Heat Map shows HOT genres

19
Case Study Virgins Crescendo

• Benefits

• Managers see what is happening NOW
• Adjust strategy on the fly
• (i.e. Sales, Merchandising)
• Saves 330 man hours per month spent producing old
  reports
• Visibility across organization
• (store managers, buyers, financial managers)

20
Summary

• Overview of BI and BPM
• Purpose
• Benefits
• Functions/Tools
• Data Warehousing
• ETL (extract/transform/load) Process
• Case Study Virgin Megastores Crescendo

21
Questions?
22
Photo References

• http//data-warehouses.net/architecture/dwdiagram_
  files/image001.gif
• http//techpubs.sgi.com/library/dynaweb_docs/0650/
  SGI_EndUser/books/MineSet_T/sgi_html/figures/datap
  rocess.gif
• http//www.relativitycorp.com/images/OLAP.jpg
• http//www.synthtopia.com/content/wp-content/uploa
  ds/2009/03/virgin-megastore-closing.jpg
• http//thepcweb.com/wp-content/uploads/2008/06/dat
  a-warehouse-architecture.jpg