Practice Datasets

Sunshine Grocers is a fictional Florida grocery chain with two years of realistic sales (2024–2025). Use it to practice Excel, Power BI, Tableau, SQL and Python — every Academy mission uses it.

Flat sales table

28,742 rows, ready for pivot tables and Power BI.

⬇ .xlsx ⬇ .csv

Full database

9 related tables for data modeling and SQL.

⬇ Excel ⬇ SQLite ⬇ CSV .zip

Messy data for cleaning

627 rows with spaces, wrong case, text numbers, mixed dates and duplicates.

⬇ .xlsx ⬇ .csv

Tables

Table	What's inside	Columns
`stores`	12 stores across 4 Florida regions	store_id, store_name, city, state, region, store_type, open_date, square_feet	CSV
`products`	27 products in 6 categories	product_id, product_name, category, brand, unit_cost, unit_price	CSV
`customers`	1,200 customers with segment and loyalty flag	customer_id, first_name, last_name, city, state, segment, signup_date, loyalty_member	CSV
`orders`	9,665 orders (2024–2025)	order_id, order_date, customer_id, store_id, channel, payment_method	CSV
`order_items`	28,742 order lines with quantity, price and discount	order_item_id, order_id, product_id, quantity, unit_price, discount	CSV
`inventory`	Stock on hand and reorder points	store_id, product_id, snapshot_date, on_hand, reorder_point	CSV
`employees`	102 employees with roles, managers and pay rates	employee_id, first_name, last_name, store_id, role, hire_date, manager_id, hourly_rate	CSV
`campaigns`	48 marketing campaigns with spend and results	campaign_id, campaign_name, channel, start_date, end_date, budget, impressions, clicks, conversions, revenue	CSV
`budget`	Monthly revenue and expense budget per store	month, store_id, revenue_budget, expense_budget	CSV

Net sales formula: quantity × unit_price × (1 − discount). Relationships: order_items → orders → customers/stores; order_items → products; inventory and budget link by store_id.

Query it now in the SQL Playground →Start the missions

All names, stores and figures are fictional. Free to use for learning.