Hotel Booking Power BI Dashboard

Hello Connections,
I am Alkesh Mohandas excited to share my latest Hotel Booking Dashboard in Power BI.

Link to view interactive dashboard - https://shorturl.at/agtNU Link to database is: - https://docs.google.com/spreadsheets/d/1eYx6q9oE21T410pvAaQ-HHq1-CsTYvjq/edit?usp=sharing&ouid=117095320123371703968&rtpof=true&sd=true

Database is in Excel which I got from novypro.com website. Objective of Dashboard:

1. The objective of the dashboard is to show the hotel booking data for two types of hotels: city hotel and resort hotel.
2. The dashboard is designed to help the user analyze the hotel booking performance and identify trends and patterns.

Process includes.

1. Importing data few transformations and cleaning in power query
2. Identifying & Creating Measures using DAX.
3. Validating all data
4. Creating Dashboard using appropriate Visualization. Key metrics and various Charts which I will selecting in video to analyze the hotel booking performance and identify trends and patterns are as follows: - Key Metrics

1. Total Revenue: The total amount of money earned from the hotel bookings.
2. Revenue Lost: The total amount of money lost due to the cancellations of the hotel bookings.
3. Average Daily Rate: The average price per night for each hotel booking.
4. % Cancellations: The percentage of hotel bookings that were cancelled.

Charts 1.Stacked column chart for total Revenue by Revenue Lost on a monthly basis chart. Total Revenue is the sum of the revenue generated by the bookings that were not cancelled. Revenue Lost is the sum of the revenue that could have been generated by the bookings that were cancelled. The visual states the month in which Total Revenue and Revenue lost diverge the most in smart narrative.

2.The visual shows a bar and line chart with two y-axes: one for the ADR and one for the cancellation rate. The x-axis is the month of the year. The Average Daily Rate (ADR) is the average revenue earned per room sold in a given month. The cancellation rate is the percentage of bookings that were cancelled by the customer or the hotel in a given month.

Some of the insights from the visual are: a. The ADR is highest in August ($140.11) and lowest in January ($70.36) b. The cancellation rate is highest in June (41.46%) and lowest in November (30.48%). c. There is a positive correlation between the ADR and the cancellation rate, meaning that as the ADR increases, so does the cancellation rate. This could indicate that higher prices discourage customers from staying at the hotel, or that customers who book at higher prices are more likely to cancel their bookings for various reasons. d. The ADR and the cancellation rate diverged the most in August, when the ADR was $139.73 higher than the cancellation rate. This could suggest that August was a peak season for the hotel, and that customers who booked at high prices were less likely to cancel their bookings.

3. For displaying the text in key insights we have used smart insight visual which will change descriptions if we filter the visuals. Here is an example.

4. The bottom three visuals are all bar charts as stated below: a. Cancellation by weekdays shows the total cancellation by each day of week.

Next two visuals are on basis of booking lead time which is the number of days between the time a guest books their room and the time they are scheduled to arrive at the hotel.

b. Average Daily Rate and cancellation Rate is bifurcated in the lead time of 0-30 days and more than 30 days.

Slicers used in the Dashboard is for date and type of hotel and we can filter the report as per requirement by clicking on any of the visuals in dashboard. Now I will select each slicer and visuals to show how other visuals respond to the selection.

1. I will now change the end date to 2016 instead of 2017 and then select City hotel from type of hotel slicer. We can see other visuals change to the clicks.
2. Then I will select the August month in case of two visuals Total Revenue by Revenue Lost on a monthly basis chart and Average Daily rate and cancellations by month chart.
3. In the bottom three visuals I will select Mon in cancellations by Weekdays visual and 0-30 days for Average Daily Rate and Cancellation visuals.

Please provide your feedback on the Dashboard and if you find the information useful, please press the like button and re-post to spread knowledge. Looking for more opportunities in this field.