Why PowerPivot for SharePoint?
From time to time I hear questions and comments from folks questioning why they should purchase the server-side component for PowerPivot. After all, the client software is free (with a Office 2010 Professional license). Why spend the money to invest in the server pieces . . . And because it requires a SQL Server Enterprise Edition license, it can get costly.
Having spent 3+ years of my life developing this product, naturally I have a fair amount of passion around this topic. The following is my own personal reasons; my own personal goals for the software and why I believe PowerPivot is such a pivotal (pun intended) component in a company’s BI strategy. This is not marketing and I apologize up front for it. So here goes:
What is the value-add for PowerPivot for SharePoint?