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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.