Business intelligence(bi)

A deck on Business Intelligence

1. Business Intelligence(BI)
Prepared By –Arvind Dubey

2. Business Intelligence (BI)
Business Intelligence isthe 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 betterbusiness Decisions.
Business Intelligence (BI) is about getting the right information, to the right decision
makers, at the right time.
BIisanenterprise-wideplatformthatsupportsreporting,analysisanddecisionmaking.
BIleadsto:
Fact-baseddecisionmaking
“Singleversionofthetruth”

3. Why BI?
Measurement: creating KPI (Key Performance Indicators) based on historic data
Identify and set benchmarks for varied processes.
With BI systems organizations can identify market trends and spot business problems that
need to be addressed.
BI helps on data visualization that enhances the data quality and thereby the quality of
decision making.
BI systems can be used not just by enterprises but SME (Small and Medium Enterprises)
Making useful, actionable insight from stored data.
Allows effective business decisions to be made.
The act of using historical data to gain new information.

4. 5
Questions BI is Designed to Answer
•Whathappened?
•What ishappening?
•Why did ithappen?
•What willhappen?
•What do I want tohappen?
ERP CRM 3PtySCM
Black
books
Past
Present
Future
Data

5. How BI systems are implemented?
Step 1) Raw Data from corporate databases is extracted. The data could be spread across
multiple systems heterogeneous systems.
Step 2) The data is cleaned and transformed into the data warehouse. The table can be
linked, and data cubes are formed.
Step 3) Using BI system the user can ask quires, request ad-hoc reports or conduct any other
analysis.

6. Types of BI users
There are four key players who are uses Business Intelligence System:
1. The Professional Data Analyst:
The data analyst is a statistician who always needs to drill deep down into data. BI system helps them to
get fresh insights to develop unique business strategies.
2. The IT users:
The IT user also plays a dominant role in maintaining the BI infrastructure.
3. The head of the company:
CEO or CXO can increase the profit of their business by improving operational efficiency in their business.
4. The Business Users
Business intelligence users can be found from across the organization. There are mainly two types of
business users

7. BI Life Cycle

8. Phases of BI Cycle

9. Characteristics of BI
Single point of access toinformation
Timely answers to Businessquestions
Using BI in all Departments of anorganization

10. Key Stages of BI
Data Sourcing
Data Analysis
Situation Awareness Risk Analysis
Decision Support

11. Change trend in market share
Changes in customer behaviour & spending patterns
Customers' preferences
Company capabilities
Market conditions
BI Application and technologies

12. ❑Companies need to have accurate, up-to-date information on customer
preferences ,So that company can quickly adapt to their changing demands
❑BI applications can also help managers to be better informed about actions
that a company’s competitors are taking
❑It help analysts and managers to determine whichadjustments are mostly likely
to respond to changing trends
❑IT can help companies develop a more consistent,data-based decision,which
can produce better results than making business decisions by “guesswork”
Significance of BI

13. 1.Dashboards
2.Key Performance Indicators
3.Graphical OLAP
4.Forecasting
5.Graphical Reporting
Modules of BI

14. 1. Dashboards
BI dashboards can provide a customized snapshot of daily operations,
and assist the user in identifying problems and the source of those
problems, as well as providing valuable, up-to-date information about
financial results, sales and other critical information –all in one place
Modules Description

15. 2. Key Performance Indicators
BI provides simplified KPI management and tracking with powerful features,
formulae and expressions, and flexible frequency, and threshold levels. This
module enables clear, concise definition and tracking of performance indicators
for a period, and measures performance as compared to a previous period.
Intuitive, color highlighters ensure that users can see these indicators in a clear
manner and accurately present information to management and team members.
Users can further analyse performance with easy-to-use features like drill down,
drill through, slice and dice and graphical data mining

16. 3. Graphical OLAP
Graphical Business Intelligence (BI) OLAP technology makes it easy
for your users to find, filter and analyse data, going beyond numbers,
and allowing users to visualize the information with eye-catching,
stunning displays, and valuable indicators and gauges, charts, and a
variety of graph types from which to choose

17. 4. Forecasting and Predictive Analysis
Our predictive analysis uses historical product, sales, pricing, financial,
budget and other data, and forecasts the measures with numerous
time seriesoptions, e.g., year, quarter, month, week, day, hour or even
second to improve your planning process

18. 5. Reports
BI Reports deliversweb-based BI reports to anyone (or everyone) in
the organization within minutes! The BI suite is simple to
use, practical to implement and affordable for every organization. With
our BI reporting and performance reporting module, you just point-and-
click and drag-and-drop and you can instantly create a report to
summarize your performance metrics, or operational data

19. 8
Improving organizationsby
providing businessinsights
to all employees leadingto
better, faster, more
relevantdecisions
Advanced Analytics
Self ServiceReporting
End-UserAnalysis
Business PerformanceManagement
OperationalApplications
EmbeddedAnalytics
BI Visions

20. BI involves five stages of taking raw data and presenting it as relevant,
actionable insight to users –
1. The Data (OLAP, OLTP)
2. The ELT (Extract, Transform, and Load)
3. Data Warehousing
4. Analytic Engine (Data Mining)
5. Presentation Layer
The 5 Stages of BI

21. 1. IBM Model 1958
Examplesof BI

22. 2. Microsoft BI Platform
Examplesof BI

23. The Use-case of BI

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

25. Any Question ?

26. Thank You !!!