Team Performance Dashboard - beautiful presentation, good analysis and best use of excel features

Created by: dgranneman

About Dashboard:

This dashboard shows the team performance by sales per hour, revenue per hour, customer satisfaction, sales vs. hours, total sales, customer ratings, for regions & products.

The dashboard contains 6 interactive charts, 1 table & 2 slicers to display information to management.This dashboard has been developed with formulas.

The dashboard focuses on total transparency of performance by the team.

There are many ways in which you can visualize team performance data to understand the achievements by various teams. In October, ExcelForum team launched a dashboard competition in which you were asked to visualize sample data. The challenge has generated a huge thrill around the community and fetched 118 incredible entries.

Thanks everyone for participating and making this a huge learning experience for everyone. Excel Forum team has learned several useful dash board and charting tricks.

In this article, we will show you the steps on how to create this dashboard.

Let us see how the Dashboard made by Dirk Granneman looks:

img1

We have divided this dashboard into 9 sections of information. Let us take a look at each one separately.

Section1:

The header contains all the teams’related information. If we click on any one of them then that team will be highlighted &all the related information will get automatically interactive.

img2

Section2:

In this section, sales per hour is shown with two parameters,target & threshold,using speedometer chart.

img3

Section3:

The following picture shows the revenue per hour, by target & threshold.

img4

Section4:

The below picture shows customer satisfaction in percentage, by target & threshold.

img5

Section5:

This section covers Sales vs. Hours.

img6

Section 6:

This section covers total sales for the selected region & product.

img7

Section 7:

The following picture shows customer ratings with 4 parameters, as excellent, good, fair & poor using bar chart.

img8

Section 8:

This section shows information about top 10 & bottom 10 Sales rep chart per rev per hour, rev total, sales per hour & CSAT.

img9

Section 9:

This section is created using slicers, controlled by region & product. We can select any combination of region & product, and on the basis of the selection all related information gets updated dynamically.

img10

Using this dashboard we can get a clear view of the Team Performance;and thus we can get the information from various points of view.

Download Dashboard

Users are saying about us...

Leave a Reply

Your email address will not be published. Required fields are marked *

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Youtube