Transcript Business Intelligence Overview

Business Intelligence Overview
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
• Business Intelligence is a broad category of applications and technologies for
gathering, storing, analyzing, and providing access to data to help clients make
better business decisions
• Business Intelligence is a combination of the tools and systems involved in an
enterprise's strategic planning that aid in its analysis
www.vibloo.com/Business-intelligence
Skype Id: info.vibloo
Email: [email protected]
USA: +1-248-809-1418
IND: +91-40-3296-5222
History of Business Intelligence?
• 1958: The 1. use of BI by IBM Researcher Hans Peter Luhn in "A Business
Intelligence System“
• 1989: Gartner Research - Howard Dresner - "father of BI" – first coined the term
as "a broad category of software and solutions forgathering, consolidating,
analyzing and providing access to data in away that lets enterprise users make
better business decisions“
• 1993: Micro Strategy 1. BI SW Product: EIS Toolkit
• 1997s: BI widely used
• 2010-2013: SaaS BI growth +22%History
www.vibloo.com/Business-intelligence
Skype Id: info.vibloo
Email: [email protected]
USA: +1-248-809-1418
IND: +91-40-3296-5222
Evolution of Business Semantics
User Evolution
Analytics
Performance
Management
Business
Intelligence
Data
Warehousing
1990
2000
2010
Vendor Evolution
www.vibloo.com/Business-intelligence
Skype Id: info.vibloo
Email: [email protected]
USA: +1-248-809-1418
IND: +91-40-3296-5222
Business Intelligence Process
Decision Making
Data Visualization
Data Mining
Data Exploration
Data Warehouse
Data Sources
www.vibloo.com/Business-intelligence
Skype Id: info.vibloo
Email: [email protected]
USA: +1-248-809-1418
IND: +91-40-3296-5222
Business Intelligence Components
www.vibloo.com/Business-intelligence
Skype Id: info.vibloo
Email: [email protected]
USA: +1-248-809-1418
IND: +91-40-3296-5222
Data Warehouse
• Data warehousing is the process of constructing and using data warehouses
• A decision support database that is maintained separately from the
organization’s operational database
• A consistent database source that bring together information from multiple
sources for decision support queries
www.vibloo.com/Business-intelligence
Skype Id: info.vibloo
Email: [email protected]
USA: +1-248-809-1418
IND: +91-40-3296-5222
OLTP - Online Transaction Processing
• Online transaction processing, or OLTP, is a class of information systems that
facilitate and manage transaction oriented applications, typically for data entry
and retrieval transaction processing
• Online transaction processing increasingly requires support for transactions that
span a network and may include more than on e company. For this reason, new
online transaction processing software uses client or server processing and
brokering software that allows transactions
to run on different computer
platforms in a network
www.vibloo.com/Business-intelligence
Skype Id: info.vibloo
Email: [email protected]
USA: +1-248-809-1418
IND: +91-40-3296-5222
OLAP - Online Analytical Processing
• Online transaction processing, or OLTP, is a class of information systems that
facilitate and manage transaction oriented applications, typically for data entry
and retrieval transaction processing
• Online transaction processing increasingly requires support for transactions that
span a network and may include more than on e company. For this reason, new
online transaction processing
software uses client or server processing
and
brokering software that allows transactions to run on different computer platforms
in a network
www.vibloo.com/Business-intelligence
Skype Id: info.vibloo
Email: [email protected]
USA: +1-248-809-1418
IND: +91-40-3296-5222
Data Mining & its Process
• Data Mining is the computational process of discovering patterns in large data
sets involving methods at the intersection of artificial intelligence, machine
learning, statistics, and database systems
Pre Processing
Before data mining
algorithms can be
used, a target data
set must be
assembled
Data Mining
Result Validation
• Involves Anomaly
Detection
• Clustering
• Classification
• Regression
• Summarization
The final step of
knowledge discovery
from data is to verify
that the patterns
produced by the data
mining algorithms
occur in the wider data
set
www.vibloo.com/Business-intelligence
Skype Id: info.vibloo
Email: [email protected]
USA: +1-248-809-1418
IND: +91-40-3296-5222
Business Intelligence Layers
Presentation Layer
Reporting
Analysis
Presentation Layer
Dara Warehouse
Presentation Layer
The final step of
knowledge discovery
from data is to verify
that the patterns
produced by the data
mining algorithms
occur in the wider data
set
Finance Dept, HR Dept.
CRM
OS
Excel
www.vibloo.com/Business-intelligence
Skype Id: info.vibloo
Email: [email protected]
USA: +1-248-809-1418
IND: +91-40-3296-5222