how can i analyse this data(below)

Customer Service Complaints Data Analysis

Analyse your data findings-

No. of complaints for each representative

impact will this data have on your company

Strategies to improve Customer Satisfaction

List at least 4-5 strategies to improve customer satisfaction

Conclusion

Evaluation of current customer service in the company - positive and negative

Recommendation on how to improve (provide at least 2-3 recommendations)

Scenario- Bounce fitness customer satisfaction data- 12 months

Bounce fitness has compiled statistics gathered over a period of 12 months on customer complaints. You have been asked by your manager to review the data based on your team's customer service skills. After you have analysed the data provided below, you are to follow the steps to demonstrate your skills in writing complex documents.

The following code is to indicate the focus of the customer complaint that has been recorded. K, R & B indicate the complaint was caused by the relevant staff; P indicates the complaint is caused by a product; S indicates the complaint is caused by service. Code for staff: K = Karen, R = Rafiq, B = Beata

Customer Service Complaints Data

Week	Mon	Tue	Wed	Thu	Fri	Sat	Sun
1	S		P		K		B
2	P, B			S	P		P, K
3	R	B	P, B		S	P	P
4	B, P	S		P			P
5			P	S	P, K
6		P	B		P	B	K
7	R	B, B			S	P, B	B
8			S		K
9		P	R
10	R			S			K
11	P, B	S	B	P	R	P, S, B
12		P			K
13			R, S			P
14	S		K		P
15	B	P, B					P, B
16	S
17			P	R
18				S		P
19	P	B, R	S, B		P		P, B
20	B	P
21			K		S
22		R				P, B
23	R		S				K
24	P		B, S	P			B
25				K
26		R, S
27				R		P, B
28	B	B, P	P		K	B
29							S, B
30	P, B		K
31			R, B
32	B	P, B					S, B
33					S, P		K
34		S
35				R
36	S, B	P	B				B
37			P			K
38		R
39				S	R
40	B, S	S		K		B, P
41			P, B
42							S, B
43					P
44	P, B	B		S			B
45					K		P, S
46			K	R, P		S, B
47	S, B
48	P		S, B			B, B
49					R
50	R		P, B				K
51		S, B				P
52	P, B		R	K	S, P	B	B

bounce fitness No. of Description Code complaints Service S 24 Product P 48 Beata b 26 Karen K 22 Rafiq 20 otal no.of complaint 140 Draft_Complaints data workbook_VO1 140 120 100 80 60 40 20 Service Product Beata Karen Rafiq Total no.of complaints Code No. of complaints