Dataset: Bakery Sales Dataset

About this Dataset

Bakery Sales Dataset

Context

We live in the era of e-commerce and digital marketing. We have even small scale businesses going online as the opportunities are endless. Since a huge chunk of the people who have access to internet is switching to online shopping, large retailers are actively searching for ways to increase their profit. Market Basket analysis is one such key techniques used by large retailers to to increase sales by understanding the customers' purchasing behavior & patterns. Market basket analysis examines collections of items to find relationships between items that go together within the business context.

Content

The dataset belongs to "The Bread Basket" a bakery located in Edinburgh. The dataset provide the transaction details of customers who ordered different items from this bakery online during the time period from 30-10-2016 to 09-04-2017. The dataset has 20507 entries, over 9000 transactions, and 4 columns.

Variables

TransactionNo : unique identifier for every single transaction
Items : items purchased
DateTime : date and time stamp of the transactions
Daypart : part of the day when a transaction is made (morning, afternoon, evening, night)
DayType : classifies whether a transaction has been made in weekend or weekdays

Inspiration

The dataset is ideal for anyone looking to practice association rule mining and understand the business context of data mining for better understanding of the buying pattern of customers.

Tables

Bakery

@kaggle.akashdeepkuila_bakery.bakery

202.49 KB
20507 rows
5 columns


CREATE TABLE bakery (
  "transactionno" BIGINT,
  "items" VARCHAR,
  "datetime" TIMESTAMP,
  "daypart" VARCHAR,
  "daytype" VARCHAR
);

Bakery Sales Revised

@kaggle.akashdeepkuila_bakery.bakery_sales_revised

194.63 KB
20507 rows
5 columns


CREATE TABLE bakery_sales_revised (
  "transaction" BIGINT,
  "item" VARCHAR,
  "date_time" TIMESTAMP,
  "period_day" VARCHAR,
  "weekday_weekend" VARCHAR
);