Thursday, December 27, 2012

Getting started with the SQL Server 2012 Tabular Model - Part 2

In my last article, "Getting started with Tabular Model in SQL Server 2012 - Part 1" I talked in detail about differences between the multi-dimensional and tabular models, when to choose one model or another and I demonstrated step by step on how to create a basic tabular model project. But if you have prior experience working with PowerPivot, you might be thinking whatever we did, in the last tip, is very similar to what we can do in PowerPivot. Well, you are right to some extent, the Tabular model is actually a server side version of PowerPivot, but also has many more enterprise features, which are not available in PowerPivot for example partitioning, security, management, etc. In this article I am going to talk in detail about some of the compelling features of the tabular model and show you how tabular models differ from PowerPivot, for information click here.

No comments:

Post a Comment