Skip to content

Business Intelligence in the Middle of the Ocean

Case Studies

About Hospitality Company

KPI's client is the world's second-largest cruise vacation company that operates Cruises. The company currently has 40 ships in service that call on approximately 400 worldwide destinations. 


  • Oracle KPI Partners-Mar-18-2022-07-14-25-00-AM

Business Drivers

There were two main business drivers for the client:

  1. Increase access to data
  2. Better manage the business


Key personnel was provided limited ability to make actionable decisions to affect onboard revenue during a voyage. There was no visibility to detailed guest-level transactions. Data resided onboard each individual vessel without a consolidated view of the fleet. Most importantly, because of existing architecture, the summary-level voyage information could only be collected at the end of each voyage. The company did not know how well a particular voyage was performing against targets until they returned to port and all the passengers departed. This was too late to affect change to in-voyage revenue.


Top executives sought the ability to better manage the business and grow voyage revenue by better understanding relationships between guests' demographics and their spending patterns. For example, on a given voyage, what country are our passengers from and, based on historical data, what are they most likely to consume in the form of food & beverage, onboard activities, and on-shore excursions.

The management teams needed a tool to quickly identify revenue performance trends during these 3-10 day voyages and make associated changes to drive revenue instead of just reporting on it.


"The pattern that revenue builds during a voyage is certainly not linear. One of the important things was to show the expected pattern that revenue would have day-over-day and let the user see where we are relative to that pattern."

- Richard Paley


Solution Detail

Technology consultancy KPI Partners partnered with the client on a unique business intelligence solution.  Through the use of state-of-the-art business intelligence technology, the client can now bring together various disparate data sources to help optimize the vacation experience for travelers on all of their ships.


Shore-side managers and shipboard users access dashboards on a daily basis to track usage of amenities such as their onboard spas and shore excursions as well as revenue streams for various food and beverage outlets.  By profiling near real-time voyage analytics against historical data and dimensions such as age and country of origin, the client can optimize promotions that best appeal to the passengers.


The complex project was a multi-year effort that started with a proof-of-concept developed using the 10g version of the Oracle Business Intelligence Enterprise Edition (OBIEE) on a single ship within the client fleet.  After multiple design & development iterations, the production implementation was a custom Cruise Ship Analytics solution deployed using the upgraded 11g version of OBIEE.  All 22 ships within the client-branded fleet now participate while at sea and distribute data via satellite to on-shore servers for analysis.



Because of the grand scale of this effort, several notable challenges were encountered and overcome.  The biggest challenge was determining how to create a high-performance analytics solution while ships are at sea.  Data transfer rates are limited and user adoption would have stalled if people were forced to wait for screens to paint with data FOR their dashboards. 


Considerations were made, and best practices were developed, for scalability, system upgrades, and performance.  The capabilities of the Oracle databases were also utilized to their fullest potential; Data was partitioned, indexes were created, and summary objects were built.  Because of the optimizations, dashboards will paint within 2-3 seconds on average.


Cruise Ship Analytics - At A Glance

The following list encompasses the high-level areas in which shipboard and shore-side management teams can now conduct near-real-time analysis via cruise ship Analytics solutions. 

  • Shipboard Overview
  • Shore-side Overview
  • Spa
  • Beverage
  • Shore Excursions
  • Specialty Dining
  • Gift Shop
  • Photography

Why Was Oracle Chosen?

In an effort to stay consistent with the very large Oracle footprint that exists at the client, Oracle BI was selected as the enterprise-standard reporting application.  Licenses for Oracle BI were purchased as part of an upgrade with the Hyperion Suite of products but were originally shelved because a lack of expertise existed to deeply the BI tool.  RCCL partnered with a credible and experienced systems implementation partner who could provide strategic direction on the best practices required for deploying a scalable enterprise-reporting platform.


When weighing the features and benefits of Oracle's business intelligence suite versus those of other vendors, the ability to combine data from multiple sources proved to be an attractive benefit. The client has several different types of front-end transactional and back-office systems that needed to be integrated in order to provide a valuable central source of reporting the truth.


Oracle BI also offered an intuitive, easy-to-use, interface.  A platform that required minimal training was very important due to the geographically dispersed and culturally diverse user base that would be utilizing the system.


Why Was KPI Partners Chosen?

As the most experienced systems implementation partner focused on Oracle BI & EPM, KPI partners were chosen because of their expertise within Oracle BI and related technology.  KPI Partners has successfully implemented the most complex deployments of Oracle BI in the world and the project at Royal Caribbean required in-depth expertise to provide the high level of performance required in a satellite-driven data exchange environment.


KPI Partners offered functional expertise in the travel and hospitality industry.  KPI also offered global delivery capabilities that leverage a blended-shore model with a combination of high-value on-site experts and lower-cost offshore resources.



