Book Image

Reporting with Microsoft SQL Server 2012

Book Image

Reporting with Microsoft SQL Server 2012

Overview of this book

Table of Contents (12 chapters)

Chapter 5. Development Activity with Power View

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