Microsoft’s Analysis Services product team (in the SQL Server division) has developed a product that provides self-service BI (Business Intelligence) functionality for users of Microsoft Office. This product is generally referred to as
PowerPivot, and it consists of both a client-side component (PowerPivot for Excel) and also a server side component (Power Pivot for SharePoint).
Looking for Power Pivot Help? Click below to find answers about PowerPivot:
Power Pivot for Excel Help on TechNet Library:
SQL Server 2012
SQL Server 2008 R2
PowerPivot for SharePoint Help on the TechNet Library
PowerPivot for Excel Resource Center on TechNet
In this article:
Watch this introduction video, part 3 in the series of PowerPivot Introduction Videos:
Power Pivot has four basic steps to what it offers:
Within the PowerPivot for Excel environment, you can bring data from virtually anywhere.
Easily organize, connect, and manipulate tables of large data sets.
Perform an in-depth analysis of your data, any way you want to slice it.
Use PowerPivot for SharePoint to share your workbooks across your team or publish them to the Web.
Power Pivot for Excel is an add-in for Microsoft Office Excel 2010 that is available as a free download from the Web at
http://powerpivot.com/. The idea is that Excel users can install this add-in and start using PowerPivot on a stand-alone basis. When users want to share the results of their work, they will publish their workbooks to SharePoint
servers that have the server side component installed.
PowerPivot for Excel supports self-service business intelligence in the following ways.
Power Pivot for SharePoint is an add-in for Microsoft SharePoint that is available as part of Microsoft SQL Server 2008 R2. When it is installed on top of SharePoint and used in conjunction with Excel
Services, it provides a platform for publishing and sharing PowerPivot workbooks.
In contrast with other large, corporate BI data sources that are limited in number and closely managed by database specialists, PowerPivot data is managed by services and infrastructure. At any given time, there might be tens or hundreds of PowerPivot workbooks
open in memory on application servers in the farm. The PowerPivot System Service tracks this activity, setting up new connections to data that is already loaded in memory, and caching or unloading data if it is no longer used or when there is contention for
system resources. Server health data and other usage data is gathered and presented in reports to give you insight into how well the system is performing.
For assistance and an explanation of setting up the architecture, view the PowerPivot for SharePoint Architecture videos.
Who is Power Pivot for?
↑ Return to Top
Diagrams and Posters
Community Blogs and Sites
Books and White Papers
Fantastic wiki page Ed! Great work
Just AMAZING ED, keep going !
What are the software requirements and dependencies for using PowerPivot for SharePoint? Do we need to have SharePoint Server also?
Very good page with great resources!
Great resources, Ed! Love the videos, too. Keep it up!
Thanks for the video series, Ed. Very helpful. Great work.
Nice. Thanks, Ed. Keep it up!
buenos videos gracias