US Regional Sales Data

US Regional Sales Data Analysis and Prediction

@kaggle.talhabu_us_regional_sales_data

Table List

1 table(191.23 KB)

Us Regional Sales Data

@kaggle.talhabu_us_regional_sales_data.us_regional_sales_data

191.23 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.075	1001.18	1963.1
SO - 000102	Online	WARE-NMK1003	31/12/17	31/5/18	22/6/18	2/7/18	USD	14	20	196	27	3	0.075	3348.66	3939.6
SO - 000103	Distributor	WARE-UHY1004	31/12/17	31/5/18	21/6/18	1/7/18	USD	21	16	213	16	1	0.05	781.22	1775.5
SO - 000104	Wholesale	WARE-NMK1003	31/12/17	31/5/18	2/6/18	7/6/18	USD	28	48	107	23	8	0.075	1464.69	2324.9
SO - 000105	Distributor	WARE-NMK1003	10/4/18	31/5/18	16/6/18	26/6/18	USD	22	49	111	26	8	0.1	1476.14	1822.4
SO - 000106	Online	WARE-PUJ1005	31/12/17	31/5/18	8/6/18	13/6/18	USD	12	21	285	1	5	0.05	446.56	1038.5
SO - 000107	In-Store	WARE-XYS1001	31/12/17	31/5/18	8/6/18	14/6/18	USD	10	14	6	5	4	0.15	536.67	1192.6
SO - 000108	In-Store	WARE-PUJ1005	10/4/18	31/5/18	26/6/18	1/7/18	USD	6	9	280	46	5	0.05	1525.19	1815.7
SO - 000109	In-Store	WARE-PUJ1005	31/12/17	1/6/18	16/6/18	21/6/18	USD	4	9	299	47	4	0.3	2211.2	3879.3
SO - 000110	In-Store	WARE-UHY1004	31/12/17	1/6/18	29/6/18	1/7/18	USD	10	33	261	13	8	0.05	1212.97	1956.4


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" DOUBLE,
  "unit_price" DOUBLE
);