O'Reilly logo

Business Intelligence in Microsoft SharePoint 2013 by Mariano Teixeira Neto Norman P. Warren Stacia Misner, Ivan Sanders, and Scott A. Helmers

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required