Description
In this lab, you will explore SQL Server 2012 Reporting Services Power View. Power View is a Web browser-based report authoring tool targeted at everyone to enable them to create compelling, interactive and rich data visualizations based on Tabular BI Semantic Models. You will create a report based on a PowerPivot workbook published to a PowerPivot Gallery, and this report will consist of three different, yet related, interactive data exploration experiences. You will explore the model data using the tables, column and bar charts, and an animated scatter chart.
Overview
In this lab, you will explore Power View. Power View is a Web browser-based report authoring tool targeted at everyone to enable them to create compelling, interactive and rich data visualizations based on Tabular BI Semantic Models.
You will create a report based on a PowerPivot workbook published to a PowerPivot Gallery, and this report will consist of three different, yet related, interactive data exploration experiences. You will explore the model data using the tables, column and bar charts, and an animated scatter chart.
The completed report definition (.rdlx file) is available in the End folder of this lab.
Objectives
The objectives of this lab are to:
- Use the PowerPivot Gallery to create a Power View report
- Become familiar with the Power View designer
- Create a visually compelling Power View report based on various visualization types
- Save the Power View report to a document library
- Export the Power View report to PowerPoint
- Browse to, and interact with, the Power View report
System Requirements
You must have installed the following items to complete this lab:
- Microsoft SQL Server 2012:
- Database Engine
- Reporting Services (SharePoint integration mode)
- SharePoint Server 2010
- SQL Server 2012 Reporting Services Add-in for SharePoint
- SQL Server 2012 PowerPivot Add-in for SharePoint
- Silverlight
Setup
Task 1 – Creating a Site Collection
- To open Central Administration, click the Start button, and then select All Programs | Microsoft SharePoint 2010 Products | SharePoint 2010 Central Administration.
- Login using Administrator credentials, if required.
- Click Application Management.
- Click Create Site Collections.
- Configure the new site collection based on the following table.
Title |
TailspinToysBI |
URL |
/sites/TailspinToysBI |
Template |
Enterprise | Business Intelligence Center |
Primary Site Collection Administrator |
<Administrator username> |
Task 2 – Activating PowerPivot Feature
- In the Top-Level Site Successfully Created page, click the URL for the newly created Site Collection.
- In the new Site Collection, click Site Actions, and select Site Settings.
- Click Site Collection Features in the Site Collection Administration section.
- Click Activate for the PowerPivot Feature Integration for Site Collections feature.
Task 3 – Creating a PowerPivot Gallery
- Click TailspinToysBI above the Quick Launch.
- Click Site Actions, and select More Options.
- In the search box at the right upper corner, type “PowerPivot” and press Enter.
- Select the PowerPivot Gallery item, and click More Options.
- Type PowerPivot Gallery in the Name field.
- Check that the Yes radio button in the Display this list on the Quick Launch option is selected.
- Click Create.
- Close the Internet Explorer Window.
Task 3 – Creating an IIS Web Site
- To open Internet Information Services, click the Start button, and then select All Programs | Administrative Tools | Internet Information Services (IIS) Manager.
- Right-click Sites node and select Add Web Site.
- Configure the new Web Site based on the following table:
Site name |
TailspinToysIntranet |
Physical path |
<HoL path>\Source\Assets\TailspinToysIntranet |
Binding type |
http |
IP address |
All Unassigned |
Port |
11111 |
- Double-click TailspinToysIntranet site node.
- Select the ProductImages folder.
- In the IIS section, double-click Directory Browsing.
- On the Actions panel at the right, click Enable.
- Close the Internet Information Services (IIS) Manager.
- Browse to the Source\Assets folder.
- Right-click the TailspinToysIntranet folder and click Properties.
- Click the Security tab and click Edit.
- Click Add.
- Type Everyone and press Enter.
- Click the Full Control checkbox in the Allow column for the Everyone group, and click OK until you close all dialogs.
Cleanup
- There is no need to cleanup if you intend to continue the sequence of labs in this training kit.
Task 1 – Deleting the TailspinToysBI Site Collection
- To open Central Administration, click the Start button, and then select All Programs | Microsoft SharePoint 2010 Products | SharePoint 2010 Central Administration.
- Login using Administrator credentials, if required.
- Click Application Management.
- Click Delete a Site Collection.
- Click No Selection and select Change Site Collection.
- Click the TailspinToysBI Site Collection, and click OK.
- Click Delete.
- Click OK to confirm the deletion of the Site Collection.
Task 2 – Deleting the TailspinToysBI IIS Web Site
- To open IIS Manager, click the Start button, and then select All Programs | Administrative Tools | Internet Information Services (IIS) Manager.
- Expand the server node, and then expand the sites node.
- Right-click the TailspinToysIntranet site and select Remove.
- Click Yes to confirm the deletion of the web site.
- Close IIS.
Feedback
Your feedback is welcome! Please, post it on our UserVoice forums.
Exercises
This lab comprises the following exercises:
- Exploring the Power View Design Environment
- Creating and Interacting with the Power View Report
Author
This lab was designed and written by Peter Myers of SolidQ.
Estimated time to complete this lab: 30 minutes