The Hotel Booking Division of FestMan Consulting Group maintains a dataset that contains crucial information related to hotel bookings and customer interactions. The dataset includes the following key data points:
Customer Information:
Customer ID: A unique identifier for each customer making the hotel booking.
Gender: The gender of the customer.
Age: The age of the customer.
Origin Country: The country from which the customer originates or is based.
State: The state or region within the origin country, if applicable.
Location: A specific location or address associated with the booking, such as the customer's residence or office.
Booking Details:
Date of Booking: The date on which the booking was made.
Destination Country: The country where the hotel is located or the customer intends to visit.
Destination City: The specific city within the destination country where the hotel is located.
No. Of People: The number of people included in the booking (e.g., number of guests).
Check-in date: The date when the customers are scheduled to check-in at the hotel.
No. Of Days: The duration of the stay, typically represented in the number of days.
Check-Out Date: The date when the customers are scheduled to check-out from the hotel.
Rooms: The number of hotel rooms booked for the stay.
Hotel Information:
Hotel Name: The name or identifier of the hotel.
Hotel Rating: The rating or quality level of the hotel, which could be based on stars or a numerical scale.
Payment and Financial Data:
Payment Mode: The method of payment used for the booking (e.g., credit card, cash, online payment, etc.).
Bank Name: The name of the bank associated with the payment, if applicable.
Gross Fees: The total booking fees before any discounts or taxes.
Discount Amount: The amount of discount applied to the booking.
Net Booking Fees: The booking fees after subtracting the discount.
Tax Amount: Any additional taxes applicable to the booking.