/AnalyticsBookings

Analysing and getting insides from a SQL dump dataset that includes customer arrivals (reservations)

Primary LanguageJupyter NotebookMIT LicenseMIT

AnalyticsBookings

  • Create and present a report with the following pieces of information:

    • arrivals per week
    • volume of arrivals per product market (where the accommodation is located)
    • benchmark for the last year (if information is available)
    • filters in the report for YTD (year to date), MTD (month to date) and / or selected period
    • selection for provider (PMS), sales channel
    • totals of gross revenue for every selection / filter

  • The corresponding analysis visualization to Python in Google Data Studio is available at the following link: https://datastudio.google.com/s/o-0TvAhQ2Kg