Comprehensive Supply Chain Analysis

Optimizing Operations for Efficiency and Customer Satisfaction

@kaggle.dorothyjoel_us_regional_sales

Table List

1 table(200.58 KB)

Us Regional Sales Data

@kaggle.dorothyjoel_us_regional_sales.us_regional_sales_data

200.58 KB
7991 rows
16 columns

ordernumber OrderNumber	sales_channel Sales Channel	warehousecode WarehouseCode	procureddate ProcuredDate	orderdate OrderDate	shipdate ShipDate	deliverydate DeliveryDate	currencycode CurrencyCode	n__salesteamid SalesTeamID	n__customerid CustomerID	n__storeid StoreID	n__productid ProductID	order_quantity Order Quantity	discount_applied Discount Applied	unit_cost Unit Cost	unit_price Unit Price
SO - 000101	In-Store	WARE-UHY1004	31/12/17	31/5/18	14/6/18	19/6/18	USD	6	15	259	12	5	0.08	$1,001.18	$1,963.10
SO - 000102	Online	WARE-NMK1003	31/12/17	31/5/18	22/6/18	2/7/2018	USD	14	20	196	27	3	0.08	$3,348.66	$3,939.60
SO - 000103	Distributor	WARE-UHY1004	31/12/17	31/5/18	21/6/18	1/7/2018	USD	21	16	213	16	1	0.05	$781.22	$1,775.50
SO - 000104	Wholesale	WARE-NMK1003	31/12/17	31/5/18	2/6/2018	7/6/2018	USD	28	48	107	23	8	0.08	$1,464.69	$2,324.90
SO - 000105	Distributor	WARE-NMK1003	10/4/2018	31/5/18	16/6/18	26/6/18	USD	22	49	111	26	8	0.1	$1,476.14	$1,822.40
SO - 000106	Online	WARE-PUJ1005	31/12/17	31/5/18	8/6/2018	13/6/18	USD	12	21	285	1	5	0.05	$446.56	$1,038.50
SO - 000107	In-Store	WARE-XYS1001	31/12/17	31/5/18	8/6/2018	14/6/18	USD	10	14	6	5	4	0.15	$536.67	$1,192.60
SO - 000108	In-Store	WARE-PUJ1005	10/4/2018	31/5/18	26/6/18	1/7/2018	USD	6	9	280	46	5	0.05	$1,525.19	$1,815.70
SO - 000109	In-Store	WARE-PUJ1005	31/12/17	01/06/2018	16/6/18	21/6/18	USD	4	9	299	47	4	0.3	$2,211.20	$3,879.30
SO - 000110	In-Store	WARE-UHY1004	31/12/17	01/06/2018	29/6/18	1/7/2018	USD	10	33	261	13	8	0.05	$1,212.97	$1,956.40


CREATE TABLE us_regional_sales_data (
  "ordernumber" VARCHAR,
  "sales_channel" VARCHAR,
  "warehousecode" VARCHAR,
  "procureddate" VARCHAR,
  "orderdate" VARCHAR,
  "shipdate" VARCHAR,
  "deliverydate" VARCHAR,
  "currencycode" VARCHAR,
  "n__salesteamid" BIGINT,
  "n__customerid" BIGINT,
  "n__storeid" BIGINT,
  "n__productid" BIGINT,
  "order_quantity" BIGINT,
  "discount_applied" DOUBLE,
  "unit_cost" VARCHAR,
  "unit_price" VARCHAR
);