The effort was launched in mid-2009 with a KPI Partners Vision Workshop that brought together all the key stakeholders within client's Technology Department, the client's Business Sponsors, functional & subject matter experts, and the business intelligence project team.  In December 2009, the original pilot version of the Cruise Ship Analytics solution was introduced to Oasis of the Seas, the largest cruise ship in the industry.


After a comprehensive and successful 12-month pilot period that involved the inclusion of four other cruise ships, an additional round of capital funding was approved to expand the project beyond the pilot.

In January 2012, the production version of Cruise Ship Analytics was launched across all 22 ships in the client-branded fleet.


Solution Components:

Business Intelligence Components

Oracle Business Intelligence Enterprise 


Enterprise Data Warehouse - Oracle 

Database 11g R2


Other Platform Components

Operating System: Red Hat Enterprise 5

Authentication: LDAP

Total Number of Users: 150+


Educational Components

Custom OBIEE training program via 

KPI University


Data Sources

Onboard Point-of-Sale Systems

Pre-Cruise Reservation Systems 

(Guest Data)

On-Shore Excursion Systems 

(Reservations & Sales)

Financial Planning System 

(Revenue Targets)


Oracle Footprint 




JD Edwards

Oracle Databases



Future Plans

The company plans to introduce three more ships to the client brand by the end of 2015, to increase to a capacity of approximately 100,00 berths.  Cruise Ship Analytics will be deployed to each of these new vessels.


In addition, the client plans to expand the Cruise Ship Analytics solution across the rest of the company's brands: Celebrity Cruises, Pullmantur Cruises, Azamara Cruises, and CDF Croisi'res de France.  

By the end of 2015, Cruise Ship Analytics, powered by Oracle BI, will be operational on all 43 ships under the client umbrella.


Compatibility with mobile devices, such as the iPad and smartphones, is already available with certain restrictions due to security.  The business would like to expand on this capability and make mobile usage more pervasive. 


Due to the high rate of user adoption since the January 2012 launch, enhancement requests for additional functionality have been rolling in regularly from the business.  The Cruise Ship Analytics solution continues to evolve.  The client is already planning for the inclusion of new executive-level summary dashboards and month-to-month financial reporting by vessel.



Cruise Ship Analytics Maximizes client's Voyage Revenue

The client immediately reaped the benefits of a dazzling global deployment of Cruise Ship Analytics across 22 vessels and over 400 ports of call.


Success Criteria

The client required a single consolidated global view of their onboard and shore-based revenue performance as well as a detailed revenue analysis for every ship within the fleet and for every voyage.  A successful implementation would facilitate the ability to refresh business intelligence data multiple times per day and accommodate 24 x 7 user access.    

High-level performance and data accuracy were critical success criteria.  Dashboards needed to be light and painted within a few seconds using satellite data connections. 



The client found over time that the two major categories that really affect spend-patterns are nationality and age.  Reports were generated in this area and provided great insight.  The industry-related logic and integration of data sets to make this possible were extremely complex.


Key project accomplishments:

  • An enterprise data warehouse was created and populated with data. 
  • Data was combined from disparate sources to provide a comprehensive view of each ship's performance. 
  • Leveraged LDAP for authentication.
  • The solution was rolled-out 22 ships located around the world with minimal effort.
  • Food & beverage managers, bar managers, hotel directors, and marketing managers were trained in a timely fashion. Management teams were provided with near real-time views of how each ship is measuring against their voyage metrics. 
  • Provided business intelligence to allow shipboard management to modify onboard activities to achieve desired results through demographically targeted promotions.

Quantitative Results 

Return-on-Investment (ROI)

It is still early to quantify the impact of the Cruise Ship Analytics solution through a systematic measure, Royal Caribbean is already experiencing anecdotal return-on-investment (ROI) with their business intelligence solution because they are able to modify onboard marketing activities to specific demographics to maximize voyage revenue.


For example, if beverage revenue is lacking on a particular voyage, management can now identify this deficiency quickly and tailor promotions around a particular brand of beer (Molson) that has historically appealed to a segment of guests on-board based on their country of origin (Canada). 


There has also been a specific case of a client vessel that sails out of the South American region that has never made their revenue target with the onboard spa.  Using the information within the Cruise Ship Analytics solution, especially the demographic breakdown, the management teams were able to figure out what the profile was of those spending at the spa and to whom they needed to get marketing information and what specific products and services they needed to market. Since the launch of the Cruise Ship Analytics solution, the South American vessel has now been able to consistently achieve its revenue targets.  


Lead Time

Report lead-time has been reduced from up to 14 days to being refreshed 4-times per day (every 6 hours).



User adoption within the client's Shipboard and Shore-side Management groups has been very high.  The solution currently supports over 150 users who are experiencing response times ranging from 0-30 seconds.  An additional 150 users are scheduled to be added.


Comments not added yet!

Your future starts today. Ready?