Tuesday, October 19, 2010

What is Business Intelligence

What is Business Intelligence:

Getting the right information to the right people at the right time, so that everyone can trust on the data and use for more effective decision making.
The Interactive process of analyzing and exploring the information to divide trends and patterns
It is an approach to management that allows an organization to define what information is useful and relevant to its corporate decision.

Tools for BI:
[Reporting Services] --> Cube or any Database
[Integration Services] --> Tables, Excel, Raw/Flat files
[Analysis Services] --> Cube and Mining

BI Applications:
Oracle, Siebel, Informatica, Cognos and Microsoft SQL Server

Connecting with SQL Server: While connecting to MS SQL Server have 2 options
Management Studio as Back-End
Business Intelligence Development Studio as Designer Tool

Common Terminologies:
Integration Services
Packages, Tasks, Transformations

Reporting Services
Report Server, Report Manager, Report Builder, Performance Point Server, ProClarity, Excel Power Pivot, Share Point Server

Analysis Services
Cube, Fact, Dimension, Hierarchy, KPIs, Partitions