Dataset: Store 20 Retail Data Analytics

About this Dataset

Store 20 Retail Data Analytics

About

This dataset is based on https://www.kaggle.com/manjeetsingh/retaildataset

Historical sales data covers the period from 2010-02-05 to 2012-11-01. Sales and Features data was merged, Weekly sales were estimated at total store level, and only data for Store = 20 was selected.

Columns

Date - the week
Temperature - average temperature in the region
Fuel_Price - cost of fuel in the region
- MarkDown1-5 - anonymized data related to promotional markdowns. MarkDown data is only available after Nov 2011, and is not available for all stores all the time. Any missing value is marked with an NA
  CPI - the consumer price index
Unemployment - the unemployment rate
IsHoliday - whether the week is a special holiday week
Weekly_Sales - sales in the given date (week)

The original dataset was obtained here:
https://www.kaggle.com/manjeetsingh/retaildataset

Tables

Sales Data

@kaggle.gbecon_store_20_retail_data_analytics.sales_data

16.73 KB
149 rows
12 columns


CREATE TABLE sales_data (
  "date" TIMESTAMP,
  "isholiday" BOOLEAN,
  "weekly_sales" DOUBLE,
  "temperature" DOUBLE,
  "fuel_price" DOUBLE,
  "markdown1" DOUBLE,
  "markdown2" DOUBLE,
  "markdown3" DOUBLE,
  "markdown4" DOUBLE,
  "markdown5" DOUBLE,
  "cpi" DOUBLE,
  "unemployment" DOUBLE
);