Decisions: PowerPivot, SSAS Tabular, or SSAS Multidimensional Model in SQL Server 2012
User Rating: / 0
Written by Melissa Coates   
Monday, 05 March 2012 19:13

I've been learning about the new features coming out in SQL Server 2012, including Tabular Models & PowerPivot. One thing I wanted was a decision matrix - for a new project, which type of model is most suitable for the requirements I am presented? I wanted thoroughly understand why I might suggest to a client that we create a model other than traditional OLAP. So, I created the decision matrix below for the purpose of helping to decide which type of model to create in SQL Server 2012.




XL Cubed