Hotel Revenue Analysis

So, this is a PowerBI dashboard that describes the revenue of a hotel with respect to its type and the period over time. Looking at the database we have 5 tables for the three successive years namely “2018”, “2019” and “2020” with that we have tables for “market segment” and “meals”.

So, the first step is to style data in a fashion that is suitable to our analysis and I have done that with “SQL” The first thing to do was join the tables “2018”, “2019” and “2020” by naming them as hotels so that we could look at the revenue. Still, here we don’t have any column explicitly for revenue. Hence, we make a query formula to get revenue from the summation of staying and multiplying it with “adr” i-e average daily rent. Then we joined the market segment with hotels so we could look at the discount given to different market segments. Then lastly, we joined the hotel's table with meal costs to get a final view of a table that is comprehensive to our analysis.

The next step is to import data in PowerBI and then make an interactive report on it

The dashboard has been developed as follows: • Slicers: namely for “Country” and “hotel”. • Cards to showcase revenue • Measures: “No of Nights”, “Parking percentage”. The measures were coded with the DAX. • Table to showcase numbers • Slicers to get time customizable to the user
• Line chart to plot the revenue over time as we have two types of hotels so plotted them collectively with different colors so that we can visualize the comparative growth.