Team Performance - good analysis using excel charts

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:-

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

In the above shown chart, there are 4 drop downs available. 1^st is to select the region, 2^nd is to select the product, 3^rd is to select the team and 4^th 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.

In the above shown chart, there are 4 drop downs available. 1^st is to select the region, 2^nd is to select the product, 3^rd is to select the team and 4^th 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.

In the above shown chart, there are 4 drop downs available. 1^st is to select the region, 2^nd is to select the product, 3^rd is to select the team and 4^th 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%

In the above shown chart, there are 4 drop downs available. 1^st is to select the region, 2^nd is to select the product, 3^rd is to select the team and 4^th 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%

In the above shown chart, there are 4 drop downs available. 1^st is to select the region, 2^nd is to select the product, 3^rd is to select the team and 4^th 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

In the above shown chart, there are 4 drop downs available. 1^st is to select the region, 2^nd is to select the product, 3^rd is to select the team and 4^th 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

In the above shown chart, there are 4 drop downs available. 1^st is to select the region, 2^nd is to select the product, 3^rd is to select the team and 4^th 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