MSBI (SSIS/SSRS/SSAS) Online Training

Friday, August 23, 2013

SSAS - Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services


What is Tabular Model Designer (SSAS Tabular)

The tabular model designer is part of SQL Server 2012 SQL Server Data Tools (SSDT), integrated with Microsoft Visual Studio 2010 or later, with additional project type templates specifically for developing professional tabular model solutions.

Benefits:
When you install SQL Server Data Tools (SSDT), new project templates for creating tabular models are added to the available project types. After creating a new tabular model project by using one of the templates, you can begin model authoring by using the tabular model designer tools and wizards.
In addition to new templates and tools for authoring professional multidimensional and tabular model solutions, the Visual Studio environment provides debugging and project lifecycle capabilities that ensure you create the most powerful BI solutions for your organization.





Comparing Tabular and Multidimensional Solutions (SSAS)

http://technet.microsoft.com/en-us/library/hh212940.aspx

Tabular models hosted in SQL Server 2012 Analysis Service provide a comparatively lightweight, easy to build and deploy solution for business intelligence. However, as you increase the data load, add more users, or run complex queries, you need to have a strategy for maintaining and tuning performance. This paper describes strategies and specific techniques for getting the best performance from your tabular models, including processing and partitioning strategies, DAX query tuning, and server tuning for specific workloads.

Download "Performance Tuning of Tabular Models in SQL Server 2012 Analysis Services" case study with detailed analysis:

http://msdn.microsoft.com/en-us/library/dn393915.aspx

Cheers,
Ravindra

7 comments:

sandhya p said...

hi nice blog you have gathered a valuable information on MSBI..., I am looking for content like this and i am much impressed with the information and nice course content, thanks a lot for the Information regarding MSBI Online Training Online Training.

tanvi k said...

This is nice article for who is interested in learning MSBI.Thanks for sharing MSBI Online Training information with us.

sandhya p said...


The information which you have provided is very good. It is very useful who is looking for MSBI Online Training.

Raju Kumar said...
This comment has been removed by the author.
Raju Kumar said...

I used to be able to find good info from your content.
SAP APO Online Training

Sgraph Infotech said...


Nice blog and thanks for sharing this informative blog about MSBI training.

msbi training in jayanagar bangalore

Sagar R said...

I really appreciate information shared above. It’s of great help. If someone want to learn Online (Virtual) instructor lead live training in Performance Tuning, kindly contact us http://www.maxmunus.com/contact
MaxMunus Offer World Class Virtual Instructor led training on Performance Tuning. We have industry expert trainer. We provide Training Material and Software Support. MaxMunus has successfully conducted 100000+ trainings in India, USA, UK, Australlia, Switzerland, Qatar, Saudi Arabia, Bangladesh, Bahrain and UAE etc.
For Demo Contact us:
Name : Arunkumar U
Email : arun@maxmunus.com
Skype id: training_maxmunus
Contact No.-+91-9738507310
Company Website –http://www.maxmunus.com