Analyse Tool

Owned by Fernanda Pacheco
Last updated: May 10, 2022 by alexandra (Unlicensed)
9 min read

The analysis tool in RateBoard offers many options for you to assess your data. With a custom combination of filters, distribution and reference you can create your own analysis perspective on the individual KPI’s.

What you will find here

Not what you were looking for? Search more topics

Search..

The analyse tool offers a variety of filters you can use to analyse your hotel's performance, everything can be customised according to your needs. The tool has two options, Forecast and Market.

Forecast

Forecast analysis controls

For setting up your analysis, you can define KPIs, filters, distribution and reference. You can then take a look at the data in a chart or table view.

  • KPI: what will be analysed.

    • Revenue, occupancy, ADR or RevPar.

  • Filter: particular information for which all available data will be displayed.

    • Pickup, room category, room type, segments, channels or countries.

  • Distribution: will split the available data into the selected distribution adding up to the total of your selected KPI.

    • Room category, room type, segments, channels or countries.

  • Reference: comparison with previous years.

    • Last year or 2 years ago.

KPI

To setup your analysis you first choose one of the given KPI which will be shown in the chart.

  • Revenue 

  • Occupancy

  • ADR (Average Daily Rate): Average rate of all sold rooms.

    • How to calculate it: (Total room revenue) / (Number of all sold rooms)

  • RevPAR (Revenue per available room): This KPI combines occupancy and ADR to see how the hotel was performing.

    • How to calculate it: (total room revenue) / (total number of rooms) or
      (ADR) x (occupancy in %)

Once you chose the KPI, all the other controls will refer to it.

Filter

A filter is used to show all available data for one particular information.

e.g. The combination of the KPI “revenue” and the filter for the room type “ROOM A”, will show, in the chart or table, how much revenue (confirmed revenue - cancelled revenue) in each individual day is generated by this room type.

You can choose between the following filters:

  • Pickup: you can select the pickup of the last 1, 3, 7, 14 or 30 days. It is recommended to always set the filter and pickup settings the same (e.g. both 7 days).

We will show only the net-pickup, so rooms that were reserved and cancelled within the 1, 3 or 7 days will be deducted automatically.

  • Room Categories: The room categories are the ones set in your inventory.

  • Room Types: The room types are the ones set in your inventory.

To be able to use room category and room type filters, your inventory capacity must be set.

  • Segments: The segments available for this analysis are the same segments you set up and use in your PMS.

  • Channels: The channels available for this analysis will equal the channels you set up and use in your PMS.

  • Countries: The countries available for this analysis will equal the countries you set up and use in your PMS.

Distribution

The distribution is different from the filter, because it shows all the available data for the selected option, adding up to the total of your selected KPI.

e.g. If you chose “revenue” as your KPI and “Room type” as your distribution, the chart will show all available room types and their relative proportion of the total occupancy.

You could use the following distributions:

  • Pickup: you can select if you would like to display the pickup of the last 1, 3, 7, 14 or 30 days. It is recommended to always set the filter and pickup settings the same (e.g. both 7 days).

We will show only the net-pickup, so rooms that were reserved and cancelled within the 1, 3 or 7 days will be deducted automatically.

  • Room Categories: The room categories are the ones set in your inventory.

  • Room Types: The room types are the ones set in your inventory.

  • Segments: The segments available for this analysis are the same segments you set up and use in your PMS.

  • Channels: The channels available for this analysis will equal the channels you set up and use in your PMS.

  • Countries: The countries available for this analysis will equal the countries you set up and use in your PMS.

Reference

The selection of the reference helps you to define the comparison data. You have the following options available to set up comparing periods:

  • Final last year

  • Same time last year (Year to Date)

  • Final 2 years ago

  • Same time 2 years ago (Year to Date)

You can also decide the format of the reference date.

  • Same date (e.g. 03/12/19 vs. 03/12/18)

  • Same day of week (e.g. Wednesday 03/12/19 vs. Wednesday 03/13/18).

Date picker

The assessed period can be changed by the slide control below the chart. You can hold the slider (light blue) and move it left or right to your desired period, you can also narrow down or widen the period you want to assess, to a minimum of two weeks or maximum of 6 weeks.

