BI Introduction

What is Business Intelligence

          It is the process of converting a raw data into a meaningful report which helps in analyzing, decision making, forecasting and budgeting to meet the business purposes.  BI can handle enormous amount of data to help identify, develop and create new opportunities. Making use of new opportunities and implementing an effective strategy can provide a competitive market advantage and long-term stability.

Ø  Multidimensional aggregation and allocation

Ø  De-normalizing tagging and standardization

Ø  Real time reporting with analytical alert

Ø  Interface with unstructured data source

Ø  Group consolidation, budgeting and rolling forecast

Ø  Statistical inference and probabilistic simulation

Ø  Key performance indicators optimization

Ø  Version control and process management

Ø  Open item management

BI technologies provide historical, current and predictive views of business operations. Common functions of business intelligence technologies are reporting, online analytical processing, analytics, data mining, process mining, complex event processing, business performance management, benchmarking, text mining, predictive analytics and prescriptive analytics.

Need of Business Intelligence:

                Any industry out there looking for growth in terms of it financial, employees, dominate market over the technologies ETC and importantly to remain or operate stable during financial breakdowns.

          To achieve the business goals the organization need intelligence systems provide real time data with facts and figures using history data available. No Organization by overnight has not been an enterprise organization or the make profits that could do in a year. To achieve all the above BI Tools are used.

Need of the BI? 

Now consider a company having more than several decades of history and presence in almost all the areas. Over these years company’s data management style has changed from book keeping to SAP. This transition was not a single day transition, it took decades to reach SAP or any RDBMS, as and when technology advances, same technologies had to developed, tested and integrated to system. Like in systems from mainframes to Servers, in data storage from flat file system to relational databases, in programing languages from COBOL to JAVA.. This transition resulted in splitting business to sub business systems, running different applications on different platforms, having hardware from different architectures, same wise technologies is introduced as when invented and when required.

          This directly resulted into the scenario, like HR department of the company running on Oracle Applications, Finance running SAP, some part of process chain supported by mainframes, some data stored on Oracle, some data on mainframes, some data in VSM files & the list goes on. If one day company requires a consolidated report of assets, there are two ways.

Ø  First completely manual, generate different reports from different systems and integrate them.

Ø  Second fetch all the data from different systems/applications, make a Data Warehouse, and generate reports as per the requirement.

Obviously second approach is going to be the best.

BI reporting comes after the ETL data migration, since this can be done by using ETL tools or by using primitive coding using PLSQL. When the DWH system is built then comes to report designing based on the requirement using BI Tools.

Advantages of Business Intelligence

Ø  Provides quick decision based on facts through reports

Ø  Helps the organization to grow by achieving key objectives.

Ø  Combines the data from different sources for decision making.

Ø  Efficient collection and distribution of vital data.

Ø  Helpful in forecasting and budgeting.

Ø  Reduce information bottlenecks

Ø  Reduce Costs and Increase profits.

Ø  Improved data security.

Ø  Make you aware during crisis by sending alerts.

BI Tools performance in Market

History of OBIEE

           Oracle Business Intelligence Enterprise Edition Plus is a Oracle product contribution by nQuire , Siebel Analytics and Hyperion Solutions Business Intelligence.

           OBIEE is a architectural unified business intelligence application built from C++ and Java. It is used by organization which delivers reporting, Ad-hoc query and analysis, Online analytical Processing, Dashboards and Scorecards. 

End users can interact and access information in multiple ways, including web-based interactive dashboard reporting, search bars, Enterprise Resource Planning, Customer Relationship Management, Mobile devices and Microsoft Office Applications.

Old Name	New Name
Siebel Analytics Server	Oracle Business Intelligence Server
Siebel Analytics Web Server	Oracle Business Intelligence Presentation Services
Siebel Analytics Scheduler	Oracle Business Intelligence Scheduler
Siebel Answers	Oracle Business Intelligence Answers
Siebel Delivers	Oracle Business Intelligence Delivers
Siebel Intelligence Dashboards	Oracle Business Intelligence Interactive Dashboards
Siebel Analytics Web Catalog	Oracle Business Intelligence Presentation Catalog
Siebel Analytics Catalog Manager	Oracle Business Intelligence Catalog Manager
Siebel Analytics Server Administration Tool	Oracle Business Intelligence Server Administration Tool
Siebel Disconnected Analytics or Mobile Analytics	Oracle Business Intelligence Disconnected Analytics
Siebel Open Intelligent Interface	Oracle Open Intelligence Interface
Related component programs:	Related component programs:
Chart image server	Chart image server
Siebel Analytics Client Tools	Oracle Business Intelligence Client Tools
Siebel Analytics ODBC Client	Oracle Business Intelligence ODBC Client
Siebel Briefing Book Reader	Oracle Business Intelligence Briefing Book Reader
Siebel Business Analytics Briefing Books	Oracle Business Intelligence Briefing Books
Siebel Analytics Microsoft Excel add-in	Oracle Business Intelligence Microsoft Excel add-in
XML Publisher	Oracle Business Intelligence Publisher