Completion Date:
Project Overview
This project pertains to building a Data warehouse for Indian hotels on Goibobo. Hotels collect vital information like Guest recommendations, site review count, hotel star rating, etc. The main reason to collect that information is to help the update hotel’s information for analysis purposes. To do that they should have a key factor (Key performance indicators) to track the flow of data which is given by customers, like monthly, quarterly, and yearly. At this point, all these factors are highly influenced by other information like longitude, city, state, etc. For example, in some cities, there is a high population but the public service are low, and in some cities, there is a low population but there are high public services because of some tourism advantage.
Role:
Problem Statement
hotel ratings are strongly influenced by guest recommendations, with a decrease of 10% in recommendations leading to a decrease of 2% in the hotel rating. The size and type of the hotel, the number of reviews and images on the website, the number of rooms, and proximity to points of interest also play a significant role in determining hotel ratings. We also found that certain amenities, such as pools, gyms, and restaurants, positively impact hotel ratings, while high prices negatively impact ratings. The goal of this research is to identify the key factors that influence hotel ratings and to understand how these factors interact with one another to determine the overall rating of a hotel.