Microsoft’s Analysis Services product team (in the SQL Server division) has developed a new 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 (PowerPivot for SharePoint). Looking for PowerPivot Help? Click below to find answers about PowerPivot:
PowerPivot 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:
PowerPivot 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.
PowerPivot 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.
PowerPivot 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 PowerPivot for?
↑ Return to Top
Videos
SharePoint:
Excel:
Help Documentation
White Papers
Diagrams and Posters
Official Sites
Community Blogs and Sites
Books and White Papers
Richard Mueller edited Revision 135. Comment: Added "See Also" to the TOC
Craig Lussier edited Revision 131. Comment: added en-US to tags and title
Pantelis44999 edited Revision 127. Comment: Removed Table of contents, noticed it was present further down.
Pantelis44999 edited Revision 126. Comment: Added Table of Contents
Ed Price - MSFT edited Revision 124. Comment: Updated the Help links
Ed Price MSFT edited Revision 84. Comment: Updated links.
Ed Price MSFT edited Revision 83. Comment: Added link to "PowerPivot Glossary."
Ed Price MSFT edited Revision 82. Comment: Minor title update.
Ed Price MSFT edited Revision 75. Comment: Formatting the lists at the bottom. Part 2.
Ed Price MSFT edited Revision 74. Comment: Formatting the lists at the bottom.
Ed Price MSFT edited Revision 1. Comment: Updated link.
Ed Price MSFT edited Revision 2. Comment: Minor edits.
Ed Price MSFT edited Revision 4. Comment: Added image.
Ed Price MSFT edited Revision 5. Comment: Minor edit.
Ed Price MSFT edited Revision 6. Comment: Added the External Links section at the bottom.
Ed Price MSFT edited Revision 7. Comment: Minor edit.
Ed Price MSFT edited Revision 8. Comment: Clarified what PowerPivot does a little.
Ed Price MSFT edited Revision 10. Comment: Added a video, more info, and another External Link.
Ed Price MSFT edited Revision 11. Comment: Added a "See Also" link.
Ed Price MSFT edited Revision 12. Comment: Added the "PowerPivot Wiki Pages" link.
Ed Price MSFT edited Revision 14. Comment: Added videos link.
Ed Price MSFT edited Revision 15. Comment: Added link to PowerPivot-info
Ed Price MSFT edited Revision 16. Comment: Added installation page link.
Ed Price MSFT edited Revision 17. Comment: Fixed link.
Ed Price MSFT edited Revision 18. Comment: Added link to Import Linked Data topic