To prepare the Exam 70-461 Querying Microsoft SQL Server, we can refer to the following link:-
https://drive.google.com/file/d/0By910BPLu7nTaHZ0bTRydDlyRzg/view?usp=sharing
Software development tips, tricks and advice from NG Yew Ban, a professional Microsoft Certified Trainer and Microsoft Certified Solution Developer. BizTalk, ASP.NET, VB.NET, C#, Visual Basic, MS Access, MS SQL Server, Oracle, JavaScript, MS Office and more!
Friday, November 07, 2014
Friday, August 08, 2014
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 -
- 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.
Subscribe to:
Posts (Atom)