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.
OR
The Interactive process of analyzing and exploring the information to divide trends and patterns
OR
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
