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.
Paul Edem
Wow! This looks beautiful. Well done Daniel.