What is Business Intelligence (BI)?
The term Business Intelligence (BI) provides the user with the data and tool to answer the questions which are important to run the business or part of business.In short,the business intelligence is used for reporting the specified data of any business which is very important and using which the higher management of the business will take the decisions for growth of business.Business Intelligence (BI) is used to take following organization level decisions:
- BI is used to determine whether the business is running as per plan
- BI is used to identify which things are going wrong
- BI is used to take and monitor corrective actions
- BI is used to identify the trends.
Business Intelligence basically analyses the data coming from different sources of database which is related to business and convert this data in to meaningful report so that higher management will get the idea of business.
Following are some Benefits of Business Intelligence :
1.Improving Decision Making
2. Accelerate Decision Making
3.Optimizing internal business process
4.Increase Operational Efficiency
5.Driving new revenues
6.Gaining competitive advantages over competitors
BI data can be historical as well as new data coming from different sources.The main purpose of BI is to improve the strategic as well as tactical decisions making process.Basically to create the BI reports there are so many BI tools used like COGNOS,OBIEE etc.Data analysts or IT professionals uses these different BI tools to collect strategical and tactical data.Business Intelligence term comes from the analysis and to create BI reports we need to analyse the data and convert that data into proper manner and proper fashion so that it is used for taking decisions .
Following are some basic Real life examples of BI :
Suppose we have one Sales Business,the Higher managements wants to know,
1.Showing the sales of business each district each month
2.Showing average sales amount this quarter
3.Showing average sales amount last five quarters
4.Showing highest rank product and lowest rank product with is sale.
These are some examples of business intelligence.User needs to create report using different conditions and different BI tools to analyse the data specified above.User will be able to give the same information in different formats using BI tools whether it is simple report format or graphs or charts also.In this section we will learn OBIEE tutorials.
Click on Topic You want to learn:
- History of SQL
- SQL Create Table(DDL in SQL)
- SQL DML Statements(INSERT,UPDATE,DELETE)
- SQL Select Statement Execution
- Operators in SQL
- Views in SQL
- Materialized View in SQL
- Joins in SQL
- Inner Join / Outer Join
- Full Outer Join / Cartesian Join
- Union and Union ALL
- Intersect and Minus
- Indexing in SQL
- Rank and Dense Rank
- SubQueries and Correlated Subqueries
- Parser and Optimizer
- Oracle 11 G new Features
- SQL Functions List
- Constraints in SQL
- Database Normalization
- Table Partitioning
- Pivot in SQL
- Difference Between Truncate,Delete and drop
- Oracle System Tables
Unix Tutorials :