Customer Background

The state lottery commission is responsible for generating supplemental funding for public education through lottery sales. Multiple operational systems, legacy reporting tools, and departmental data silos limited the ability to get a unified, timely view of sales performance, retailer effectiveness, and product mix across the state.

Objective

The engagement objective was to design and implement a statewide business intelligence platform that consolidated disparate source systems into a centralized data warehouse and delivered transparent analytics to internal departments and executive leadership. The platform needed to support mission critical decisions aligned with the lottery commission's mandate to maximize contributions to public education.

Approach

  • Requirements and stakeholder alignment - Led workshops with Sales, Finance, Retail Operations, and Executive teams to validate reporting needs, KPIs, and forecasting requirements.
  • Data warehouse and architecture design - Built a scalable SQL Server data warehouse and semantic model to support sales, validation, product portfolio, and retailer performance analytics.
  • Integration and ETL - Implemented robust data ingestion processes to unify transactional, historical, and retailer data into a single governed platform.
  • Interactive dashboards - Delivered executive and departmental dashboards for statewide sales visibility, performance trending, and scenario-based forecasting.
  • Governance and lifecycle management - Established data quality rules, metric definitions, and release processes to ensure accuracy and long-term sustainability.

Outcomes

  • Centralized, trusted view of statewide lottery sales and product performance.
  • Improved forecasting accuracy using unified historical and near real time datasets.
  • Retailer coverage and performance analytics supporting targeted outreach and optimization.
  • Executive dashboards aligned with the lottery commission's mission to maximize education funding.
  • A scalable analytics platform capable of supporting future initiatives and new game offerings.

State Government Lottery | Executive Overview

Unified insight across validation sales, retailer performance, portfolio mix, and education funding

Total Validation Sales (YTD)

$15.3M

+8.4%

Previous YTD: $14.1M

Avg RoS per Retailer

$74.20

+2.1%

Based on active retail locations

Top Game Sales (YTD)

$3.8M

+11.6%

Flagship scratcher game performance

Retailer Coverage

96.3%

+1.1%

Counties with active lottery presence

Scratchers Sales (YTD)

$9.4M

+9.2%

Instant-win portfolio performance

Draw Game Sales (YTD)

$5.9M

+7.1%

Lotto and daily draw products

Prize Payout Ratio

62%

+0.8 pts

Prizes as a share of sales

Education Contribution (YTD)

$3.7M

+6.5%

Net transfers to education funds

Monthly Validation Sales and Rolling Average

Monthly Sales vs Target and Variance %

Scratcher Game Portfolio Mix (YTD)

Retailer Performance by Quartile

Regional Sales Intensity by Channel

YTD Allocation of Lottery Sales to Key Uses

*Dashboard simulated to respect customer confidentiality while reflecting realistic lottery performance and funding objectives.