Difference between Microsoft Business Intelligence MSBI and Power BI. SSIS, SSAS and SSRS. About MSBI and Power BI.

Difference between Microsoft Business Intelligence MSBI and Power BI. SSIS, SSAS and SSRS.

Microsoft Business Intelligence - MSBI

Microsoft product with ETL capability, multidimensional data organizing capability and visualization ability. MSBI comes with three sub components to support earlier mentioned functionalities. The following are the components of MSBI:

MSBI - SSIS

This component works as an Data Integration Service which can perform up to some level of ETL acitivity.

MSBI - SSAS

This component works as Multi Dimensional data storage using a CUBE to store the facts and dimensions.

MSBI - SSRS

This component works as Data Visualization layer by allowing to create Dashboards and Reports.

POWER BI

This is a new Product from Microsoft. Designed to improve the Self-Service capabilities of older SSRS. Power BI desktop allows to create reports on the fly and publish them. Using any browser end users can view the reports.

MSBI INTERVIEW QUESTIONS - INDEX

Difference between Microsoft Business Intelligence MSBI and Power BI. SSIS, SSAS and SSRS.