Europe Hotel Booking Satisfaction Score

In recent years analysis on Customer satisfaction rating has been high on demand as it is a key metric for the hotel industry, it can have a significant impact on a hotel's reputation and profitability. High levels of customer satisfaction can lead to increased customer loyalty, repeat business, and positive word-of-mouth marketing. On the other hand, low levels of customer satisfaction can result in negative reviews, decreased bookings, and financial losses for the hotel.

Ok so what is the best analytical way to measure customer satisfaction rating?

Analysing Likert chart and finding Net Promoter Score (NPS). NPS is a measure of customer loyalty and is calculated by asking customers how likely they are to recommend a hotel to a friend or colleague on a scale of 0 to 10. A high NPS score indicates high levels of customer satisfaction and loyalty. A Likert chart is a type of chart that is used to display the results of a Likert scale survey. A Likert scale is a type of survey question that asks respondents to rate their level of agreement or disagreement with a statement on a scale, such as a 1-5 or 1-7 scale.

Sorry to bore you with all this theory, let's hop in the project itself 😅 .

So the dataset is taken from kaggle and consists of around 100000 unique customers over time. Now while designing the project, I decided to break it down into 3 major parts:

1. Overview - To give a broad perspective of customer satisfaction for each segment.

2. Rating Analysis - Checking rating survey with the help of Likert, NPS and Avg. Rating Score Chart.

3. Age Based Analysis - Analyzing and comparing different age groups using normalized satisfaction rating bar charts and averages. Score Rating Scatter Chart.

This time I also decided to provide detailed recommendations divided into 2 main sections:

1. Short term plan
2. Long term plan