Overview of PowerPivot documentation (SharePoint Server 2010)


Applies to: SharePoint Server 2010

This article maps to articles to show you how to plan, configure, and maintain Microsoft SQL Server 2008 R2 PowerPivot for Microsoft Excel 2010 and PowerPivot for SharePoint 2010. The name PowerPivot refers to a collection of applications and services that provide an end-to-end approach for creating data-driven, user-managed business intelligence solutions in Microsoft Excel workbooks. PowerPivot client and server applications support self-service business intelligence that puts powerful analytics within your reach, enabling you to find better information and insight into the numbers that drive decisions, objectives, and initiatives throughout the organization. The following is a brief description of PowerPivot components for Microsoft Office.

  • PowerPivot for Excel 2010 is an add-in to Excel that provides tools for adding and integrating large amounts of data in Excel workbooks.

  • PowerPivot for SharePoint 2010 extends SharePoint 2010 Products and Excel Services to add server-side processing, collaboration, and document management support for the PowerPivot workbooks that you publish to SharePoint 2010 Products.

Overview of PowerPivot for Excel and SharePoint

PowerPivot integrates with Excel and SharePoint 2010 Products. In an Excel environment, PowerPivot for Excel provides a familiar authoring and analytical experience on the workstation. In a SharePoint 2010 Products farm, PowerPivot for SharePoint is the set of server-side applications, services, and features that support team collaboration on business intelligence data.

The following articles provide more detail about PowerPivot features.

Planning and architecture for PowerPivot in SharePoint and Excel Services

The following articles help you understand PowerPivot and how to plan implementation.

Deployment for PowerPivot in Excel Services and SharePoint 2010 Products

Deploying an instance of PowerPivot for SharePoint 2010 consists of installation and configuration tasks that result in an operational server that is immediately available to users in your organization. The following articles give detailed instructions for deploying PowerPivot for SharePoint.