Hotels Revenue and Bookings Dashboard using Power BI

Atlaq has a chain of 7 hotels in four cities. There are two categories of hotels "Luxury" and "Business" and every category has different room classes. We are provided 3 months of booking and sales data in five files and we are tasked to find the main KPI's and to answer business questions like Find revenue for each city ? What is the best and worst revenue making month, category of hotel and room class ? What is the booking status for each city, hotel type? What is the overall and individual Occupancy % for the hotels ?

Power PI is used for cleaning, Modeling the data and Dax was used for simple and complex calculations and the results were displayed in terms of graphs and charts.