Thinklytics

Gulf Coast Cruise Line · Gaming & Hospitality · New Orleans, LA · 16 weeks

Onboard revenue analytics deployed across 8 vessels

Gulf Coast Cruise Line couldn’t track revenue by vessel, which blocked their ability to manage onboard sales effectively. We developed a real-time analytics platform that tracked food and beverage, excursions, and spa revenue across 8 ships. This uncovered $2.1 million in upsell opportunities and cut inventory waste by $380,000 a year.

Challenge

The revenue team couldn’t track onboard revenue in real time. Data from food and beverage, excursions, and spa came from separate systems on each ship and was manually combined into weekly Excel reports. By the time these reports were ready, the voyage had ended, and any chance to act had passed.

Approach

We set up a satellite data pipeline to send revenue data from all 8 vessels to a central Snowflake database every 2 hours. Then, we created a Power BI dashboard that tracked performance by vessel, revenue category, and voyage day. The dashboard also triggered alerts when any revenue category dropped below target.

Outcome

By week 16, we had real-time analytics running on all 8 vessels. The revenue team used this data to pinpoint $2.1M in annual upsell potential by mapping underperforming revenue categories to specific routes. We cut inventory waste by $380K a year by adjusting provisioning to match demand patterns unique to each voyage.

How We Fixed Those Pesky Satellite Connectivity Glitches in Our Network

The toughest part? Grabbing data from ships way out at sea. So, we built a satellite pipeline that chops the data down and sends updates every two hours. When the connection dropped, the ships just stored everything locally and synced up as soon as the signal came back. Easy, solid, no headaches.

How we broke down demand for every single voyage

Demand was all over the map depending on the route. Caribbean trips brought in $180K more spa revenue per voyage than the Gulf routes. Alaska cruises? They had three times the excursion attachment rate. We grabbed these insights and teamed up with provisioning to tailor inventory for each route instead of just using fleet-wide averages.

How we set up real-time alerts to catch underperforming categories instantly

Here’s what we did: we put an alert in place to catch any category that was more than $12K behind its daily target by day 3 of the trip. That way, the revenue manager got a quick heads-up and could launch targeted promos right when they mattered most, mid-voyage. In the first month alone, those alerts added an extra $140K. Frankly, that’s cash we probably would’ve missed if we hadn’t caught it early.

Results

  • $2.1M Annual upsell opportunity identified
  • $380K Annual inventory waste reduced
  • 8 Vessels with real-time analytics
  • 2 hrs Data transmission cycle

Before, we only got weekly reports after voyages were done. By then, it was too late to make any changes. Now, we get real-time updates and can jump in right away if something comes up.

Chief Revenue Officer, Gulf Coast Cruise Line

In the client's terms

The question

What decisions is this reporting supposed to support?

The situation

Onboard revenue from food and beverage, excursions and spa sat in separate systems on each of eight vessels, combined by hand into weekly Excel. By the time a report existed the voyage was over.

What we found

Nothing in the reporting was wrong. It was simply arriving after the only window in which anyone could act on it, which made the whole exercise a record rather than a decision tool.

What it produced

All eight vessels live by week 16. Mapping underperforming categories to specific routes identified $2.1M a year in upsell opportunity. Matching provisioning to per-voyage demand patterns cut inventory waste by $380K a year.

The roadmap

A satellite pipeline moving revenue data off all eight vessels into central Snowflake every two hours, because the constraint was connectivity rather than analytics. A Power BI view by vessel, revenue category and voyage day, with alerts when a category falls below target mid-voyage rather than after it.

The work behind this result

Related case studies

Frequently asked questions

How do you get analytics off ships at sea?

Design for the connection dropping. Gulf Coast Cruise Line's pipeline compresses aggressively and transmits every two hours, and when the satellite link fails the vessel buffers locally and syncs on reconnection rather than losing the window.

Why does onboard revenue reporting arrive too late to use?

Because it is assembled after the voyage. Here, revenue from food and beverage, excursions and spa sat in separate systems on each of eight vessels and was combined by hand into weekly Excel. Alerts now fire mid-voyage when a category falls behind target, which added $140K in the first month.

Should cruise provisioning be planned per route?

Yes, where demand differs by route. Caribbean voyages here generated $180K more spa revenue per sailing than Gulf routes and Alaska sailings ran three times the excursion attachment rate, so fleet-wide averages were wrong in both directions. Route-level provisioning cut $380K a year in waste.