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 -
- MIA-SQLBI - This instance is the main SSAS instance
- MIA-SQLBI\POWERPIVOT - This instance is Tabular Data Model used by SharePoint
- MIA-SQLBI\SQL2 - This instance hosted Workspace Database and the real Tabular Data Model databases.
