img2

Team Performance – good analysis using excel charts

Created by: ikarahma

 

About Dashboard:

Team Performance dashboard: – It is used for analyzing the team’s performance. By using the team’sperformance dashboard we can get an idea about how our team is performing and where we need improvement.

By using the team performance dashboard we can see the performance at each and every parameter. We can identify and analyze the weak and strong work areas of every team member and accordingly we can improve the use of resources.

Also we can plan for future targets on the basis of team performance analysis.

Let’s understand about this dashboard shown below:-

img1

Chart to show the Login hours, talk time, and hold on the basis of Categories.

img2

In the above shown chart, there are 4 drop downs available. 1st is to select the region, 2nd is to select the product, 3rd is to select the team and 4th is to select the team member.In this chart we can analyze the total login hours, total talk time and total hold time of every team and of every individual.

Chart to compare the total sales and Sales per hour.

img3
In the above shown chart, there are 4 drop downs available. 1st is to select the region, 2nd is to select the product, 3rd is to select the team and 4th is to select the team member.

In this chart we can analyze the total sales and sales per hour for every team and for every individuals. Accordingly we can analyze that how a team is performing and how much potential an individual possesses

Chart to compare the total sales and Sales per hour.

img4
In the above shown chart, there are 4 drop downs available. 1st is to select the region, 2nd is to select the product, 3rd is to select the team and 4th is to select the team member.

In this chart we can analyze the calls; how many calls are there product wise.

Chart For analyze the CSAT%

img5
In the above shown chart, there are 4 drop downs available. 1st is to select the region, 2nd is to select the product, 3rd is to select the team and 4th is to select the team member.

In this chart we can analyze the CSAT% for every team and individual consultants as well. We can put the filter for products, region and then we can see the performance accordingly.

Chart to analyze the CSAT%

img6

In the above shown chart, there are 4 drop downs available. 1st is to select the region, 2nd is to select the product, 3rd is to select the team and 4th is to select the team member.

In this chart we can analyze the CSAT% for every team and individual consultants as well we can put filters for products, region and then we can see the performance accordingly.

Chart For analyze the Revenue

img7

In the above shown chart, there are 4 drop downs available. 1st is to select the region, 2nd is to select the product, 3rd is to select the team and 4th is to select the team member.

In this chart we can analyze the total revenue generated by every team and individual consultants.

Chart For analyze the Calls Grading

img8

In the above shown chart, there are 4 drop downs available. 1st is to select the region, 2nd is to select the product, 3rd is to select the team and 4th is to select the team member.

In this chart we can analyze the Calls grading for every region and product for every team and individual by selecting the criteria from the drop down list.

Download Dashboard

Leave a Reply

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

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

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 Google PlusVisit Us On Youtube