We have explored how to use the data model to enable a traveler to find what they need. With this data and some clever querying, we can also discover some trends that can help the businesses. Given we have the year, month, and day of bookings and hotel stays, we can venture into analyzing data and behavior patterns of individuals, and how it affects the businesses (hotels and airlines).
Bookings are not spread across the year evenly. There will always be months when the number of bookings made far exceeds the number of bookings during other months. The following query gives the number of bookings made for each month:
neo4j-sh (?)$ MATCH (booking:Booking) WITH COLLECT(booking) AS bookings, booking RETURN DISTINCT booking.month AS month, COUNT(bookings) AS num_of_bookings ORDER BY num_of_bookings DESC;
The output of the preceding query is as follows:
+-------------------------+ | month | num_of_bookings | +-------------------------...