Business Intelligence

1
Business Intelligence

• Greg Myers
• Jennifer Parker
• Tom Smith
• 11/17/2009
• MIS 261

2
Introduction

• Value Proposition
• Harrahs Casino- The Value of Data
• Rewards Program - 2x Revenue Growth
• Retailer- Tesco
• Reward Program - 22 Revenue Growth in 2 Years
  (5 b)

3
Business Intelligence Overview
4
Determining What Data is Needed
Balanced Scorecard
5
Determining What Data is Needed
Strategy Map
Balanced Scorecard
6
Addressing Data Quality

• Data Definitions
• Consistent Processes
• Data Monitoring/Cleaning
• System
• Enforcement
• Configuration/Patching
• Integration

7
Establishing Meta- Data

• Dimensions vs. Facts
• Dimension- is an attribute that displays total
  counts/amounts of a fact
• Fact- key additive measurement of business
  performance
• Document
• Definitions, Process, Systems, Formats
• Agreed upon data sources

8
Extract, Transfer, and Load (ETL)
9
Relational Database -OLTP
10
Star Schema - OLAP Data Warehouse
11
How to Successfully Build a BI Solution

1. BI implementation is a company wide project and
   should not be owned strictly by IT.
2. Allow developers to have access to the business
   owners and subject-matter experts.
3. Create manageable steps in the implementation and
   a reasonable time-line in which to complete them.

12
How to Successfully Build a BI Solution

• Create teams of small amounts of people with some
  experienced members.
• Manage the installation or upgrade of hardware
  capable of supporting fast processing of data to
  enable tight development cycles.
• Supply data to populate test versions of the data
  repository and test for expected outcomes

13
Signs of a Successful Data Repository

• Data repositories must be
• Scalable
• Flexible
• Backwards compatible
• Auditable
• Experienced Developers

14
BI Solutions for SAP Users
15
Presentation Tools

• Reports
• Microsoft Excel
• Queries
• Microsoft Access / Sun MySQL
• Dashboards
• Executive Information Systems (EIS)
• http//now.sprint.com/widget/

16
SAP Presentation Tools

• SAP BusinessObjects
• BEx Analyzer
• http//www.cnblogs.com/images/cnblogs_com/crazybug
  cn/AdHoc029.JPG
• BEx Query Designer
• http//www.expert-team.com/images/scr_BW_QueryDes
  igner.gif
• Crystal Reports
• http//www.fileguru.com/images/b/crd_subscription_
  information_managers_information_database-9250.jpe
  g
• Xcelsius
• http//myxcelsius.com/wp-content/uploads/2008/TOC/
  TOC_Calci.swf

17
Case Study Sisters of Mercy Health System
(Mercy)

• Situation major delays in report delivery
• Task - implement an enterprise wide business
  intelligence (BI) solution with a single
  overarching reporting structure
• Action research, select and install a BI
  solution
• Results
• Business Objects was the favored vendor as users
  especially liked the interfaces intuitiveness
  and ease-of-use
• Mercy was able to consolidate legacy data and
  make it fully accessible to authorized users
• Mercy is now able to utilize metrics that allow
  comparisons between internal entities
• Mercy staff now able to roll up financial
  statements and rapidly publish them following
  month-end close, with all information available
  online via a consistent and secure Web-based
  portal
• Data accuracy and consistency has reached
  unprecedented high levels

18
QA Segment

• Discussion Questions
• BI examples in your workplace
• Software
• User Access of final reports
• Ideas for BI utilization