In this chapter, we'll walk through the process of creating a basic Power View report. As we learned in the previous chapter, Power View reports can be created using Excel 2013 or directly through the browser when connected to a SharePoint site, which has the Reporting Services Add-in for SharePoint Products installed. In the following development activity, we will be leveraging the second option.
The development activity in this chapter is broken up into the following sections:
- Creating a BI Semantic Model (BISM) connection
- Opening the Power View design interface
- Creating bar charts
- Creating pie charts
- Creating column charts
- Adding a slicer
- Deploying reports to SharePoint
Before you start this exercise, you will require the following:
- Access to a server running SharePoint Server 2010 Enterprise Edition or SharePoint Server 2013 with the Reporting Services Add-in for SharePoint Products installed
- Access to a Microsoft SQL Server 2012 Analysis Services instance installed in tabular mode with the Adventure Works 2012 sample tabular database deployed
- A browser with Microsoft Silverlight 5 installed
Microsoft SharePoint Server 2013 is available in a 180-day trial version from the following location: http://technet.microsoft.com/en-us/evalcenter/hh973397.aspx
Microsoft SQL Server 2012 is available in a 180-day trial version (which includes SQL Server Data Tools) from the following location: http://www.microsoft.com/en-us/download/details.aspx?id=29066
Adventure Works DW 2012 sample database is available for download from the following location: http://msftdbprodsamples.codeplex.com/releases/view/55330