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)

Data visualizations


Before getting into how to create a report in Power View, it is a good idea to go over the types of reports that you can create. The following table describes the different charts and visualizations that are available to you in Power View to create reports. For examples of what each chart looks like, check out http://bit.ly/NKFmTd.

Visualization

Description

Table

A table is simply made up of rows and columns. For each visualization that you want to create, you will start first with creating a table. Then you can convert the table to any other visualizations.

Matrix

A matrix is similar to a table, but it can be collapsed and expanded by rows and/or columns. It can display totals and subtotals by row and column and can drill up and down a hierarchy.

Card

A card provides an index card style layout that includes text and data values as well as images.

Stacked Bar Chart

Categories are usually organized along the vertical axis and with values along the horizontal...