Data Analytics
Data analytics is different from data analysis because it tells you what to do and what the result will be where as data analysis gives you information about the current situation. Data analytics makes predictions and tells you what the result would be by taking a certain action. In other words: data analysis focuses on the past and current situation, data analytics focuses on the future.
The case below is an example how to predict YOY Growth, ADR within a hotels company.
About the Project
For, a hotel database, I have done EDA (Exploratory Data Analysis) to get details of the concerned hotels using advanced SQL codes. I have done analysis on the data, keeping in mind the challenges like : Is the revenue growing YOY, is there a need of increase in parking space, what is the trend. Further the analysis is been carried down with various other factors which are useful during our analysis . Based on the analysis the result can be obtained and will get to know about the type of trend. Steps can be taken based on this analysis.
Is our hotels revenue growing by year ?
The company wants to know about the revenue growth. For the revenue we have the factor called ADR(Avg. Daily Rate). We will group our customers on the basis of hotels and countries and other known groups if possible. After that we will multiply ADR with occupancy rate according to hotels. Through this we will get the revenue. We will now do the same for other years also.
From the graph we can understand that there are two hotels- City Hotel and Resort Hotel. Overall City Hotel has generated higher revenue than Resort Hotel . But if we look in the year 2018, Resort Hotel has recorded almost double revenue than City Hotel.
Do we need to increase parking space?
From the matrix we can see the data of both the hotels.
Considering the parking space there was requirement of 14K parking spaces in the year 2018.
In year 2019, there was more requirement of car parking spaces which was approximately 47K. This shows the increase in parking space and hence increase in occupancy of customers.
In year 2020, the car parking area reduce to 30K. There may be reduction in occupancy of customers.
As a result, there is no more need of car parking spaces in the hotels.
Where is the trend going on based on ADR with respect to hotels?
To know about the ongoing trend of hotels we will measure the trend based on number of hotels present in different places with year and month.
In the first chart, we can see that there is upward trend from 2018 to 2019. The ADR has been increased from $2M to $4.5M approximately. But we can see downwards trend in 2020. This has reduce the ADR up to $3M.
In the second chart the ADR been represented by months. There is been upward trend seen up to the month of August. The last 4 months has recorded less ADR as compared to the other months. This can be the reason because of weather and climate in different areas of the world
Do you want to know more about data analysis? Let's get connected !