Team Performance Dashboard - Good use of excel slicers and excel charts

Created by: colaps

About Dashboard:

This dashboard shows the team performance by team members, product, region, ranking and ratings.

The dashboard focuses on performance of the team in terms of total transparency&the team is working to measure both soft and hard performance factors as well as indicating areas that are deteriorating and improving month-on-month.

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 dashboard 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 Colaps looks:

img1

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

Section1:

The below chart will update the viewer on how the team sales/region & team sales/product is performing.

img2

This chart can be filtered using slicer for region, team & product. You can view any sort of combination of these slicers &the chart will get updated dynamically.

Let’s say we select Alabama & Florida from Region, Team C, D & G and Product 1,the slicer will filter by each selected item & update the chart automatically.

img3

Section2:

In this section, Top 10 team performance members are shown by sum of calls & sum of revenue for the selected product.

img4

There are two products listed &after selecting any one of them, the chart will be instantly updated.

Let’s say we select Product 2, then all the related information will be updated automatically.

img5

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

Download Dashboard

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