KETTLE & BEAN CO. PRACTICE DATASET (2023)
Free from Virtavis Learning  ·  virtavis.com
Created by Sophie Lumpa, Data and Business Intelligence Specialist

A full year (1 January to 31 December 2023) of realistic sales data from Kettle & Bean Co.,
a fictional UK coffee, tea and kitchenware retailer with 12 shops and a website.

FILES (all four hold the same data)
  Kettle_and_Bean_2023.xlsx             Excel: one sheet per table, plus a Start here sheet
  csv/                                  one CSV per table (UTF-8), for Power BI, Python or any tool
  kettle_and_bean_2023.db               SQLite database: open with DB Browser for SQLite or Python sqlite3
  kettle_and_bean_2023_postgresql.sql   PostgreSQL: run in pgAdmin's Query Tool on an empty database

TABLES
  stores            13 rows   The 12 shops and the website, with region, type and opening date.
  categories         6 rows   The six product categories.
  products         118 rows   Every product on sale in 2023, with its 2023 price and unit cost.
  customers      5,027 rows   Everyone who had signed up by 31 December 2023.
  employees         81 rows   Head office, regional and shop staff, with who reports to whom.
  campaigns          3 rows   Marketing campaigns running in 2023 and their discount codes.
  orders         8,667 rows   One row per order placed in 2023, in a shop or online.
  order_items   19,747 rows   One row per product line on an order.
  returns          820 rows   Returned items from 2023 orders, with reason and refund.
  sales_lines   19,747 rows   Ready-made flat table: one row per order line with names and revenue already added. Built for PivotTables.

CHECK FIGURES
  Completed orders: 8,407
  Revenue from order lines (completed orders): £334,089.83

The data contains a few problems on purpose, just like real company data.
The guide (Kettle_and_Bean_Practice_Dataset_Guide.pdf) has the data dictionary,
check figures, a data health check and 20 practice questions.

Want all three years (2023 to 2025) and guided projects? Every course in the
Virtavis Data Analyst Path is built on Kettle & Bean Co.
Start the course › virtavis.com

(c) 2026 Sophie Lumpa, Virtavis Learning. All people and companies are fictional.
Free to use for learning and in your portfolio, with credit to Virtavis Learning.
To share it, please link to virtavis.com rather than passing on the files.
