4GB Access database replaced with real-time Snowflake in one quarter

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.

Approach

We moved the floor analytics from Access to Snowflake to handle larger data volumes and improve speed. We set up real-time data feeds from the slot management system, updating hourly during normal peak hours and every 15 minutes during heavy traffic. Then, we created a Tableau dashboard to display live machine performance, denomination breakdowns, and actionable floor management insights.

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.

How real-time data completely changed the way we make decisions

At the start, floor managers only had weekly reports, so they were always a bit behind the game. When we introduced real-time data, the team pretty much ignored it for the first three weeks. But once they finally dug in and used the fresh info, their decisions got way sharper.

We hooked up data refreshes to run every 15 minutes. That way, we stayed on top of those wild traffic spikes without missing a beat.

Here’s the deal. Before, the data only refreshed once an hour. So when it got busy, think Friday nights or holidays, everything slowed down because managers didn’t have fresh info. We fixed that by setting up a schedule that speeds things up during those peak times. Now, data updates every 15 minutes when it matters most. That way, floor managers get what they need significantly faster and can jump on it immediately.

We cleaned up the compliance reporting chaos by changing how the team gets things done.

When we moved everything to Snowflake, it was a meaningful shift. We ended up freeing up what felt like 2.6 full-time people every year just by automating compliance reports. How? We built workflows that automatically generate the reports and shoot them straight to the gaming commission. No more manual grunt work, no more chasing down paperwork. It just runs, hands-off.

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

In the client's terms

The question

Where does this number come from, and can the path be trusted?

The situation

Floor analytics ran on a 4GB Access database refreshed once a day, so managers were deciding slot placement and denomination on data 12 to 36 hours old. Strong machines were being pulled early and weak ones left too long.

What we found

Every decision the team made was correct for the data in front of them and wrong for the floor. The problem was latency, not judgement, and no amount of better reporting on a daily refresh would have closed it.

What it produced

Data lag fell from up to 36 hours to under an hour, which puts placement decisions inside the same day. $1.4M in incremental slot revenue over six months. Compliance reporting was automated, saving 2.6 FTE a year.

The roadmap

Floor analytics moved off Access onto Snowflake, which removes the volume ceiling as well as the speed one. Real-time feeds from the slot management system, hourly at normal load and every 15 minutes at peak. A Tableau view showing live machine performance and denomination breakdown in the terms floor managers already use.

The work behind this result

• Reporting takes too much work, the problem this engagement resolved.
• AI Reporting Automation for Tableau & Power BI
• Business Intelligence & Analytics Consulting
• Agentic BI Implementation Consulting
• Reporting Baseline and Benefits Worksheet, for whoever has to approve the spend.
• The 30 day Corporate Drag and Risk Diagnostic, findings yours either way.

Related case studies

• Deployed revenue analytics on 8 vessels to uncover $2.1M in upsell opportunities and cut inventory waste by $380K annually.
• We developed R&D portfolio analytics covering 8 programs to give the board a clear, consolidated view of pipeline value.
• We helped 67 school districts replace manual IPEDS reporting with one platform in 14 weeks, cutting $1.9M in yearly labor costs.
• Aligned ARR, NRR, and churn data across finance, product, and sales to resolve a $2.1M reporting gap for the board