PowerPivot vs Tabular Data Model vs Multidimensional Cube (MS 10778)

This diagram is to help MS10778 students to understand the overview of Microsoft Business Intelligence Solution, PowerPivot and Tabular Data Model is designed in Microsoft In Memory X-Velocity technology, the performance is very fast compare to traditional Multidimensional Cubes.

 

In MS10778 hyper-v image, there are 3 SSAS Instances -

1. MIA-SQLBI - This instance is the main SSAS instance
2. MIA-SQLBI\POWERPIVOT - This instance is Tabular Data Model used by SharePoint
3. MIA-SQLBI\SQL2 - This instance hosted Workspace Database and the real Tabular Data Model databases.