Part 3 of this Post is about Testing PowerPivot and Power View. PowerPivot is an Excel Add-on that allows us to create reports in Excel where we can use Slicers and later publish the excel sheet in SharePoint to view it in browser.

Let’s create a Business Intelligence Site collection to test Power Pivot.

Go to Central Administration à Create Site Collection

Provide Title, Url, Select Template as Business Intelligence and primary administrator and click OK.

Click on the site collection link to open.

Let’s see PowerPivot in Action

Click on Site Contents à Documents à Click on Excel Services Sample Workbook

Let’s change the Item to Charcoal from left top slicer of the sheet.

Now let’s click on 2011

Now Let’s Enable Power View

PV is a Site Collection feature that is provided by SQL Server Reporting Services to allow Rich and Powerful reports.

Click on Site Link using left top Global Navigation à Click on Site Settings Icon and Site Settings

Under Site Collection Administration Click on à Site Collection Features

Make sure Power View Integration Feature is activated.

Let’s Create a New Library to store our Reporting Services Reports

Click Site Contents à Add an App and Select document library and choose Document library. Select Advance Options. Set Name as “Reports” and Template to None and click Create.

Go to Library Settings à Advanced Settings à Set Yes for Allow Managed of Content Types and Click OK.

Click Add from Existing Content Types à Change Group to SQL Reporting Services à Add all the content types and click OK.

End of Part 3.  In the next post I will show you how to create a basic report using SQL Reporting services and Power View.