Hotel booking dashboard

March 01, 2023 (1) comments
Product
Project related images. Click to view
Product

About the project

The hotel booking summer dashboard analyzes hotel data to derive deep insights in July and August 2016. In this analysis I was able to clean the data, modelled it and created charts to show average daily rate, cancellation weekday and total revenue made and lost in 2016 in the months of July and August.

Tools used

  • Microsoft Power BI Desktop
  • Microsoft Excel and 
  • Microsoft PowerPoint to design the user interface.

Findings

  • There is an increase in Revenue and also lost to cancellations.
  • July and August have total lost of $9991, 181 and total revenue of $1,786, 615
  • Higher cancellations fall between Monday, Thursday and Saturday.


Comment (1)

  • Avatar
    Paul Edem

    Wow! This looks beautiful. Well done Daniel.

Leave your thought here

Other projects by Emmanuel Bassey