Excel Dashboards - Power View Reports



Excel Power View enables interactive data visualization that encourages intuitive ad-hoc data exploration. The data visualizations are versatile and dynamic, thus facilitating ease of data display with a single Power View report.

You can handle large data sets spanning several thousands of rows on the fly switching from one visualization to another, drilling up and drilling down the data and displaying the essence of the data.

Power View reports are based the Data Model that can be termed as the Power View Database and that optimizes the memory enabling faster computations and displays of data. A typical Data Model will be as shown below.

Power View

In this chapter, you will understand the salient features of Power View reports that you can incorporate in your dashboard.

Power View Visualizations

Power View provides various types of data visualizations −

Table

Table visualization is the simplest and default visualization. If you want to create any other visualization, first table will be created that you need to convert to the required visualization by Switch Visualization options.

Table

Matrix

Matrix

Card

Card

Charts

Power View has following chart types in visualizations −

  • Line Chart
  • Bar Chart
  • Column Chart
  • Scatter Chart
  • Bubble Chart
  • Pie Chart

Line Chart

Visualizing Line

Bar Chart

Visualizing Bar Chart

Column Chart

Visualizing Column Chart

Scatter Chart and Bubble Chart

Visualizing Scatter and Bubble Chart

Pie Chart

Visualizing Pie Chart

Map

Map

Map with Pie Charts

Map with Pie Chart

Combination of Power View Visualizations

Power View visualizations unlike Excel charts are powerful as they can be displayed as combination with each one depicting and/or highlighting significant results.

For example, you can have three visualizations in Power View −

  • Table visualization − displaying Country, Medal and Medal Count.

  • Stacked Column chart visualization − displaying Country, Gender and Medal Count.

  • Pie chart visualization − displaying Medal, Gender and Medal Count.

Combinational Charts

Interactive Nature of Charts in Power View Visualizations

Suppose you click on a Pie slice in the above Power View. You will observe the following −

  • The Pie slice that is clicked will be highlighted while the rest of the Pie slices will get dimmed.

  • The Table will display only the data corresponding to the highlighted slice.

  • The Clustered column will highlight the data corresponding to the highlighted slice and the rest of the chart will get dimmed.

Interactive Nature

This feature helps you to enable your audience viewing results from large data sets to explore the significant data points.

Slicers in Power View

You can use common Slicers in Power View to filter the data that is displayed by all the visualizations in Power View.

For example, in the following Power View, you have 2 visualizations −

  • Stacked Bar chart displaying Medal Count by Country and Medal.

  • Stacked Column chart displaying Medal Count by Sport and Medal.

Suppose you have two Slicers – one for Gender and one for Season, the data in both the charts will get filtered to the selected fields in the Slicers.

Slicer

Tiles in Power View

In Power View, Tiles help you to pick one data point of a field and view the corresponding values. Tiles can be used in Table, Matrix, Card, Stacked Bar chart and Map visualizations.

Tiles in Table visualization

Tiles in Table

Tiles in Matrix visualization

Tiles in Matrix

Tiles in Card visualization

Tiles in Card

Tiles in Stacked Bar Chart visualization

Tiles in Stacked Chart

Tiles in Map visualization

Tiles in Map

Tiles can be used with a combination of visualizations also.

Tiles with Visualization

You can use the interactive nature of the charts in such visualizations also.

Interactive Visualization

Power View Reports

You can produce aesthetic Power View reports that you can include in your dashboard.

Olympics

This could be done by choosing a suitable background, choosing the font, font size, color scales, etc.

Advertisements