Installation steps for PowerPivot

Infrastructure

Firstly my SharePoint 2010 farm consists of 3 SP Servers and 2 SQL Servers in the following configuration
1 x SP2010 App Server
2 x SP Web Front End Servers
2 x SQL 2008 R2 Server in a failover cluster

Installation

You need to have SQL Server 2008 R2 to install PowerPivot and this process assumes you already have SharePoint 2010 setup and therefore a functioning installation of SQL 2008 R2
Log into the SharePoint 2010 central admin server as a farm administrator
Insert the SQL setup disk and run the setup.exe file
Click the Installation option on the left had side and then select New installation or add features to an existing installation

Let the install run through setting up any product key, licence acceptance and support files screens
At the Setup Role screen select SQL Server PowerPivot for SharePoint and select your existing farm installation and click Next

Click Next on the Feature Selection screen (this is read only and for information only)
Setup will now run a rule check, if you get any errors you need to resolve these before you can continue

Name the instance of SQL and select a location to install to and click Next

Check the installation locations and click Next

Select an account to run the Analysis Services and click Next

At the next screen select users who you want to have administrative privileges to analysis services and also check the locations for the data directories and click Next

Click Next on the Error Reporting screen
Setup will run another rule check, correct any errors and click Next
On the summary screen click Install

You may need to restart the computer after the installation but apart from that its all done

Deploy SharePoint PowerPivot Solutions

There are 2 solutions associated with PowerPivot
In central admin navigate to System settings | Manage Farm Solutions

The powerpivotfarm.wsp file is automatically deployed to the farm and doesn’t need to be touched
The powerpivotwebapp.wsp is deployed to the central admin server but you will need to deploy this to any web application that you want to use PowerPivot

Required Services

For PowerPivot to work you need to have the following services running

• Excel Calculation Services
• Secure Store Service
• Claims to Windows token Service

To start these services navigate to System Settings | Manage Services on Server

Check the services are started and if not click on Start

PowerPivot Service Application

You now need to create a PowerPivot service application to do this navigate to Application Management | Manage Service Applications and click New from the ribbon

Select the SQL Server PowerPivot Service Application

In the window enter the details required for name etc and click OK
After a while you should see this

Excel Services

Firstly check to see if you have Excel Services enabled by seeing if it is listed in the Service Applications section of central admin
If not then you will need to enable it
To enable Excel Services follow the steps above but select Excel Service Application

From this window enter the details for the application and click OK
Once the setup has completed it should be listed as below

Secure Store

Start the Secure Store Service from the Manage Services screen
Navigate to Application Management | Manage Service Applications
If there is no listing for a secure store then click on New and select Secure Store Service
Complete all the details and click OK
After a while you will get a confirmation screen, click OK
Scroll down the screen and click on the Secure Store Service Application and click on Manage

Click on Generate New Key and complete the details
You now have a Secure Store Service setup

Enable PowerPivot For Site

Navigate to the site you want to enable PowerPivot for and go to Site Settings
In site settings open Site Collection Features and active the feature

You can check that the feature is enabled by going to Site Actions | More Options

In the libraries section there should be some PowerPivot items