Specifications

204 CHAPTER 10 Self-Service Analysis with PowerPivot
Content Management
Content management for PowerPivot is quite simple because the data and the presentation
layout are kept in the same document. If they weren’t, you would have to maintain separate
les in different formats and then manually integrate them each time one of the les required
replacement with fresh data. By storing the PowerPivot workbooks in SharePoint, you can
reap the benets applicable to any content type, such as workows, retention policies, and
versioning. For example, you can copy data to a new location by copying the document. Or if
you need to formally approve data before allowing others to access it, you can easily set up a
document approval workow.
The PowerPivot Gallery
The PowerPivot Gallery is a special type of document library that provides document man-
agement capabilities for PowerPivot workbooks. You can use it to preview and open Power-
Pivot workbooks from a central location. In the PowerPivot Gallery, shown in Figure 10-13,
you can see all available sheets in the workbook as thumbnails with current data, without
opening the workbook. A snapshot service creates the thumbnail images by periodically
reading the workbooks le.
FIGURE 10-13 The PowerPivot Gallery
In addition to the default Gallery view, the PowerPivot Gallery also includes the Theater
and Carousel views, which are most useful when you want to highlight a small number of
workbooks. In Theater view, you can see a central preview area, and thumbnails of the other
reports in the workbook display at the bottom of the page. In Carousel view, the thumbnails
appear to the left and right of the preview area. In either of these views, you can click the left