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.

POWER BI INTERVIEW QUESTIONS - INDEX

Explain Power BI Data Refresh Architecture

Configuring automatic refresh in Power BI

What is Differences between visual level filters, page level filters and report level filters in Power BI

What is Difference between Power BI Desktop and Power BI

Building Blocks in Power BI (or) Components of Power BI.

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