Chapter 16. Comparing Excel and SQL Server Analysis Services
This chapter is devoted to comparing Microsoft PowerPivot in Excel 2013 with its siblings in the family of analytical engines in the Microsoft Business Intelligence (BI) stack: PowerPivot for SharePoint and SQL Server Analysis Services (SSAS) 2012.
In fact, in 2012, Microsoft expanded its software offering with several products dedicated to the BI world. Moreover, it treads a clear path that starts with PowerPivot for Excel 2013, for self-service BI; moves to PowerPivot for SharePoint, for team BI; and then continues to SSAS, for corporate BI and complex solutions. The good news is that everything you have learned about Microsoft Excel in terms of data modeling techniques, the DAX language, ...
Get Microsoft Excel 2013: Building Data Models with PowerPivot now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
