Name: Coffee Sales Insights Report
Creator: Kaggle
License: https://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

Coffee Sales Insights Report

About Dataset

This dataset contains 3,547 coffee sales transactions recorded across different times of the day, days of the week, and months of the year. It captures not only what type of coffee was purchased but also when and how much was spent. The dataset can be used to analyze customer buying behavior, peak sales periods, and product preferences.

Content

Hour_of_day Hour of purchase (6 AM – 10 PM).

Cash_type Payment method (all transactions via card).

Money Transaction amount (18.12 – 38.7 currency units).

Coffee_name Type of coffee purchased (Latte, Americano, Cappuccino, etc.).

Time_of_Day Morning, Afternoon, or Evening.

Weekday / Weekdaysort → Day of the week (Mon–Sun).

Month_name / Monthsort → Month of the year (Jan–Dec).

Date Transaction date.

Time Exact purchase timestamp.

Covers 12 months of sales data (2024).

Most popular coffee: Americano with Milk.

Highest sales period: Afternoons and Tuesdays.

Spending per transaction averages around 31.6 units.

Tables

Coffe Sales

@kaggle.sidraaazam_coffee_sales_insights_report.coffe_sales

59.46 kB
3,547 rows
11 columns

CREATE TABLE coffe_sales (
  "hour_of_day" BIGINT,
  "cash_type" VARCHAR,
  "money" DOUBLE,
  "coffee_name" VARCHAR,
  "time_of_day" VARCHAR,
  "weekday" VARCHAR,
  "month_name" VARCHAR,
  "weekdaysort" BIGINT,
  "monthsort" BIGINT,
  "date" TIMESTAMP,
  "time" VARCHAR
);