Research and Analysis Report

Please read the following scenario and address the answers to the questions provided. Using Microsoft Word, answer each question below in a report format using the style guide provided.

Scenario

Your organisation 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 create a report that addresses the assessment questions.

The following key 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 an external service provider. 

Customer Service Complaints Data

Key for staff: K = Kasyme, R = Raquel, B = Basel

Each letter represents one complaint. i.e. K = 1 complaint towards Kasyme; S, S = 2 service complaints.

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

QUESTIONS:

Analyse your data findings from the scenario provided?

What are your findings from this data analysis? What impact will this data have on your company?

Explain the data analysis methods you used and how you have applied these methods e.g. quantitative, qualitative.

Create a graphical representation of the data using MS Excel and insert into your report

How will this organisation monitor the levels of customer satisfaction in the future to ensure that their levels of customer services maintain a high level?

Explain where would the organisation store this information for future reference? Which departments would find this information useful for their operations? Should this data be stored securely? If yes, why?

How might the organisation store this data securely to protect their intellectual property?

What policies and procedures may need to be updated as a result of your research findings?

Share your draft copy of your report and your data findings with a colleague by sending them your report viaemail. Ask them to provide written feedback on your assessment based on the suitability and sufficiency of your findings. Your classmate is to provide a written response to the following questions which may be in email format. Note: Their written response must be submitted as part of your assessment evidence. This may be a copy of the email they send to you.

Based on the feedback you receive from your colleague, answer the following questions:

Do they agree on the outcome of your data analysis?

Do they agree with your identified solution?

What additional data findings would they recommend to be added to your findings?

Ask them to provide feedback on your report layout and format for improvement recommendations