Adding PowerPivot App to Business Intelligence Site in SharePoint 2013

This is part 4 and also last part of the series on creating a Business Intelligence Site on SharePoint 2013. We will focus on how to add PowerPivot app to the site. Please refer back to previous part if you have not gone through it yet.

From the Actions menu, select Add an app.

Click PowerPivot Gallery.

Enter the name as PowerPivot and click Create.

From the left hand side, click PowerPivot under Recent heading.

From Library Ribbon, click Library Settings.

Click List name, description and navigation.

Select Yes on Display this document library on the Quick Launch and click Save.

Go back to Main Business Intelligence entry page and you should have all the required apps now, something like below. You can start developing or uploading different PerformancePoint reports, PowerView reports, SSRS reports, PowerPivot Model and Excel Spreadsheet into this site.

This conclude the series of creating a Business Intelligence Site in SharePoint 2013.

Adding SSRS App to Business Intelligence Site in SharePoint 2013

This is part 4 of the series on creating a Business Intelligence Site on SharePoint 2013. We will focus on how to add SSRS app to the site. Please refer back to previous part if you have not gone through it yet.

From the Actions menu, select Add an app.

Click Document Library icon.

Click Advanced Options.

This is to add SSRS app to the site, so you can enter SSRS Reports as Name, put in some description. Select No for Document Version History and select None in the Document Template. Click Create.

Click Library Settings on the ribbon.

Click List name, description and navigation in the General Settings.

Select Yes for Display this document library on the Quick Launch and click Save.

Select Advanced Settings under General Settings heading.

Select Yes for Allow management of content types. Scroll to bottom and click Ok.

At the Content Types section, click Add from existing site content types link.

Select SQL Server Reporting Services Content Types from content types dropdown list. Select and add all content types. Click Ok.

Navigate back to SSRS report library and select Files from the ribbon. Click New Document, you will see three content types are now available.

Now you have SSRS app ready and we will look at PowerPivot next.

Adding Excel Services Apps to Business Intelligence Site in SharePoint 2013

This is part 3 of the series on creating a Business Intelligence Site on SharePoint 2013. We will focus on how to add Excel Services app to the site. Please refer back to previous part if you have not gone through it yet.

From the Actions menu, select Add an app.

Click Document Library icon.

Click Advanced Options.

This is to add Excel Services app to the site, so you can enter Excel as Name, put in some description. Select No for Document Version History and select Microsoft Excel Spreadsheet in the Document Template. Click Create.

From the Library ribbon, select Library Settings.

In General Settings, click on List name, description and navigation.

Select Yes at Display this document library on the Quick Launch and click Save.

If you return to the main Business Intelligence site, you can see Excel is shown on the Quick Launch at the right hand side.

We will look at adding Reporting Services (SSRS) apps next.