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.
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.