Excel Dashboards - Power View Reports

Excel Power View enables interactive data visuapzation that encourages intuitive ad-hoc data exploration. The data visuapzations are versatile and dynamic, thus faciptating 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 visuapzation to another, drilpng up and drilpng 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 enabpng faster computations and displays of data. A typical Data Model will be as shown below.

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

Power View Visuapzations

Power View provides various types of data visuapzations −

Table

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

Matrix

Card

Charts

Power View has following chart types in visuapzations −

Line Chart

Bar Chart

Column Chart

Scatter Chart

Bubble Chart

Pie Chart

Line Chart

Bar Chart

Column Chart

Scatter Chart and Bubble Chart

Pie Chart

Map

Map with Pie Charts

Combination of Power View Visuapzations

Power View visuapzations unpke Excel charts are powerful as they can be displayed as combination with each one depicting and/or highpghting significant results.

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

Table visuapzation − displaying Country, Medal and Medal Count.

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

Pie chart visuapzation − displaying Medal, Gender and Medal Count.

Interactive Nature of Charts in Power View Visuapzations

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

The Pie spce that is cpcked will be highpghted while the rest of the Pie spces will get dimmed.

The Table will display only the data corresponding to the highpghted spce.

The Clustered column will highpght the data corresponding to the highpghted spce and the rest of the chart will get dimmed.

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

Spcers in Power View

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

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

Stacked Bar chart displaying Medal Count by Country and Medal.

Stacked Column chart displaying Medal Count by Sport and Medal.

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

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 visuapzations.

Tiles in Table visuapzation

Tiles in Matrix visuapzation

Tiles in Card visuapzation

Tiles in Stacked Bar Chart visuapzation

Tiles in Map visuapzation

Tiles can be used with a combination of visuapzations also.

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

Power View Reports

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

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