Name: Exploration Of Dunhumby Product Transaction Data
Creator: Kaggle
License: http://opendatacommons.org/licenses/dbcl/1.0/

About this Dataset

Exploration Of Dunhumby Product Transaction Data

This data analysis uses Hive 2.0 (IDE for SQL) to explore product data from the Dunhumby dataset. It involves the product.csv and transaction_data.csv files. The analysis involves creating views to find the most productive departments within two years and determining where marketing strategies should be implemented for future sales growth.

Tables

Product

@kaggle.skoch2500_exploration_of_dunhumby_product_transaction_data.product

1.27 MB
92,353 rows
7 columns

CREATE TABLE product (
  "product_id" BIGINT,
  "manufacturer" BIGINT,
  "department" VARCHAR,
  "brand" VARCHAR,
  "commodity_desc" VARCHAR,
  "sub_commodity_desc" VARCHAR,
  "curr_size_of_product" VARCHAR
);

Transaction Data

@kaggle.skoch2500_exploration_of_dunhumby_product_transaction_data.transaction_data

21.78 MB
2,595,732 rows
12 columns

CREATE TABLE transaction_data (
  "household_key" BIGINT,
  "basket_id" BIGINT,
  "day" BIGINT,
  "product_id" BIGINT,
  "quantity" BIGINT,
  "sales_value" DOUBLE,
  "store_id" BIGINT,
  "retail_disc" DOUBLE,
  "trans_time" BIGINT,
  "week_no" BIGINT,
  "coupon_disc" DOUBLE,
  "coupon_match_disc" DOUBLE
);