Table of Content :

1. Information about the data

2. Questions to be  Answered

3. Data Cleaning

4. Analyzing Data

5. Finished Project Dashboard

6. Insights and Recommendations

Information about the Data: 

The dataset consists of data regarding bookings made for a resort and a city hotel in Portugal for the period between July 1, 2015, and August 31, 2017. The data includes 31 variables, and there are 40,060 observations for the resort and 79,330 observations for the city hotel, totaling 119,390 hotel reservations. The dataset contains actual data, but all identifiable information related to hotels or customers has been removed to maintain confidentiality.

Here there are some questions for analysis: 

1. 1.  What is the monthly booking trend for both hotels?

   2.  Which Hotel Received more Guests?

   3.  What is the most preferred meal type in both hotels?

   4.  What is the most preferred room type in both hotels?

   5.  Most of the guests are coming from which market segment?

   6.  What is the total number of guests who actually arrived after booking in both hotels?

   7.  What types of customers do both hotels usually attract?

   8.  What is the distribution of guests among various countries?

   9.  What are the 5 countries with the highest number of customers?

   10.  Which hotel and distribution channel is generating more revenue?

   11.  What is the monthly Average Daily Rate (ADR) trend for both hotels?

   12.  How many guests are repeating in both hotels?

Process: 

For this project, I am using Microsoft Excel for Data Cleaning and Tableau  to  perform Analysis through Visual presentation and finally Dashboard Creation.

Data Cleaning:

Data Cleaning is a process of ensuring data integrity, which means we have to make sure that data is complete, correct, and consistent for the analysis.  I will check  check and correct the following:

1. Duplicate Data

2. Missing Values

3. Handle Outliers

4. Data Type Correction

5. Trim Categorical Values

6. Data Processing

Analyzing Data:

I am using Tableau for analysis and visualization purpose.

Insights and Recommendations:

Below are general insights and recommendations from the analysis:

1). According to the analysis, the company can capitalize on the increasing trend from February to October by focusing on these months for promotions and special packages to attract more customers. November to January shows the lowest booking, It gives the opportunity to investigate why and can offer discounts as well to attract more guests.

2). City Hotel received more bookings and revenue. It may be beneficial to allocate more resources, such as staff and marketing budgets, towards this hotel to maximize profits.

3). Given that Bed and Breakfast is the most preferred meal plan at both hotels, it may be worthwhile to focus on promoting this plan in marketing campaigns and advertisements to encourage more bookings. As certain meal plans are more popular than others, it may be worth adjusting pricing strategies to reflect this demand. For example, if Half Board is the next best-preferred option at the Resort Hotel, it may be worth offering discounts or promotions to encourage more guests to choose this plan. 

4). As the majority of guests prefer Room A, it may be beneficial to focus on promoting this room in marketing campaigns and advertisements to encourage more bookings. To encourage bookings for less popular rooms, it may be worth offering discounts or promotions for these options. This can help increase occupancy rates and maximize profits. To maintain high levels of guest satisfaction, it's important to ensure that all rooms are of a similar standard and quality. This can help prevent negative reviews and encourage repeat business.

5). Given that OTAs account for a significant portion of guests who arrived, it may be beneficial to collaborate with them to increase visibility and encourage more bookings. As guests who arrived through offline travel agents/tour operators also make up a significant portion, it may be worth offering incentives or commission rates to them as well as to the group as well to encourage more bookings through these channels. While direct bookings currently make up a smaller portion of arrivals, it may be worth promoting direct bookings through marketing campaigns or by offering special rates or perks for guests who book directly.

6). As both hotels experience a high number of cancellations, it may be worth focusing on guest retention strategies to encourage repeat bookings and reduce cancellations. This may include offering loyalty programs, personalized promotions, or other incentives to encourage guests to book again in the future. 

In addition to it, clear and timely communication with guests can help reduce cancellations and improve guest satisfaction. This may include sending confirmation emails, reminders, and updates regarding their booking and any changes that may occur. Understanding the reasons behind booking cancellations can help identify areas for improvement in the booking process, guest experience, or marketing strategies. It may be helpful to collect feedback from guests who have canceled their bookings to identify any common themes or issues. 

7). As the majority of guests in both hotels are classified as a transient and transient party, it may be worth focusing on strategies to attract and retain these guests. This may include personalized promotions, loyalty programs, or other incentives.

8). Based on the information that the majority of guests are from Europe, particularly Portugal and its neighboring countries, marketing efforts should focus on reaching potential customers in Portugal and neighboring countries. This can be done by investing in targeted advertising campaigns on social media platforms, search engines, and travel websites that are popular in those regions. It may be beneficial to have staff members who can speak the languages of those countries. This can help provide better customer service and create a more welcoming atmosphere. Understanding where the majority of guests are coming from can help with pricing strategy. If the hotel is in a region with a higher cost of living, it may be beneficial to offer pricing options that are more affordable for guests from Portugal and neighboring countries to attract more business.

9). Travel agents/Tour operators are the top contributors to revenue for both hotels, it may be worth focusing on strategies to attract and retain customers through this channel. This may include building relationships with key travel agents and tour operators, offering exclusive packages or rates, or providing incentives for agents to book through the hotel. It may be worth exploring opportunities to increase revenue through Direct and Corporate channels. This may include targeted marketing campaigns or partnerships with corporate clients to encourage more bookings through these channels. Partnering with GDS providers or exploring other online travel agencies that offer access to a wider customer base can certainly help.

10). The data shows that ADR for both hotels increased from February to September, indicating a higher demand during this period. Hotels can use this information to adjust their pricing strategies and set higher rates during peak periods to maximize revenue. Conversely, hotels may consider offering promotions or discounts during slower periods to stimulate demand. The data shows a decrease in ADR in October and November for both hotels. They may offer promotions or packages to attract guests during slower periods or adjust staffing levels to match expected demand. 

11). To encourage more guests to return, hotels should focus on providing a positive customer experience. This could include investing in staff training to improve customer service, offering personalized experiences to guests, and implementing guest feedback mechanisms to understand and address any issues that may arise during a guest's stay. Loyalty programs can be an effective way to encourage guests to return to a hotel. By offering rewards and incentives to guests who book directly with the hotel or who book multiple stays, hotels can increase customer loyalty and encourage repeat business. And conducting further analysis to understand why their returning customer rates are low is important. This could involve surveying guests who did not return to the hotel to understand their reasons for not returning, and comparing this feedback to feedback from guests who did return to identify areas for improvement.

Thank you!