Business intelligence have become popular lately thanks to the advantages which provide when it comes to analyzing performance and getting KPIs quickly. Business Intelligence solutions primarily need data related to reservations and production from Ulyses PMS. Depending on the hotel size and complexity of operations the volume of data can be daunting. We will start by providing the endpoints you need to consume in order to obtain qualitative data. These are detailed below:
We will first want to understand the source of reservations. We can get this information by the following endpoints:
Following, we will want to know rates, offers and/promos related to them in order to understand what triggered these reservations
Following, the details of reservations are formed of
- Room type
- Product type
- Reservation status type
- Reservation situation type
- Policy
Once we have all this info we will be ready to retrieve reservationsFor this reason we will need to limit the amount of data. We recommend the following approach when implementing a BI client.
- Initial set up
This step needs to be completed when setting up the connection since Business intelligences need to obtain historical data. BI's will obtain a batch of reservations by means of the operation Get reservations and a timeframe. We recommend to limit the number of records by applying a filter in which we specify a time span of a week or two. However for future reservations you can increase the time span as the amount of reservations will be lower as time goes by.
- Updates
Once the connection has been set up we need to update info periodically to get reservations and production up to date. We recommend you to update the information once per day but this can be changed. The operations that you will use are again Get reservations and we will need to specify a time frame. As a result, we will get reservations both created and updated.
- Rates and prices
Get rates give information about the names and ids of the rates used by a property.
- Occupancy
Ulyses Cloud calculates the occupancy nor taking into account the number of rooms or modules but summing up the number of room subtypes throughout a period.