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 axis. A stacked bar chart shows the relationship of individual items to the whole.

100% Stacked Bar Chart

Categories are usually organized along the vertical axis and with values along the horizontal axis. This compares the percentage that each value contributes to a total across categories.

Clustered Bar Chart

Categories are usually organized along the vertical axis and with values along the horizontal axis. The compares values across categories.

Stacked Column Chart

Categories are usually organized along the horizontal axis and with values along the vertical axis. This shows the relationship of individual items to the whole.

100% Stacked Column Chart

Categories are usually organized along the horizontal axis and with values along the vertical axis. This compares the percentage that each value contributes to a total across categories.

Clustered Column Chart

Categories are usually organized along the horizontal axis and with values along the vertical axis. This compares values across categories.

Scatter Chart

The horizontal axis displays one numeric field and the vertical axis displays another, which makes it easy to see the relationship that exists between the two values for all items in the chart. It provides a play button feature to enable viewing how data changes over time. It is also called bubble chart.

Line Chart

It has only one value axis (called the vertical axis), and the horizontal axis only shows evenly spaced groupings, or categories, of data. Category data is spread evenly along a category (horizontal) axis and distributes all numerical value data along a value (vertical) axis.

Pie Chart

This is a circular chart divided into sectors that illustrate numerical proportion. Pie charts can be rather sophisticated by allowing you to drill down when you double-click on a slice, or they can show sub-slices within the larger color slices. It also has the ability to cross-filter a pie chart with another chart.

Map

Map displays your data in the context of geography using Bing map files. You can zoom as well as pan just as you would with any other Bing map. The data is plotted using geographical elements such as latitude and longitude.

Tiles

Tiles convert a matrix or table to present tabular data interactively. There will be a dynamic navigation strip that uses text or images for each tile. Clicking on a tile filters the data.

Multiples

This creates a series of charts that have identical x and y axes and arrange them side by side to make it easy to compare different values at the same time. They are also called trellis charts.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.116.36.194