Chapter 7. Using PowerPivot for SharePoint 2013

There are many tools that the business user, or the information worker, can reach to, but by far it is Microsoft Excel that is used most often. A great deal of today’s business decisions are based on an Excel workbook. However, there are some drawbacks inherent to this approach, and a few caveats must be issued:

  • It’s fairly common to share those workbooks by email or in a file share. This can potentially raise security issues.

  • It’s hard to assure that everybody working with a given workbook is using the same version, because access to that workbook is neither monitored nor controlled.

  • Refreshing the workbooks with new data can be a lot of work, and potentially, it’s a chore that needs to be done frequently. ...

Get Business Intelligence in Microsoft SharePoint 2013 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.