Task 1: Performance Analysis of call centre agents (Nlaximurn 500 words applies only to interpretations and analysis section) 35 Marks Matrix enterprises design, manufactures, sell and support computer network equipment. They have successfully entered the European market using UK as the headquarters. In the enterprise network market. it has a network of 40 distributors across UK, Germany. France and Spain. annually selling 10.000 network switches to business customers. It has also built up a small business. home use market and is selling 500.000 SOHO routers and repeaters annually through retail and direct channels in the UK. In the retail channels(similar to Tesco, PC World), the first line support related to sales and return is managed bythe retailers. Matrix provides support on technical issues. With the direct channels (similar to eBay, Amazon and own web shop), Matrix provides all the support to customer interactions. You have been presented with a dataset containing information aboutthe calls handled by call centre agents in one month. The call centre receives the call from customers who then either resolve them or divert to sales team or technical support. Each call has been allocated a specific Issue code and resolution code. Worksheet titled Glossary has further information about the codes. a} Your task is to analyse the dataset and make interpretations on the performance of the call centre agents and develop a summary report to the management highlighting the conclusions you can draw from the analysis. Data analysis should be undertaken by calculating the following statistic indicators (at least) for each agent based on the number of calls they handled. 0 Mean Standard Error Median Mode Standard Deviation Sample Variance Kurtosis Skewness Range Minimum Maximum Sum Count 000000000000 Apart from the above, pivot tables, histograms and other relevant charts should be used. Analysis of the data should help you to answer questions like... 1. Which call centre agent is the best and least performing and why you think so? 2. Can we see any patterns l trends in the number of calls handled by the call centre? E.g. Easter _ . What can we understand from the contextual information such as type of calls. customer number. date, time etc? . Are there any problems 4' issues faced by the organization that can be identied? E.g. lot of queries around product failures? C13 X V fx A B C D E F G 1 Issue Code Issue Resolution Code Resolution Resolution Code Resolution 2 ACC Account query ACCORD Check acount record FIN Raise Finance Query 3 CAN Cancellation CANCEL Cancelled Order SUB Subsitute with otherproduct 4 DEAD Product died TC Pass to Technical Support DEL Delivery enquiry DELI Check delivery record 6 DOA Dead on Arrival BSPT Go through boot script RETN Arrange return MIS Missing items PSPT Go through packing list RETN Arrange return ORD Order query ORDER Check order record SALES Pass to Sales Team 9 PAY Payment query ACCORD Check acount record FIN Raise Finance Query 10 PROD Product query PTREE Go through Product Selection Tre TC Pass to Technical Support 11 SET Setup problem SSPT Go through setup script TC Pass to Technical Support 12 UNEX Unexplained probl FOLL Set up follow up action 13 14 15 16