This dashboard helps Hotel company to analyze cancellations in bookings and make informed decisions . It helps the company get a better understanding of seasons, weekdays and segment of customers that cancel bookings more often . Through different trend analysis, they get to know their improvement area, & thus they can improve their services, profit and revenue by identifying which category to make more on what times they are having most bookings. Thus by using this dashboard get a better understanding, they can further work on factors that are helpful in increasing revenue and growth.
- Step 1 : Load data into MS Excel, dataset is a csv file.
- Step 2 : Open power query editor & and did the feature engineering, created columns 'guest type' and 'status columns'.
- Step 3 :created Pivot table
- Step 4 : Created dashboard, Plotted graphs and charts for data visualization and analysis
- Pivot Table for count of guest type
- count of Desired and undesired allotments
- Monthly Bookings and Cancellations
4.Booking and cancellations in City Hotel vs resort hotel
