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
The analyse tool offer a variety of filter you can use to analyse you hotels performance, everything can be custom accordingly to your needs. The tool have to options, Forecast and Market.
Forecast
How the analysis controls works
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 analyzed.
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 in each individual day is generated by this room type.
You can choose between the following filters:
Pickup: you can select if you would like to display the pickup of the last 1, 3, 7, 14 or 30 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.
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.
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 could 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.
Save Presets
By saving presets it gives the user the possibility to immediatly use custom filter settings.
Presets are useable in the index tab Analyse → Analyse in Forecast and Market or in Analyse → Budget.
At first the needed filters (KPI, Filter, Distribution, Reference, 2nd reference) are chosen. This configuration will be saved, with a custom name as a preset, by clicking on “New preset”.
Important! Every preset needs to have a unique name, otherwise the preset will not be saved.
If more than one preset is saved, switching between the preset can be done by clicking on the wanted preset.
To delete a certain preset, click on the waste paper bin next to the preset.
Detailed view
By a click on a specific day in the chart you will be directed to the lower part of the analysis page. Depending on what reference format you choose (per data or per weekday) the tiles in the detailed overview will give you the information of the current performance vs. the reference day. The comparison in the tiles will be displayed by the deviation to the YTD data.
The comparing date could also be set individually by overwriting the field. Therefore, you also could have a detailed comparison with every other date for example vs. a last year’s event day.
Below the comparison tiles you will find the tile “Characteristics” and a table overview based on your configurations of the analysis.
With the characteristics you could assess the booking development or rate changes for every day individually. The current years 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. The reason is that, the curve shows also the cancellations of the date you selected to analyze more in details.
Want to help us to improve RateBoard? If you have any suggestions, let us know ↗
