Baselight

Coffee Sales Information

coffee sales by time, quality ,and payments

@kaggle.afnansaifafnan_coffee_sales_information

Loading...
Loading...

About this Dataset

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.).

Tables

Coffe Sales

@kaggle.afnansaifafnan_coffee_sales_information.coffe_sales
  • 59.46 kB
  • 3,547 rows
  • 11 columns
Loading...
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
);

Share link

Anyone who has the link will be able to view this.