KB Logic Business intelligence, hospitality and bespoke software solutions
  homeservicesvaluescase studiesabout uscontact
 
Introduction
Business Information
Revenue Trend Monitoring
Room Pricing Tool
Room & Course Reservations
Client Services Extranet
Guest History Data Warehouse
Revenue Trend Monitoring
A fundamental and mission-critical revenue building solution,
created for the lowest possible cost.


Revenue Trend Monitoring
Tool With no system in place to monitor key trends such as spend per head, occupancy and average room rate, this large hotel group had developed unique KPI’s and needed a consolidated, coherent and structured solution to deliver competitive advantage.

Enterprise wide
To ensure a unified approach across the organisation, yet with the flexibility to cope with individual requirements, KB Logic developed a bespoke solution that looks like a corporate Intranet and does not use off-the-shelf products.

Powerful and flexible
The solution automatically captures and stores information from a number of source systems and gives Revenue Managers access via Excel spreadsheets with modified Pivot Tables to present data that can be flexed in different ways.

Lowest possible cost
Ensuring that everyone sings from the same hymn sheet, the solution maximises The Client’s investment in products and technologies to deliver a unique, fundamental and mission-critical solution for the lowest possible cost.

Details:

Revenue Management Trend Monitoring Tool
Developed to deliver real competitive advantage, this large Business Intelligence project was designed to provide Revenue Managers in hotels with easy access to accurate information about key trends such as spend per head, occupancy, average room rate etc.

The Problem
With no system that enabled staff to monitor trends in relation to Revenue Management KPI for Transient Leisure or Group market sectors, The Client had developed unique KPIs and standards of operation that were new to the industry. They needed a consolidated, coherent, structured solution to encapsulate and promote their data but were unable to find an ‘off-the-shelf’ solution.

The Requirement
KB Logic was tasked with developing an exclusive bespoke solution with a unified approach whereby reports could be produced for each Hotel according to Multiple Financial calendars, and without Revenue Management staff developing their own systems. For daily use by Revenue Management staff, the solution had to look like a corporate Intranet site whilst avoiding the use of expensive off-the-shelf Business Intelligence products.

The Solution
In order to maximise the use of existing datastores and minimise development cost, we consulted with the client and third party Revenue Management Consultants to devise and design a solution that automatically captured information from a number of source systems including Serenata NetHotel; MICROS Fidelio Opera CRS; and MICROS Fidelio 6.2.

This information was stored in cubes using MS-Analysis Services and presented to the user via a series of ingeniously designed Excel spreadsheets that enabled the user to navigate them as if they were using a corporate Intranet. The Excel spreadsheets used modified Pivot Tables to present data that the user could flex in a controlled way; restricted only to those capabilities prescribed by the Director of Revenue Management.

More than 70 base reports were provided which could be flexed by the user on-demand to deliver the information in the way they are interested in seeing it. To avoid the cost of buying additional off-the-shelf Business Intelligence products, the solution was developed in Excel and deployed to users’ desktops using a Citrix farm.

The Benefits
The solution enables the Client to organise, relate and reliably aggregate trend information across all Hotels and Brands for the first time. It has the ability to coordinate the activities of a large number of Revenue Managers, and encourages them to focus on understanding key trend information without the cost and time of developing a spread of diverse solutions.

Conforming to standards across the organisation, the solution ensures that all Revenue Managers sing from the same hymn sheet, which was one written by the Director of Revenue Management.

This is an excellent example of our proven ability to maximise The Client’s existing investment in third party products and technologies to blend a unique, fundamental and mission critical solution - for the lowest possible cost - which was extremely well received by both Revenue Managers and the Executive.
 
  top | contact | privacy policy | site map
enquiries
  © 2008-2015 KB Logic Ltd.
Registered Office: Bank Quay House, Sankey Street, Warrington, Cheshire, WA1 1NN. Tel: 01925 750 100.