In this article we can explore.
Install SQL Server BI Edition
There are different editions of SQL Server. We need to choose the Business Intelligence one.
You can install this on the same machine where SharePoint & SQL Server already exists.
Following is the Download link if you have MSDN Subscription. It is around 3GB.
Choose the Installation > New SQL Server option
Pass through the upcoming wizard.
PowerPivot Configuration Tool
Now you can run the PowerPivot for SharePoint 2013 Configuration. This tool will configure the required service applications, services & site templates for PowerPivot.
You should be logged in as Farm Administrator to the machine.
You will get the tool loaded like below.
In the appearing page enter the core details:
1. Farm Account
2. Power Pivot Instance Name
Click Validate & then run button to complete the operations.
Go to Central Administration & Create a new site collection. You should be able to choose the PowerPivot template as shown below.
Enter the User Name & Click Ok to create the site collection.
Once the site collection is created you can open it in Browser.
In the new site collection you can open the library named PowerPivot Gallery. This is the core library used for BI.
You can configure following advanced content types for the library.
If you already have Analysis Server & Cube created you can create a new Report Data Source object to create a Report within the browser.
You can enter the details shown below.
You can choose the Farm Account & Use as Windows credential option.
Once the connection is successful you will see the new item as shown below.
You can try clicking on the item & use Report Builder within the browser itself.
This confirms our PowerPivot installation for SharePoint 2013.
In this article we have explored how to configure PowerPivot Site Collection in SharePoint 2013.