Presentation Transcript
Overview :Overview What is Business Intelligence?
Why BI?
The characteristics of a Business intelligence
Benefits
Limitation
Example
What is Business Intelligence? :What is Business Intelligence? Business Intelligence is the processes, technologies, and tools that help us change data into information, information into knowledge and knowledge into plans that guide organization
Technologies for gathering, storing,
analyzing and providing access to data to
help enterprise users make better business
Decisions
Why BI? :Why BI? 4 What happened?
What is happening?
Why did it happen?
What will happen?
What do I want to happen? Past Present Future Data
The characteristics of a Business intelligence solution :The characteristics of a Business intelligence solution Single point of access to information
Timely answers to Business questions
Using BI in all Departments of an organization
Early day’s system :Early day’s system BI system
Key Stages :Key Stages
Benefits :Benefits Improve Operational efficiency
Eliminate report backlog and delays
Find root causes and take action
Negotiate better contracts with suppliers and customers
Identify wasted resources and reduce inventory costs
Sell information to customers, partners, and suppliers
Leverage your investment in your ERP or data warehouse
Improve strategies with better marketing analysis
Give users the means to make better decisions
Challenge assumptions with factual information
Limitation :Limitation Very high software cost.
Expensive and time consuming training.
A wide Variety of technology experts.
Extensive system upgrade and maintenance.
Movement of data between disparate data source.
Queries done out of BI systems can be cumbersome and time-consuming to run for end users
Search Effectiveness :Search Effectiveness Customers that search are worth two times as much as customers that do not search
Failed searches hurt sales Visit Search(64% successful) No Search Last Search Succeeded Last Search Failed 10% 90% 70% 30%
Top Searches :Top Searches Top searched keywords (percent of searches)
Empty search string (3.9%)returns over 160 results
GPS (1.2%)
sunglasses (0.8%)
watches (0.6%)
nalgene (0.5%)
ecological footprint (0.5%)
Top failed keywords in the product category (percent of failed searches)
gift certificate(s) (0.98%)(already implemented since study)
arc’teryx (0.44%)
bear spray (0.44%)
pedometer (0.37%)
stroller(s) (0.36%)
north face (0.33%)
(gift) registry (0.21%)
Referrers :Referrers Top Referrers
Google
5.8% of all visits are referred by google
Visit to purchase conversion 1.6%
Average purchase per visit = 1.8X
MSN (including search and shopping)
11% of all visits are referred by MSN
Visit to purchase conversion 0.7%
Average purchase per visit = X
AOL search
0.62% of all visits are referred by AOL Search
Visit to purchase conversion 2.6%
Average purchase per visit = 4.8X
Campaign Analysis :Campaign Analysis Analyze the effectiveness of campaigns Recommendation: Send targeted emails
Page Effectiveness Report Percentage of visits clicking on different links :Page Effectiveness Report Percentage of visits clicking on different links
Reference :Reference www.oracle.com
www.microsoft.com
www.bluemartini.com