Retail Insights: A Comprehensive Sales Dataset

Uncover Trends, Optimize Strategies, and Excel in Retail Analytics with this Rob

@kaggle.rajneesh231_retail_insights_a_comprehensive_sales_dataset

Table List

1 table(211.84 KB)

Data

@kaggle.rajneesh231_retail_insights_a_comprehensive_sales_dataset.data

211.84 KB
5000 rows
24 columns

order_no Order No	order_date Order Date	customer_name Customer Name	address Address	city City	state State	customer_type Customer Type	account_manager Account Manager	order_priority Order Priority	product_name Product Name	product_category Product Category	product_container Product Container	ship_mode Ship Mode	ship_date Ship Date	cost_price Cost Price	retail_price Retail Price	profit_margin Profit Margin	order_quantity Order Quantity	sub_total Sub Total	discount Discount %	discount_66c100 Discount $	order_total Order Total	shipping_cost Shipping Cost	total Total
4293-1	02-09-2014	Vivek Sundaresam	152 Bunnerong Road,Eastgardens	Sydney	NSW	Small Business	Tina Carlton	Critical	UGen Ultra Professional Cordless Optical Suite	Office Supplies	Small Box	Regular Air	04-09-2014	$156.50	$300.97	$144.47	23	$4,533.52	2%	$194.83	$4,757.22	$7.18	$4,291.55
5001-1	24-10-2015	Shahid Hopkins	438 Victoria Avenue,Chatswood	Sydney	NSW	Corporate	Natasha Song	Medium	Bagged Rubber Bands	Office Supplies	Small Pack	Regular Air	26-10-2015	$0.24	$1.26	$1.02	8	$45.20	3%	$0.00	$45.90	$0.70	$46.91
5004-1	13-03-2014	Dennis Pardue	412 Brunswick St,Fitzroy	Melbourne	VIC	Consumer	Connor Betts	Not Specified	TechSavi Cordless Navigator Duo	Office Supplies	Small Box	Regular Air	13-03-2014	$42.11	$80.98	$38.87	45	$873.32	4%	$72.23	$837.57	$7.18	$82.58
5009-1	18-02-2013	Sean Wendt	145 Ramsay St,Haberfield	Sydney	NSW	Small Business	Phoebe Gour	Critical	Artisan Printable Repositionable Plastic Tabs	Office Supplies	Wrap Bag	Regular Air	20-02-2013	$5.33	$8.60	$3.27	16	$73.52	1%	$4.35	$740.67	$6.19	$730.92
5010-1	13-09-2014	Christina Vanderzanden	188 Pitt Street,Sydney	Sydney	NSW	Small Business	Tina Carlton	Not Specified	Pizazz Drawing Pencil Set	Office Supplies	Wrap Bag	Express Air	17-09-2014	$1.53	$2.78	$1.25	49	$138.46	7%	$5.95	$123.77	$1.34	$125.97
5011-1	24-11-2013	Patrick OBrill	53 Riley Street,Woolloomooloo	Sydney	NSW	Home Office	Tina Carlton	Not Specified	Alto Parchment Paper, Assorted Colors	Office Supplies	Wrap Bag	Regular Air	26-11-2013	$4.59	$7.28	$2.69	45	$197.36	8%	$12.98	$183.58	$11.15	$189.43
5012-1	07-09-2014	Eugene Moren	85-113 Dunning Ave,Rosebery	Sydney	NSW	Consumer	Mihael Khan	Not Specified	Smiths Metal Binder Clips	Office Supplies	Small Box	Regular Air	07-09-2014	$1.60	$2.62	$1.02	45	$65.50	4%	$5.90	$59.62	$0.80	$60.45
5012-1	28-01-2015	Phillip Flathmann	Macquarie Centre Cnr Herring Road & Waterloo Road,Macquarie Park	Sydney	NSW	Home Office	Nicholas Fernandes	Medium	Smiths Metal Binder Clips	Technology	Small Box	Regular Air	29-01-2015	$1.60	$2.62	$1.02	34	$24.92	2%	$2.49	$22.43	$0.80	$27.43
5014-1	08-06-2014	John Lee	180 High Street,Windsor	Melbourne	VIC	Home Office	Connor Betts	Not Specified	Artisan Hole Reinforcements	Office Supplies	Wrap Bag	Regular Air	10-06-2014	$3.99	$6.23	$2.24	25	$194.36	10%	$15.93	$178.12	$6.97	$189.45
5015-1	02-10-2014	Ritsa Hightower	1/160 Anzac Parade,Kensington	Sydney	NSW	Corporate	Natasha Song	Critical	UGen Ultra Professional Cordless Optical Suite	Office Supplies	Small Box	Regular Air	04-10-2014	$156.50	$300.97	$144.47	42	$1,079.62	4%	$30.83	$1,753.33	$7.18	$1,705.42


CREATE TABLE data (
  "order_no" VARCHAR,
  "order_date" VARCHAR,
  "customer_name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "customer_type" VARCHAR,
  "account_manager" VARCHAR,
  "order_priority" VARCHAR,
  "product_name" VARCHAR,
  "product_category" VARCHAR,
  "product_container" VARCHAR,
  "ship_mode" VARCHAR,
  "ship_date" VARCHAR,
  "cost_price" VARCHAR,
  "retail_price" VARCHAR,
  "profit_margin" VARCHAR,
  "order_quantity" DOUBLE,
  "sub_total" VARCHAR,
  "discount" VARCHAR,
  "discount_66c100" VARCHAR,
  "order_total" VARCHAR,
  "shipping_cost" VARCHAR,
  "total" VARCHAR
);