PowerPivot for Excel and SharePoint

4/14/2011

Contents

Introduction
A Brief History of PowerPivot
When Do I Use PowerPivot for Excel?
When Do I Use PowerPivot for SharePoint?
Getting Started
Enhancing and Analyzing the Data
Publishing to SharePoint
PowerPivot Gallery
Scheduling Data Refreshes
Monitoring with PowerPivot for SharePoint
Summary

PowerPivot Gallery

PowerPivot Gallery is a visually rich SharePoint document library installed with PowerPivot for SharePoint. Its enhanced visual presentation aids in interpreting the data in each sheet of PowerPivot workbooks in the Gallery, as shown in the following illustration.

Click to view larger image

Clicking a specific sheet in a PowerPivot workbook opens the workbook in the browser, where you can analyze it further, as shown in the following illustration.