Dataset: Supermarket Sales Dataset

About this Dataset

Supermarket Sales Dataset

"Supermarket Sales Data: This dataset records individual transactions from a supermarket chain in Myanmar, with detailed attributes for each sale. The data includes the following columns:

Invoice ID: Unique identifier for each transaction.
Branch: The branch location of the supermarket (e.g., Yangon, Naypyitaw, Mandalay).
City: The city in which the supermarket branch is located.
Customer Type: Indicates whether the customer is a 'Member' or 'Normal'.
Gender: Gender of the customer.
Product Line: The category of the product sold (e.g., Health & Beauty, Electronic Accessories, Home & Lifestyle).
Unit Price: Price per unit of the product.
Quantity: Number of items purchased.
Tax 5%: Calculated tax amount on the transaction at a 5% rate.
Total: Total amount for the transaction including tax.
Date: Date of the transaction.
Time: Time of the transaction.
Payment: Payment method used (e.g., Cash, Ewallet, Credit card).
COGS: Cost of goods sold, representing the raw cost of the products.
Gross Margin Percentage: Fixed percentage of profit for each sale (4.7619%).
Gross Income: Profit earned from the transaction.
Rating: Customer satisfaction rating (out of 10).

This dataset can be used for analyzing sales patterns, customer preferences, and payment behaviors, making it ideal for machine learning, business analytics, and data visualization projects."

Tables

Supermarket Analysis

@kaggle.faresashraf1001_supermarket_sales.supermarket_analysis

62.29 KB
1000 rows
17 columns


CREATE TABLE supermarket_analysis (
  "invoice_id" VARCHAR,
  "branch" VARCHAR,
  "city" VARCHAR,
  "customer_type" VARCHAR,
  "gender" VARCHAR,
  "product_line" VARCHAR,
  "unit_price" DOUBLE,
  "quantity" BIGINT,
  "tax_5" DOUBLE,
  "sales" DOUBLE,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "payment" VARCHAR,
  "cogs" DOUBLE,
  "gross_margin_percentage" DOUBLE,
  "gross_income" DOUBLE,
  "rating" DOUBLE
);