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.
Detailed view
You can access the detailed view by clicking on a specific day in the chart or by selecting a data 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 individually. You can select a date by clicking on a specific one in the chart or by selecting it manually.
Into the detailed view, the table will display the KPI and distribution selected in the chart options.
In the “Characteristics” you could assess the booking development or rate changes for every day individually. The current year development will be displayed in blue. 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.
Comparing dates
If “Reference” is set to anything different from “None chosen”, the detailed view will display a comparison between the select date and the correspondent 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.
That means that every comparison data will be related to what was set in the “Reference” option.
Into the detailed view, the table will display the KPI and distribution selected in the chart options.
In 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, that's because the curve also shows the cancellations of the date you selected.
Market
Custom presets
You can create custom presets that will save the analyses 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 analyses.
Create new presets
Select the filter options you want to apply.
Once you are done, click on
NEW PRESET
to create a new one.Add a unique name to your preset.
Click
"SAVE"
.
Every preset needs to have a unique name, otherwise the preset will not be saved.
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.