Business Analytics

To: Director of Analytics,

From: Arjun Agarwal

Subject: Analysis of the provided data set

Sir,

As per the survey data provided, after analyzing data from different perspective and parameter is was found that average spending of the passengers of different age group is one of criteria which can help us in designing our packages for foods and other services, because their choices and spending depends on the age band. Following age bands are chosen for to analyses data:

Age Band

Category

No of observation

Total Spending

Average

21-29

Young

21

50,040.00

2,382.86

30-45

Core

61

1,80,163.00

2,953.49

46-59

Prime

54

1,62,567.00

3,010.50

60-69

Mature

45

1,51,018.00

3,355.96

70 -95

Senior

19

64,540.00

3,396.84

   

200.00

6,08,328.00

 

Customer Satisfaction is one of the areas which can help the company to grow and increase its revenue, and the aim of the company should be improve the services for the unsatisfied category, so to keep focus it is important to make this as part of dashboard and measure it on regularly and try to change the % of unhappy customers to happy customer quotient, and happy to delight.

% of unhappy Customer

Unhappy:

9%

Unimpressed:

22%

Acceptable:

20%

Happy:

20%

Delighted:

30%

ONE priority area for the company to target for improvement should be unhappy Customers, and actions should be taken to fix problem areas. The company’s reputation will be affected by what passengers say about their experience. Part of the CEO’s task will be to identify which group of passengers are least happy with their experience and address the reasons. It can also be seen after analysis that top spending customers are much satisfied that lower spending customers.

Booking Type

Solo:

The Satisfaction Rating for the top 40% is…

Acceptable to Delighted

Double:

The Satisfaction Rating for the top 40% is…

Happy to Delighted

Group:

The Satisfaction Rating for the top 40% is…

Happy to Delighted

Family:

The Satisfaction Rating for the top 40% is…

Acceptable to Delighted

Hope the above analysis is satisfactory. Moreover, it has been also decided to circulate this Dashboard on weekly basis as attached with the mail.

Thanks and Regards,

Business Analyst

Remember, at the center of any academic work, lies clarity and evidence. Should you need further assistance, do look up to our Accounting and Finance Assignment Help

Get It Done! Today

Applicable Time Zone is AEST [Sydney, NSW] (GMT+11)
Not Specific >5000
  • 1,212,718Orders

  • 4.9/5Rating

  • 5,063Experts

Highlights

  • 21 Step Quality Check
  • 2000+ Ph.D Experts
  • Live Expert Sessions
  • Dedicated App
  • Earn while you Learn with us
  • Confidentiality Agreement
  • Money Back Guarantee
  • Customer Feedback

Just Pay for your Assignment

  • Turnitin Report

    $10.00
  • Proofreading and Editing

    $9.00Per Page
  • Consultation with Expert

    $35.00Per Hour
  • Live Session 1-on-1

    $40.00Per 30 min.
  • Quality Check

    $25.00
  • Total

    Free
  • Let's Start

Get
500 Words Free
on your assignment today

Browse across 1 Million Assignment Samples for Free

Explore MASS
Order Now

My Assignment Services- Whatsapp Tap to ChatGet instant assignment help

refresh