Retail Data Analytics

Historical sales data from 45 stores

@kaggle.manjeetsingh_retaildataset

Sales Data Set

@kaggle.manjeetsingh_retaildataset.sales_data_set

store Store	dept Dept	date Date	weekly_sales Weekly Sales	isholiday IsHoliday
1	1	Fri Feb 05 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	24924.5
1	1	Fri Feb 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	46039.49	true
1	1	Fri Feb 19 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	41595.55
1	1	Fri Feb 26 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	19403.54
1	1	Fri Mar 05 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	21827.9
1	1	Fri Mar 12 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	21043.39
1	1	Fri Mar 19 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	22136.64
1	1	Fri Mar 26 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	26229.21
1	1	Fri Apr 02 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	57258.43
1	1	Fri Apr 09 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	42960.91


CREATE TABLE sales_data_set (
  "store" BIGINT,
  "dept" BIGINT,
  "date" TIMESTAMP,
  "weekly_sales" DOUBLE,
  "isholiday" BOOLEAN
);