Chapter 13

Visual Analytics with Power View

What's in this chapter?

Introduction to Power View

Understanding the Power View architecture

Exploring, visualizing, and presenting with Power View

Configuring data source connections

Configuring PowerPivot for SharePoint

Installing Analysis Services in tabular mode

In Chapter 12 you learned how to use PowerPivot for Excel to create tabular models directly in an Excel workbook. In this chapter you learn how to interactively explore, visualize, and present data from workbooks and model databases in Power View.

Power View, a new feature of Reporting Services 2012, provides intuitive ad hoc reporting for business users such as data analysts, business decision makers, and information workers. Power View is a browser-based Silverlight application launched from SharePoint Server 2010 that enables users to present and share insights with others in their organization through interactive presentations. Data has much more impact when it comes from a well-understood, quality-assured source; is shared and available to the people who need it; and is presented in a format that helps people share and explore insights easily. This is what the self-service Microsoft BI platform is about, tightly integrated with Microsoft Office and SharePoint.

SharePoint facilitates building BI portals and dashboards that contain Reporting Services reports (both operational and Power View), Excel Services reports, data-alerting capabilities over reports, and PerformancePoint ...

Get Professional Microsoft SQL Server 2012 Reporting Services now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.