Jamul Casino · Gaming & Hospitality · Jamul, CA · 1 quarter
4GB Access database replaced with real-time Snowflake in one quarter
Jamul Casino relied on a 4GB Microsoft Access file that updated once a day, causing slot performance decisions to lag by 24 hours. We moved their data to Snowflake and set up hourly refreshes. This shift allowed the casino to optimize slot floor operations in near real-time, resulting in $1.4 million in additional revenue within six months.
Challenge
The casino’s floor analytics team relied on a 4GB Microsoft Access database updated just once a day to decide slot placement and denominations. This delay meant floor managers worked with data that was 12 to 36 hours old. As a result, they moved high-performing machines off the floor prematurely and kept underperforming ones too long. The outdated data blocked timely, effective decisions.
Outcome
We cut data lag from up to 36 hours down to under an hour, enabling floor managers to make slot placement decisions within the same day. This real-time approach added $1.4 million in slot revenue over six months. We also automated compliance reporting, saving 2.6 full-time employees’ worth of work each year.
Results
- $1.4M Incremental slot revenue in 6 months
- 55 min Data lag vs. 12 to 36 hours prior
- 2.6 FTE Compliance labor saved annually
- 1 qtr Full migration timeline
Before, we were making million-dollar decisions based on data that was a day and a half old. Thinklytics brought that down to 55 minutes, and we saw the revenue impact almost immediately.