Home > Business Intelligence Services > Hotel Business Intelligence

Hotel Business Intelligence

Client

Our client is a startup owner who came to us in 2017 with the idea to develop a new Business Intelligence System for hotels. He needed more than just senior-level experts who are able to choose the right architecture of the new system - he needed a dedicated team that could deliver enterprise-level analytical products.

Challenge

Hotel leadership teams are demanding greater control over their inventory, room rates, and marketing.

Revenue managers of the small and mid-size hotel chains are struggling to optimize their net RevPAR (revenue per available room) and GOPPAR (gross operating profit per available room) KPIs.

But collating, verifying, and analyzing revenue, property, and guest data takes significant time and effort. These data are often kept in separate systems because each team - from sales and marketing to operations and food & beverage uses different systems and spreadsheets to store their data.

Examples of such systems – PMS like OPERA Property Management System, channel management system, CRMs and sales, guest, food & beverage and marketing systems.

The manual work makes it difficult to recognize demand trends in time and forecast them effectively. The potential for human error during the data entry stages is also increased.

Solution

The key aspects of his idea of a hospitality business intelligence system were:

  • A suite of dashboards with reports where revenue managers get a full picture of hotel performance.
  • The data for these dashboards should be automatically combined from separate systems the hotel has.
  • The data should be presented in a way that lets revenue managers easily identify opportunities to improve performance and optimize revenue and profit throughout each room, as well as other departments (e.g. food & beverage, spa, or casino).
  • The data should also be available for the hotel owners and chief operating officers so they don't need to manually review the historical reports from their general managers, revenue managers, and sales & marketing teams.
  • The data should also be available for marketing teams to help them get insights at any given time on whether it’s better to run a promotion or change rates for guests to increase direct bookings on their corporate website, building loyalty to encourage return bookings and recommendations.

Process

Using focus groups

The key to marketing success of a startup is using a focus group. Our client came to us with the early adopters - hotel managers from a worldwide chain that operates 39 hotels. This approach let our client build a Business Intelligence Product which is able to stay at the forefront in satisfying hospitality industry requirements.

Owners of this hotel chain allowed our client to use their real hotel data while developing this BI tool in exchange for a discount for purchase of this product when it is available on the market.

The hotel managers also validated the final success metrics they wanted to see in this BI software: occupancy rate, average daily rate (ADR), RevPAR, average rate index (ARI), revenue generation index (RGI), market penetration index (MPI).

Loyalty management

The early adopters asked our client to add a new feature to this BI tool: custom loyalty management. Here is how we implemented it.

The system tracks spending of all hotel guests including loyalty program members. If a number of conditions match, the system automatically gives the quests a certain number of loyalty points.

Hotel guests can use these loyalty points to make direct bookings from the hotel website or to pay for using partners’ services (for example, airline tickets).

Hospitality data benchmarking

Competitive benchmarking is the process of comparing your hotel business against competitors using special metrics.

STR provides hotels with anonymized data from 67,000 hotels across 180 countries and primarily focuses on historical data around revenue and occupancy. Hotel managers use reports from STR to compare their performance to their rivals.

STR does not provide API access, so we had to create scripts to parse and import data from PDF reports into the Business intelligence tool’s database.

Results

By using our business intelligence software development services, the client got this BI solution.

Insights hotels can get and use from analyzing guest data using this Business Intelligence System include:

  • Historical data show, for example, that families tend to book seven weeks ahead of school holidays. Marketing campaigns can be timed accordingly.
  • Hotels observe a spike in website views without increasing conversion into bookings. Price may be an issue, and sometimes concessions may be necessary.
  • Historical data show periods when occupancy is consistently low. On such days, the chain can run offers, a flash sale or increase the hotel’s prominence on social media, OTA channels, and metasearch. The same tactic can be used if an unexpected drop in occupancy has been spotted to take steps to fill the rooms.

Here are some illustrated use cases for the Hotel BI tool.

Hotel Occupancy Report

  • What pickup trends do we have?
  • Let's define the date range that we need.
  • Let's make the chart more visually appealing.
  • The number of reserved rooms dropped 11% on March 19, 2020

