ANALYSIS
In this dataset, there are hotel data of almost 2 years from 2018 – 2020. This dataset was imported into Microsoft SQL Server for appending the data using the “UNION” statement because the data has the same number of columns and data types.
After which I left joined market segment on hotels and meal from meal cost on hotels to merge the columns from the different tables.
Then I imported the query into Microsoft Power BI for Visualization. From the visuals, the revenue between 2018-2020 is $14.79million. City Hotel generates 53.7% of the total revenue with $7.94million and Resort Hotel generates 46.3%.
City Hotel in the country PRT generated 17.9% of the revenue which is the highest. City Hotel has given out an average of 26.7% discount. Resort Hotel in PRT has the highest revenue with $2.57million. 24.5% of discount was given during this period.
There has been a steady annual revenue for both Hotels from 2018 to 14th September 2020 although the year hasn’t ended. The required car parking space is increasing as well.
There are periods of increase in revenue for both Hotels. The first period is between July and August while the second period is in January.
DASHBOARD
RECOMMENDATIONS
Strategies to increase revenue for other months of the year should be implemented.
The Hotel management should find ways to close up Hotels in countries out of the top 20 as they aren’t generating profit.
Yorumlar