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.