Getting started with PowerPivot for Excel in SharePoint 2010

PowerPivot (previously known as Project Gemini) is a Microsoft’s business intelligence (BI) solution, allowing business management and decision makers to collect and present business data in Excel or web based via SharePoint.  Many business executives have the capability to harness PowerPivot for Excel 2010 or SharePoint 2010 as they already either have the platforms in place or are a few steps away in getting this state-of-the-art BI solution by Microsoft.

PowerPivot consists of a client add-in for Excel 2010 called ‘PowerPivot for Excel’ and a server component called ‘PowerPivot for SharePoint 2010’. PowerPivot for Excel is an Add-in for Excel 2010 that helps you manage and report on business data from multiple sources with a minimum assistance from your IT guys.

PowerPivot for SharePoint 2010 enables data manipulation of Excel Services in SharePoint 2010. Since its web based, it is easier to share and allow for collaboration through powerful dashboards and reports. With SharePoint, you can control security, choose from multiple data sources – internal, corporate or public.

According to Microsoft, PowerPivot for SharePoint is nothing but SQL Server 2008 R2 Analysis Services running in ‘Vertipaq’ mode within SharePoint 2010. Vertipaq is a fast data manipulation, in-memory technology. SharePoint users are able to view and use models through Sharepoint, but PowerPivot for Excel is required to edit PowerPivot models which are hosted in SharePoint.

PowerPivot for Excel itself does not depend on SharePoint 2010. It only requires Excel 2010 and not earlier versions.
PowerPivot for SharePoint 2010 requires both SQL Server 2008 R2 and SharePoint 2010.

Here are a list of links that are helpful to get you started with PowerPivot

FOR BUSINESS USERS (Executives, Managers & Decision makers):

Microsoft PowerPivot (Business Intelligence) site – Information, videos and datasheets:
http://www.microsoft.com/en-us/bi/powerpivot.aspx

Top 10 reasons to try PowerPivot for Excel 2010:
http://office.microsoft.com/en-us/excel/top-10-reasons-to-try-powerpivot-for-excel-2010-HA101810443.aspx

What is PowerPivot:
http://www.powerpivotpro.com/what-is-powerpivot

PowerPivot for SharePoint 2010 – The Business User’s Perspective:
http://blogs.office.com/b/microsoft-excel/archive/2009/10/29/powerpivot-for-sharepoint-2010-the-business-user-s-perspective.aspx

Microsoft SQL Server 2008 R2 – PowerPivot for Microsoft Excel 2010 Download:
http://www.microsoft.com/download/en/details.aspx?displaylang=en&id=7609

 

FOR SHAREPOINT ADMINS:

Hardware and Software Requirements (PowerPivot for SharePoint):
http://msdn.microsoft.com/en-us/library/ee210640.aspx

Installation (PowerPivot for SharePoint):
http://msdn.microsoft.com/en-us/library/ee210654.aspx

Configuration (PowerPivot for SharePoint):
http://msdn.microsoft.com/en-us/library/ee210609.aspx

SQL Server PowerPivot for SharePoint forum:
http://social.msdn.microsoft.com/Forums/en-US/sqlkjpowerpointforsharepoint

FOR SHAREPOINT DEVELOPERS/ADMINS:

Data Sources Supported in PowerPivot Workbooks:
http://technet.microsoft.com/en-us/library/ee835543.aspx

Add Data to Your PowerPivot Workbook (Sample Data):
http://powerpivotsdr.codeplex.com/releases/view/46355

Create Your First PowerPivot Workbook (Tutorial):
http://technet.microsoft.com/en-us/library/ee835510.aspx

Microsoft PowerPivot for Excel 2010 Samples:
http://www.microsoft.com/download/en/details.aspx?id=102

 

Leave a Reply

Your email address will not be published. Required fields are marked *