This dashboard shows the team’s performance on the basis of team members, product, region and time.
The dashboard contains 3 interactive data tables, 8 interactive charts and 1 static chart to display the management information.
The main objective of this dashboard is to provide key information in one place and see how it is tracking against the key criterions, like performance by region, revenue by team, sales by team, sales by product, revenue by product, etc.
The team’s performance uniquely measures both soft and hard performance factors and helps to drive continuous and curative parameters.
There are many ways in which you can visualize team’s performance data to understand the achievements by various teams. In the month of October, Excel Forum team has launched a dashboard competing in which you are asked to visualize team’s performance data using sample data. The challenge has generated a huge thrill around the community and has fetched 118 incredible entries.
Thanks everyone for participating and making ita 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 to create this dashboard.
Let us see the how Dashboard made by Smallman looks:
We have divided this dashboard into 5 sections of information. Let us take a look at each one separately.
This section is the heart of this dashboard by Smallman. The slicer technique is used to filter all the regions individually; the viewerneeds to select the region & all the related information will be updated dynamically.
In this section, we will take a look at left portion of the dashboard screen that is displaying details of team performance by revenue, revenue per hour, sales & sales per hour.
This section highlights team login hours, talk time, hold time & inactive %.
This section covers team calls, positive, negative & all feedback.
This section provides the revenue-related information for all or selected regions.
This section provides login hours by region & team wise.
This section focuses on talk time information by region & team wise.
In this section, feedback for team performance, whether positive or negative, is shown region wise.
This section highlights sales data by region, for all the teams.
The last section covers the right portion of the dashboard screen, which highlights sales by product, revenue by product for all regions & revenue generated in % by all products.
Using this dashboard,we can get a clear view of the Team Performance,and we can get the information from various points of view.
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.