Each gray bar in the date picker represents a week, once you defined a period to assess, the analysis chart will always start on Sunday and end on Saturday. You can also check the events that will be displayed on the top of the chart, in yellow are the current year events and in gray the last year events.

By clicking on the bar of any given day you will open the detail overview. See more about the detailed view.

Up ⬆

Detailed view

You can access the detailed view by clicking on a specific day in the chart or by selecting a date manually. Once in the detailed view, you can analyze a day individually or compare to last year or 2 years ago, this will depend on what you chose for “Reference”.

Per day

If “Reference” is set to “None chosen”, the detailed view will be displayed for the selected date only. You can select a date by clicking on a specific one in the chart, or by selecting it manually in the date picker.

In the detailed view, the table will display the KPI and distribution selected in the chart options.

In the “Characteristics” section you can assess the booking development or rate changes for every day individually. The current year development will be displayed in blue. If the arrival date is still in the future, the blue line will be dotted to show you the forecasted development.

You will notice that the booking curve can also go up and down, that's because the curve also shows the cancellations of the date you selected.

 

Comparing dates

If “Reference” is set to anything different from “None chosen”, the detailed view will display a comparison between the selected date and the corresponding date last year or 2 years ago. You can select the dates by clicking on a specific one in the chart, or by selecting it manually in the date picker.

That means that every comparison data will be related to what was set in the “Reference” option.

In the detailed view, the table will display the KPI and distribution selected in the chart options.

In the “Characteristics” section you can assess the booking development or rate changes for every day individually. The current year's development will be displayed by a blue line and the reference date with a gray line. If the arriving date is still in the future, the blue line will be dotted to show you the forecasted development.

You will notice that the booking curve can also go up and down, that's because the curve also shows the cancellations of the date you selected.

 

Up ⬆

Market

In the Market tab, inside the Analyse tool you will find the market data, like competitors price and market demand. In order to assess your competitors, you can customise the data displayed by selecting the filters.

Market analysis controls

All the market analyse controls work as a filter, that means that every time you select something you are narrowing down the results according to it. As a default configuration all filters are set to “Any” and “Show”. This means that the chart will display the absolute lowest prices available.

Filters

  • Room category: the room categories depend on what you set in “Settings → Competitors”. If you have several room types into one room category (e.g. Standard), the chart will always display the cheapest room type available.

  • MinLOS (Minimum length of stay): Any or ≤1 to ≤7.

  • Meal type: Any, breakfast, half board, full board or all inclusive.

  • Persons: Any or ≥1 to ≥5.

  • Cancellable: cancellable or non-cancellable.

  • Market Demand: show or hide.

  • Occupancy: show or hide.

Date picker

The assessed period can be changed by the slide control below the chart. You can hold the slider (light blue) and move it left or right to your desired period, you can also narrow down or widen the period you want to assess, to a minimum of 2 weeks or maximum of 6 weeks.

Each gray bar in the date picker represents a week, once you defined a period to assess the analysis chart will always start on Sunday and end on Saturday. You can also check the events that will be displayed on the top of the chart, in yellow are the current year events and in gray the last year events.

Competitors

To take a better look at each competitor you can hover your mouse above one of them, this will highlight the rate development individually. You can also select or deselect a specific competitor, by clicking on it, to hide the information in the chart.

You can also access the information in table format, by changing the tab to “Table”, this will still preserve the set filters. The table can be exported as a CSV or PDF file.

Up ⬆

Custom presets

You can create custom presets that will save the analysis options and make it easier to get to the visualization that makes more sense to your hotel. You can create separate presets for the forecast or market analysis.

Create new presets

  1. Select the filter options you want to apply.

  2. Once you are done, click on NEW PRESET to create a new one.

  3. Add a unique name to your preset.

  4. Click "SAVE".

Access or delete presets

Once you created your presets, you can switch between them by clicking on preset option or delete a preset, click on the respective waste paper bin.

 

Up ⬆

Want to help us to improve RateBoard? If you have any suggestions, let us know ↗