Coffee Sales Information
coffee sales by time, quality ,and payments
@kaggle.afnansaifafnan_coffee_sales_information
coffee sales by time, quality ,and payments
@kaggle.afnansaifafnan_coffee_sales_information
This dataset tells us about comprehensive information on coffee sales. It includes details such as the type of coffee purchased (e.g., Latte, Americano, Hot Chocolate), the amount of money spent, and the payment method (cash or card). Each record also contains the exact date and time of purchase with the corresponding hour of the day, weekday, and month. Moreover, it categorizes **the time of day into morning, afternoon **,etc., which helps in identifying sales patterns. This dataset is useful for visualizing
customer buying behavior, peak sales hours, seasonal trends, and preferred payment types in a coffee shop setting.
day hour : sales' hours(0-23)
cash type : Payment method (cash ya card).
money : Sales' amount (price paid).
coffee name : Type of Coffee (e.g.,Latte, Americano, Hot Chocolate, etc.).
Time of Day : According to day time (Morning, Afternoon, Evening, Night).
Weekday : Days off sales (Mon, Tue, etc.).
Month_name : Sales' months(Jan, Feb, Mar, etc.).
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.