MySkill Data Analysis Part 3 Data Visualization using Google Data Studio
Formerly known as Google Data Studio, Looker Studio is a data visualization platform that makes reports easier to create and understand. This makes it possible to bring datasets from multiple places to a single location thereby turning that information into easy-to-understand reports.
After processing the data using PostgreSQL and Google Colab tools, then data visualization is carried out using Google Data Studio tools to make it easier to understand the data information conveyed. This exercise uses the same data as part 2: hotel booking demand.
If you want to know my exercise 3 in Google Data Studio, you can see in here.
Question 1 : Total Bookings for each type of hotel
Output
Based on this output, the result is that the number of bookings at city hotels is more than resort hotels, this indicates that visitors are people who are on vacation as well as doing business. Therefore, city hotel owners need to make plans in order to compete in room rates.
Question 2 : Comparison of the number of bookings by local market from Portugal and inbound tourism from other countries
Output
Based on this output, it was found that there were 21,071 resort hotel bookings originating from Portugal. This shows that many Portuguese people travel in the summer.
Question 3 : ADR patterns in City Hotel and Resort Hotel are based on the average ADR each week
Output
Based on this output, the results show that the average ADR at City Hotels is relatively stable at more than 50. This is because City Hotels are booked a lot on weekdays. Meanwhile, the average ADR at Resort Hotels has increased every June and December, this is due to the summer season which is used by people for vacation while ADR decreases every September and March.
Question 4 : Monthly cancellation rates for City Hotel and Resort Hotel
Output
Based on the output, the result is that cancellation rates occur mostly in City Hotels with almost the same pattern as Resort Hotels. Cancellation rates at City Hotels are higher due to the development of digital technology. Orders can be made easily and cancellations can be made online. Therefore, hotel owners can use Google Calendar to remind guests about hotel reservations.
Question 5 : The number of orders cancelled for each type of market segment
Output
Based on this output, it was found that the highest canceled bookings came from the online TA market segment. Therefore, hotel owners are advised to be able to offer a booking system that is non-refundable and without discounts so that guests can make a decision with that choice.
This article is part 3 of the Data Analysis exercise from MySkill, if you want to see the other parts you can access them here: