Chapter 4 Getting Started with Business Intelligence
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
Learning Objectives and Learning Outcomes
Learning Objectives
Getting started on Business Intelligence 1. 2. 3. 4. 5.
Learning Outcomes
(a) To understand why BI is important
6.
7. 8. 9.
Understanding Business Intelligence The Acronym BI (b) To understand the need for a What are the other terms for BI? Data warehouse The meaning of BI, BI defined? What relationship then DSS, EIS, MIS, etc. (c) To understand the need for BI have with BI? at all levels Is the term Data-warehouse synonymous with BI? (d) To understand the difference Difference between ERP (Enterprise Resource between BI and ERP Planning) and BI Need for Business Intelligence at virtually all levels BI for Past, Present and Future
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
Session Plan
Lecture time Q/A
: 90 minutes approx. : 15 minutes
Fundamentals of Business Analytics
RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
Agenda
What is BI? Business Intelligence by Other Names BI Defined BI is BI and decision making Why BI? Need for BI at virtually all levels How BI? Case studies ERP vs. BI Introduction to Business Analytics Differences between Business Intelligence and Business Analytics
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
What is BI?
Business Intelligence (BI) is about getting the right information, to the right decision makers, at the right time. BI is an enterprise-wide platform that supports reporting, analysis and decision making. BI leads to:
fact-based decision making single version of the truth
BI includes reporting and analytics.
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
Business Intelligence by Other Names
Reporting
Competitive Intelligence
Decision Support System
Business Investment Business Insight
Business Analytics
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
BI Defined
Howard Dresner, of the Gartner Group, in 1989 coined the term BI. He defined BI as a set of concepts and methodologies to improve decision making in business through use of facts and fact-based systems. The goal of BI is improved decision making. Yes, decisions were made earlier too (without BI). The use of BI should lead to improved decision making. BI is more than just technologies. It is a group of concepts and methodologies.
It is fact based. Decisions are no longer made on gut feeling or purely on hunch. It has to be backed by facts.
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
Answer a Quick Question
Can you explain why Businesses choose to leverage analytics for decision making ?
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
BI Defined
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
BI is
Fact-based decision making
Single version of truth
360 degrees perspective on your business
Virtual team members on the same page
Visibility into enterprise performance
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
Answer a Few Quick Questions
What problems can an enterprise encounter, if the single version of truth is compromised? Cite a few examples from everyday life of fact-based decision making.
What is your understanding of 360 degrees perspective and why do you think it is important?
You are a Project Manager. You lead a 10 member team. Your team members are in three geographically different locations. What measures will you take to ensure that all your team members are on the same page?
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
BI and Decision Making
High
Low
Strategic Impact Tactical Frequency
Operational
Low High
Types of Decisions
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
Explain
Explain Strategic, Tactical and Operational Decisions by providing appropriate examples.
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
Answer a Quick Question
Do you think BI only deals with analysis of past data ?
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
Why BI?
What happened? Why did it happen? What is happening? Why is it happening? What will happen?
Know the past
Analyze the Present
Predict the Future
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
Need for BI at Virtually All Levels
There is too much data, but too little insight! Business Intelligence has been there in the boardroom for long. There is a need to expand business intelligence from the boardroom to the front lines! Structured and unstructured data need to converge!
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
How BI?
IT Department Source Systems Business Users
ORDERS
Data Warehouse
Report Query Analyze Alert
BI Tools
INVOICES
SHIPPING Web Clicks
Extract Transform Load
Relational Tables
OLAP
External Data
Analytic Applications
(Product Profitability, Workforce Planning, CRM)
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
Challenges in Retail Industry
RETAIL SHOP
Cost to Serve ?
Manage Inventory? Promotional Offers? Attract Customers?
30% Off
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
Retail Industry Leveraging BI
Daily Sales Transactions
Customers Transactions
Data Warehouse
Customer, Demographics or products/price details Online Shopping
Products
Reporting Tools
Analytics Tools
Best Practices
Optimization Techniques
Optimized Inventory and Allocation
Optimized Costs
New Promotions
Identifying Customer Needs
30% Off
Explain
Explain how BI is being leveraged in the insurance/healthcare/banking sector, etc.
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
Data Mining in Retail
The Diapers-Beer Example
A (hypothetical) pattern learned from transaction data: On Friday evenings, shoppers who buy diapers also buy beer. Highlights new, surprising correlations that can be acted on by the store. To promote more users to display this behavior, consider dynamic store layout decisions that might alter locations of products based on copurchase Consider couponing strategies that can be used to cross promote related products in some cases.
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
Data Mining in Credit Card Fraud
Credit card fraud costs the industry billions of dollars each year and pattern discovery tools and machine learning models such as neural networks are routinely
used to analyze fraud databases to identify triggers.
A self-service transaction at a gas station followed by an expensive purchase is indicative of fraud. An example pattern learned from credit card fraud data Pattern is then used in real-time to flag transactions that might be fraudulent.
For instance, if you fill gas in your car with a credit card and then make an
expensive purchase then the merchant may be instructed (by the point of sale system) to check the users ID.
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
Data Mining in UI Optimization
A simple example had to do with discovering that on the Yahoo Front Page, centering the search box on the page (as opposed to having it be left-justified) would increase consumer usage. This led to better user engagement and there was no cost to Yahoo! to make the change. This was discovered by discovering the hidden pattern that showed that Netscape users tended to use search more than IE users, and by discovering that the only visible difference was the subtle position of the box! It was centered on Netscape browsers but left justified on IE browsers. A very unnoticeable difference, yet an important one. Who would figure that out???
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
Data Mining for Marketing
Online Product Recommendations [Link] pioneered the use of collaborative filtering based approaches to recommend products to users online.
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
ERP vs. BI
ERP
ERP is for data input Essentially an operational /transactional/ OLTP system
BI as an enterprise application
BI is for data retrieval Essentially OLAP
Supports the capture, storage and flow of Supports the integration of data from varied data across multiple units of an organization data sources, transforms the data as per business requirements and stores it in the business data warehouse Has support for a few prebuilt reports which Supports advanced form of reporting usually help to meet the transactional needs (boardroom quality) and visualization. Has of the organization support for dynamic reports, drill down reports, drill across reports , etc. Has little or no support for analytical needs Supports the of the organization organization analytical needs of the
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
Introduction to Business Analytics
Business analytics is heavily dependent on data. For its successful implementation, business analytics requires a high volume of high quality data. The challenges faced by business analytics are: storage, integration, reconciliation of data from multiple disparate sources across several business functions and the continuous updates to the data warehouse.
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
Differences between Business Intelligence and Business Analytics
Business Intelligence
Answers the questions: What happened? When did it happen? Who is accountable for what happened? How many? How often? Where did it happen? Reporting (KPIs, metrics) Automated Monitoring/Alerting (thresholds) Dashboards /Scorecards OLAP (Cubes, Slice & Dice, Drilling) Ad hoc query
Business Analytics
Why did it happen? Will it happen again? What will happen if we change x? What else does the data tell us that we never thought to ask? What is the best that can happen? Statistical/Quantitative Analysis Data Mining Predictive Modeling Design of experiments to extract learning out of business data Multivariate Testing
Makes use of:
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
Summarizing
BI is a $15 Billion market today and is growing at 15 to 20% BI leads to:
fact-based decision making
single version of the truth To find value in gigantic amounts of data collected in modern enterprises On enhancing the quality of the decision-making process To improve the rate at which the enterprises are able to make decisions Gartner Says Worldwide Business Intelligence, Analytics and Performance Management Software Market Grew 4 Percent in 2009
BI focuses:
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
Summary please
Ask a few participants of the learning program to summarize the lecture.
Fundamentals of Business Analytics RN Prasad and Seema Acharya Copyright 2011 Wiley India Pvt. Ltd. All rights reserved.
