Sales Data

A Comprehensive Dataset on Product Performance & External Factors

@kaggle.data667_sales_data

Table List

1 table(126.39 KB)

Sales Dataset

@kaggle.data667_sales_data.sales_dataset

126.39 KB
4444 rows
18 columns

product_id Product ID	product_name Product Name	category Category	units_sold Units Sold	revenue Revenue	order_date Order Date	delivery_date Delivery Date	inventory_level Inventory Level	customer_id Customer ID	season Season	holiday Holiday	location Location	lead_time Lead Time	supplier_performance Supplier Performance	social_media_mentions Social Media Mentions	external_events External Events	quality_control Quality Control	price Price
TV001	LG OLED TV	Tv	12	17988	Mon Jan 01 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	180	Cust_882	January	1	Ahmedabad	4	0.9482962003760528	57	1	Fail	1499
SP002	iPhone 12	Smartphone	12	11988	Tue Jan 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	95	Cust_247	January		Delhi	3	0.9463730419801089	41		Fail	999
LT002	Dell XPS	Laptop	17	22083	Tue Jan 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	120	Cust_448	January	1	Bangalore	3	0.8470907943930852	63		Pass	1299
TV003	Sony BRAVIA OLED TV	Tv	14	25186	Tue Jan 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	191	Cust_319	January	1	Kolkata	3	0.8971183624594566	86	1	Fail	1799
CAM001	Canon EOS Rebel DSLR Camera	Camera	17	13583	Tue Jan 02 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Jan 06 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	55	Cust_641	January	1	Ahmedabad	4	0.9569175831213296	63	1	Fail	799
CAM002	Sony Alpha Mirrorless Camera	Camera	4	3996	Wed Jan 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 04 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	87	Cust_813	January		Bangalore	1	0.9835054896010134	34		Pass	999
HP002	Sony WH-1000XM4 Wireless Headphones	Headphones	10	3490	Wed Jan 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Sat Jan 06 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	113	Cust_195	January	1	Ahmedabad	3	0.8023258674456617	91	1	Pass	349
SP002	iPhone 12	Smartphone	14	13986	Wed Jan 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Thu Jan 04 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	116	Cust_132	January	1	Kolkata	1	0.8577739764835877	44		Fail	999
LT002	Dell XPS	Laptop	1	1299	Wed Jan 03 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Sun Jan 07 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	161	Cust_724	January		Kolkata	4	0.9899691927488606	67		Pass	1299
SP002	iPhone 12	Smartphone	13	12987	Thu Jan 04 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Jan 05 2018 00:00:00 GMT+0000 (Coordinated Universal Time)	153	Cust_650	January		Kolkata	1	0.8855537610207144	6	1	Fail	999


CREATE TABLE sales_dataset (
  "product_id" VARCHAR,
  "product_name" VARCHAR,
  "category" VARCHAR,
  "units_sold" BIGINT,
  "revenue" BIGINT,
  "order_date" TIMESTAMP,
  "delivery_date" TIMESTAMP,
  "inventory_level" BIGINT,
  "customer_id" VARCHAR,
  "season" VARCHAR,
  "holiday" BIGINT,
  "location" VARCHAR,
  "lead_time" BIGINT,
  "supplier_performance" DOUBLE,
  "social_media_mentions" BIGINT,
  "external_events" BIGINT,
  "quality_control" VARCHAR,
  "price" BIGINT
);