In this Project, we will use SQL to answer the questions related to dataset. This will help us to develop data analysis skills in a practical context.
The hotel industry relies on data to make informed decisions and enhance the overall guest experience. In this project, we delve into a comprehensive hotel reservation dataset to extract meaningful insights. Our goal is to uncover guest preferences, Identify booking trends, and discover key factors influencing how the hotel operates.
The dataset includes the following columns:
- Booking_ID: A unique identifier for each hotel reservation.
- no_of_adults: The number of adults in the reservation.
- no_of_children: The number of children in the reservation.
- no_of_weekend_nights: The number of nights in the reservation that fall on weekends.
- no_of_week_nights: The number of nights in the reservation that fall on weekdays.
- type_of_meal_plan: The meal plan chosen by the guests.
- room_type_reserved: The type of room reserved by the guests.
- lead_time: The number of days between booking and arrival.
- arrival_date: The date of arrival.
- market_segment_type: The market segment to which the reservation belongs.
- avg_price_per_room: The average price per room in the reservation.
- booking_status: The status of the booking.
Our objective is to leverage SQL for in-depth exploration and analysis of the dataset. By addressing specific queries related to the dataset, our goal is to reveal patterns that will guide strategic decisions and optimize the overall performance of the hotel.
MS SQL SERVER
- What is the total number of reservations in the dataset?
- Which meal plan is the most popular among guests?
- What is the average price per room for reservations involving children?
- How many reservations were made for the year 20XX (replace XX with the desired year)?
- What is the most commonly booked room type?
- How many reservations fall on a weekend (no_of_weekend_nights > 0)?
- What is the highest and lowest lead time for reservations?
- What is the most common market segment type for reservations?
- How many reservations have a booking status of "Confirmed"?
- What is the total number of adults and children across all reservations?
- What is the average number of weekend nights for reservations involving children?
- How many reservations were made in each month of the year?
- What is the average number of nights (both weekend and weekday) spent by guests for each room type?
- For reservations involving children, what is the most common room type, and what is the average price for that room type?
- Find the market segment type that generates the highest average price per room.
For any inquiries or feedback, please contact: