Enterprise business Inteligence

Maksud Saifullah Pulak
Software Engineer,Aprosoft
Enterprise Business Intelligence

What is
Business
Intelligence
 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”
Business Intelligence

What is
Business
Intelligence
 Making useful, actionable insight from
stored data.
 Allows effective business decisions to
be made.
 The act of using historical data to gain
new information.
 Techniques include:
 multidimensional analyses
 mathematical projection
 Pivot Queries
 ad-hoc queries (It's the kind of SQL
query you just loosely type out where
you need it)
 Dashboards
Business Intelligence

10
Questions BI is Designed to Answer
• What happened?
• What is happening?
• Why did it happen?
• What will happen?
• What do I want to happen?
ERP CRM 3PtySCM
Black
books
Past
Present
Future
Data

11
Improving organizations by
providing business insights
to all employees leading to
better, faster, more
relevant decisions
Advanced Analytics
Self Service Reporting
End-User Analysis
Business Performance Management
Operational Applications
Embedded Analytics
Business Intelligence Vision

12Microsoft BI Platform
Examples of BI

4 Types of Users  Executives : Information is summarized and
has been defined for them. Users have the
ability to view static information online and/or
print to a local printer.
 Casual Users
Casual users require the next level of detail
from the information that is provided to
viewers. In addition to the privileges of a
viewer, casual users have the ability to refresh
report information and the ability to enter
desired information parameters for the
purposes of performing high-level research
and analysis.
 Functional Users
Functional users need to perform detailed
research and analysis, which requires access
to transactional data. In addition to the
privileges of a casual user, functional users
have the ability to develop their own ad hoc
queries and perform OLAP analysis.
 Super Users
Super users have a strong understanding of
both the business and technology to access
and analyze transactional data. They have full
privileges to explore and analyze the data with
the BI applications available to them.
Business Intelligence Users

Information Access Strategies
Adhoc
Standard
Reports
Olap and
Drilldown
Exception
Based
Reports
Data
Mining

Palm Beach Tan Online Reporting Portal
A Retail Example

Franchise Performance Report
Store Store Tans
New
Customers New Efts Up Sell % Revenue PTA PRA Mystic PRA
ALA 1 1,436 70 53 75.70% $8,933 $6.22 $2.22 $0.45
2 1,479 75 51 68% $8,011 $5.42 $2.26 $0.40
3 1,824 82 65 79.30% $10,312 $5.65 $1.98 $0.89
4 1,925 106 66 62.30% $10,223 $5.31 $1.50 $0.36
5 522 33 29 87.90% $3,793 $7.27 $2.03 $0.68
6 1,144 52 57 109.60% $7,868 $6.88 $2.18 $0.34
7 3,447 102 73 71.60% $12,261 $3.56 $1.74 $0.26
8 1,434 73 38 52.10% $7,746 $5.40 $2.15 $0.95

Daily Snapshot
12 pm, 3 pm, 6 pm and 9 pm
Daily Snapshot
TOTALTANS 7,340
Store Rev $40,851.80
PTA $5.57
Retail Rev $18,561.02
PRA $2.53

Conclusion
 Business Intelligence solutions make it possible
for groups within organizations to gain actionable
insight from business data, and to leverage these
insights to meet critical goals.
 Business intelligence solutions offer business-
focused analysis at a scale, complexity, and
speed that is not achievable with basic
operational systems reporting or spreadsheet
analysis, thereby delivering significant value.

Enterprise business Inteligence

Enterprise business Inteligence

Recommended

Recommended

More Related Content

What's hot

What's hot (20)

Viewers also liked

Viewers also liked (20)

Similar to Enterprise business Inteligence

Similar to Enterprise business Inteligence (20)

More from Shahriar Iqbal Chowdhury

More from Shahriar Iqbal Chowdhury (14)

Recently uploaded

Recently uploaded (20)

Enterprise business Inteligence