MSBI -- Data Warehousing Concepts -- Part-3

What is BI(Business Intelligence):

                               The Process of Converting Raw-data into useful information & set of tools which is used to do this, Is called Business Intelligence

Any BI Process includes two Phases:

   1.  ETL (Extract, Transform and Load):

Ø Which means Extracting data from different source systems

Ø Transforming the data by applying business logic & formatting them

Ø And finally load the data into Data warehouse

Different ETL Tools in the Market:

·        SSIS(SQL Server Integration Services)

·        Informatica

·        Data Stage

·        Abinitio

   2.  Reporting and Analysis Phase:

             Once the data is ready in the Data Warehouse tables, then we can generate the reports by reading the data from DWH Data.

Different Reporting & Analytic Tools in the Market:

·        SSRS(SQL Server Reporting Services)

·        SSAS(SQL Server Analysis Services)

·        Tableau

·        Cognos

·        Excel

·        Business Objects.