Coffee Sales Dataset
Coffee Sales Data Analysis
@kaggle.saadaliyaseen_coffee_sales_dataset
Coffee Sales Data Analysis
@kaggle.saadaliyaseen_coffee_sales_dataset
This dataset contains detailed reports of coffee sales transactions. It includes information such as the type of coffee sold, payment method, sale amount, and the exact time and date of purchase. The data is structured with aspects for hours, weekdays, months, and time of day, making it useful for analyzing sales patterns, customer preferences, and business performance across different time Structures.
hour_of_day– Numerical values (0–23) showing at what hour the purchase was made.
**cash_type **– Payment method used (e.g., cash, card).
money – The sale amount (in currency).
**coffee_name **– Name of the coffee product (e.g., Latte, Americano, Hot Chocolate).
**Time_of_Day **– Categorized time period (Morning, Afternoon, Evening, etc.).
Weekday – Day of the week (e.g., Mon, Tue, Fri).
Month_name – Month of sale (e.g., Jan, Feb, Mar).
**Weekdaysort **– Numeric order of the weekday (e.g., 1 = Monday, … 7 = Sunday).
Monthsort – Numeric order of the month (e.g., 1 = January, … 12 = December).
**Date **– Full date of the transaction (YYYY-MM-DD).
Time – Exact transaction time (HH:MM:SS).
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
);
Anyone who has the link will be able to view this.