The Excel 2010 blog just posted an interesting article on the management aspects of PowerPivot – more of a “Why should I care?” kind of article, see (http://blogs.msdn.com/excel/archive/2010/02/01/management-features-of-powerpivot-for-sharepoint.aspx). It shows how PowerPivot helps IT answer:
- Where are my mission critical PowerPivot workbooks? And what data is inside them? –> The usage infrastructure records connection information and query response patterns.
- How are my data sources being used? –> When the infrastructure loads a PowerPivot database on-demand, we log data source information in our usage tables.
All in all, it is an interesting read.