Chapter 9. PowerPivot for Excel

One of the more exciting recent additions to the Microsoft business intelligence (BI) suite is a technology known as PowerPivot. I use the word technology because PowerPivot is not a new product so to speak, but rather it is a new capability for very powerful data analysis, and it impacts Excel, SharePoint, and SQL Server. PowerPivot is available as a standalone add-in to Excel, and is also available as a SharePoint service. This chapter explores PowerPivot for Excel.

Overview of PowerPivot

Business users, and in particular business analysts, need to be able to process ...

Get Microsoft SharePoint 2010 Business Intelligence Unleashed now with O’Reilly online learning.

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