Power View and Reporting Services - Learning SQL Server Reporting Services 2012 - page 336

Creating a Power View
In the previous section, we have seen how we can create a tabular model using SSAS
2012 based on a Northwind database in SQL Server 2012 using SQL Server Data
Tools. In the following we will connect to this model from SharePoint Server 2010
and then create a Power View report.

In this section a number of features are described that the reader should be able
to carry out using the steps as a guide. It is possible that the reader may be using
a different BISM data source but the concept is the same. The different features
described here are:

• Multiple views and view navigation
• Interactive highlighting
• Interactive filtering and sorting
• Visualization as a card
• Tiles visualization
• Slicers
• Filtering and advanced filtering
• Scatter and bubble charts
• View navigation
• Save, do, undo, and refresh

Hands-on exercise 6.4 - connecting to the
model from SharePoint Server 2010
There are a couple of ways of connecting to the data on the analysis services server
and here we look at one of them:

1. Bring up IE 9.0 with administrative rights and connect to the HodentekWin7

site (not the administrative site) as shown in the following screenshot: