Rooms Revenue

by Tableau

Description

This Tableau Accelerator allows you to:

  • Assess & Develop your Rooms Revenue
  • Deep-dive to Property level of detail
  • Identify the underlying drivers of your performance
  • Measure improvements of Occupancy level over time

Demo video

Answer key business questions

  • How much revenue do we generate from our rooms?
  • How successful were we at selling our rooms?
  • How much revenue is made per room on average?
  • What is our ability to fill available rooms at an average price?
  • How much revenue do we generate from one specific property?

Monitor and improve KPIs

Properties

  • Nb of Properties: Total number of managed properties

Revenues

  • Total Rooms Revenue: Total Revenues generated by sold rooms (expressed in currency)
  • ADR (Average Daily Rate): Average Daily Rate: average paid amount for rooms sold over the period. The KPI covers only revenue-generating guestrooms (expressed in currency)
  • RevPAR (Revenue per Available Room): Average Revenue per Available Rooms: revenue generated per available room, whether they are occupied or not (expressed in currency)

Rooms

  • Total Rooms Available: Total number of available rooms over the period
  • Total Rooms Sold: Total number of rooms sold over the period
  • OCC (Occupancy Rate): Share of sold rooms over total available rooms over the period. This is one of the highest indicators of success, providing an indication of the attractiveness of a property (expressed in percentage).
  • Total Rooms Unsold: Total number of rooms that were available but remained vacant over the period
  • Rooms Unsold %: Share of rooms that were available but remained vacant in the total number of available rooms over the period (expressed in %)

Guests

  • Total Guests: Total number of guests hosted over the period
  • Guests per Room: Average number of guests per sold room over the period

Required attributes

  • Date (date): Analysed period
  • Property (string): Designation of the property
  • Brand (string): Brand to which the property belongs
  • Country (string, role: country): Country in which the property is located
  • City (string, role: city): City in which the property is located
  • Rooms Revenue (numeric): Revenues generated by sold rooms
  • Rooms Available (numeric): Number of rooms available in the property during the period (number of rooms multiplied by number of days of availability)
  • Rooms Sold (numeric): Number of sold rooms over the period
  • Nb of Guests (numeric): Number of guests hosted over the period

Features

Supports data mapping

Resources