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

What is the default visual interaction in Power BI ?
How to change default visual settings in Power BI ?
How many types of interactions are there in Power BI ?.


What is DAX in Power BI ?
How to implement DAX in Power BI ?
What are the most commonly used DAX functions in Power BI ?
Sample DAX Formula in Power BI.


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.