Hotel Pickup Report

  • What occupancy rate trends do we have?
  • Let's explore trends for future periods. Today is 23 March 2020. Let's compare from April 2020 to April 2019.
  • The occupancy rate dropped significantly: up to 90% on some days. It corresponds with the whole hospitality industry trends and direct competitors' situation (data from the STR).
  • When did this negative trend start? Let's compare March 2020 to March 2019.
  • The report shows a huge canceled reservation trend in March 2020.

This BI solution was in such demand that a year after the release it was acquired by a large hotel software provider who develops global distribution systems for hotels (total funding amount is about $26M).

The new client would like to increase its market share by adding BI solution to its suite of products for hotels.

Our new goal became integrating the BI solution, that was developed by our team, into the product of the new owner, that was created by other developers.

Tech stack

AWS
AWS
Nginx
Nginx
PHP-FPM
PHP-FPM
php
Php
MySQL
MySQL
AngularJS
AngularJS
Yii
Yii

Testimonials

Showcast

If you are looking for a true partnership Belitsoft company might be the best choice for you. They have proven to be most reliable, polite and professional. The team managed to adapt to changing requirements and to provide me with best solutions. I strongly recommend Belisoft.

Ivo Downes

Director at ShowCast Limited (Germany)

tichen

I expected and demanded a lot of you at Belitsoft company, but you exceeded my expectations. You acted pro-actively, challenged me at the right moments. Thanks!

Martin Beijer

CEO at Ticken B.V. (Netherlands)

EFI

We have been working for over 10 years and they have become our long-term technology partner. Any software development, programming, or design needs we have had, Belitsoft company has always been able to handle this for us.

Bjarne Mortensen

СEO at ElearningForce International (United States, Denmark)

Crimson

They use their knowledge and skills to program the product, and then completed a series of quality assurance tests. We were working in an agile way with them. Belitsoft performed very well throughout our project. We are definitely looking at Belitsoft as a long-term partner.

Eddie Nicholas

Service Delivery Director at Crimson (United Kingdom)

Berkeley

I highly recommend Belitsoft for website design and development. We were up against a tight deadline to launch the project. The work was delivered on time and within budget! I will continue working with Belitsoft as a valued partner for our web development!

Adrienne Herd

Program Administrator at UC Berkeley (United States)

Hathway

We have worked with Belitsoft team over the past few years on projects involving much customized programming work. They are knowledgeable and are able to complete tasks on schedule, meeting our technical requirements. We would recommend them to anyone who is in need of custom programming work.

Kevin M. Rice

Main Partner at Hathway Tech (United States)

Howcast

Belitsoft company is able to make changes instantly. One of our internal engineers has commented about how clean their code is. Belitsoft seems to know what they're doing, which I appreciate.

Darlene Liebman

Co-Founder at HOWCAST MEDIA (United States)

Fraunhofer

It was a great pleasure working with Belitsoft. Software Development Company. New requirements and adjustments were implemented fast and precisely. We can recommend Belitsoft and are looking forward to start a follow-up project.

Renè Reiners

Deputy Head of Division at Fraunhofer FIT (Germany)

Apollo Matrix

Belitsoft company has been able to provide senior developers with the skills to support back end, native mobile and web applications. We continue today to augment our existing staff with great developers from Belitsoft.

Pete Johnson

CEO at Apollo Matrix (United States)

Key2Know

Belitsoft company delivered dedicated development team for our products and technical specialists for our clients time to time custom development needs. We highly recommend that you use this company if you want the same benefits.

Bo Sejer Frandsen

Managing Director at Key2Know A/S in 2012 (Denmark)

Regen Med

We approached BelITsoft with a concept, and they were able to convert it into a multi-platform software solution. Their team members are skilled, agile and attached to their work, all of which paid dividends as our software grew in complexity.

Nicolas Tierney

COO at Regenerative Medicine LLC (United States)

Moblers

Having worked with Belitsoft as a service provider, I must say that I'm very pleased with the company's policy. Belitsoft guarantees first-class service through efficient management, great expertise, and a systematic approach to business.. I would strongly recommend Belitsoft's services to anyone wanting to get the right IT products in the right place at the right time.

Guy Doron

CEO at Moblers (Israel)

Let's Talk Business
Do you have a hospitality software development project to implement? We have people to work on it. We will be glad to answer all your questions as well as estimate any project of yours. Use the form below to describe the project and we will get in touch with you within 1 business day.
Contact form
* Maximum file size is 20MB
to top