Overview of PowerPivot documentation (SharePoint Server 2010)

SharePoint 2010

Applies to: SharePoint Server 2010

Topic Last Modified: 2011-08-05

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.

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.

  • PowerPivot Overview (http://go.microsoft.com/fwlink/p/?LinkId=190359)   Further explains what PowerPivot for Excel 2010 and PowerPivot for SharePoint 2010 are, shows a diagram that illustrates how a request for query processing moves through the farm, and explains who should use PowerPivot.

  • PowerPivot Features (http://go.microsoft.com/fwlink/p/?LinkId=190360)    Gives an in-depth description of features for PowerPivot for Excel 2010 and PowerPivot for SharePoint 2010.

  • PowerPivot Concepts (http://go.microsoft.com/fwlink/p/?LinkId=190361)   Explains the major concepts of PowerPivot for Excel 2010 and PowerPivot for SharePoint 2010.

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

  • Plan a PowerPivot Deployment in a SharePoint Farm (http://go.microsoft.com/fwlink/p/?LinkId=190362)   Gives considerations and architecture to add PowerPivot to stand-alone server and to a server farm.

  • Plan for PowerPivot Integration with Excel Services (http://go.microsoft.com/fwlink/p/?LinkId=190363)   Explains how the server systems work together, how connections are established, and describes configuration settings that enable seamless interaction.

  • Plan for PowerPivot Integration with Reporting Services (http://go.microsoft.com/fwlink/p/?LinkId=190365) Tells how you can build Reporting Services reports as a way to visualize PowerPivot data. Reporting Services offers rich data visualization through charts and maps, additional rendering formats, and comprehensive subscription and delivery options.

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.

  • Hardware and Software Requirements (PowerPivot for SharePoint) (http://go.microsoft.com/fwlink/p/?LinkId=190366)   Gives details for hardware and software for the client workstation, server installation, Excel Services, and SharePoint 2010 Products.

  • Installation (PowerPivot for SharePoint) (http://go.microsoft.com/fwlink/p/?LinkId=190367)   Links to considerations for installation and "how-to" articles for installing PowerPivot in various ways. The articles include information about how to scale out PowerPivot for SharePoint 2010 Products and OLE DB and ADOMD.NET.

  • Default Configuration for PowerPivot for SharePoint (http://go.microsoft.com/fwlink/p/?LinkId=190368)   Explains installation procedures for the default configuration for PowerPivot for SharePoint 2010.

  • Configure PowerPivot for SharePoint (http://go.microsoft.com/fwlink/p/?LinkId=190369)   Links to "how-to" articles for configuring PowerPivot for SharePoint 2010.