All projects

Consumer · Sales

Illinois Lottery Sales & Consumer Analytics

PythonSQLPower BIExcel
Sales analytics visualization with a heat map of Illinois, bar charts, and a donut chart

Business Problem

Statewide lottery sales data is fragmented across products, regions, and retail channels, obscuring the consumer patterns that drive revenue.

Exploratory analysis and segmentation of sales by product, geography, and ticket type to reveal demand patterns, seasonal trends, and underperforming segments.

Approach

  1. 01

    Cleaned and joined multi-source sales data with Python and SQL to create a consistent analysis dataset.

  2. 02

    Segmented sales performance by product, region, and ticket type to expose demand patterns.

  3. 03

    Visualized geographic and seasonal trends to support consumer and marketing analysis.

Results & Findings

Detailed findings and dashboard walkthrough are being documented and will be published soon.