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.