SalesDataAnalysis

"Uncovering Profitable Insights: Navigating Sales Data for Strategic Growth"

@kaggle.aemyjutt_salesdata

Table List

1 table(6.72 MB)

Sales Data

@kaggle.aemyjutt_salesdata.sales_data

6.72 MB
185950 rows
11 columns

order_date Order Date	order_id Order ID	product Product	product_ean Product Ean	cat_gorie Catégorie	purchase_address Purchase Address	quantity_ordered Quantity Ordered	price_each Price Each	cost_price Cost Price	turnover Turnover	margin Margin
Tue Jan 22 2019 21:25:00 GMT+0000 (Coordinated Universal Time)	141234	iPhone	5638008983335	Vêtements	944 Walnut St, Boston, MA 02215	1	700	231	700	469
Mon Jan 28 2019 14:15:00 GMT+0000 (Coordinated Universal Time)	141235	Lightning Charging Cable	5563319511488	Alimentation	185 Maple St, Portland, OR 97035	1	14.95	7.475	14.95	7.475
Thu Jan 17 2019 13:33:00 GMT+0000 (Coordinated Universal Time)	141236	Wired Headphones	2113973395220	Vêtements	538 Adams St, San Francisco, CA 94016	2	11.99	5.995	23.98	11.99
Sat Jan 05 2019 20:33:00 GMT+0000 (Coordinated Universal Time)	141237	27in FHD Monitor	3069156759167	Sports	738 10th St, Los Angeles, CA 90001	1	149.99	97.4935	149.99	52.4965
Fri Jan 25 2019 11:59:00 GMT+0000 (Coordinated Universal Time)	141238	Wired Headphones	9692680938163	Électronique	387 10th St, Austin, TX 73301	1	11.99	5.995	11.99	5.995
Tue Jan 29 2019 20:22:00 GMT+0000 (Coordinated Universal Time)	141239	AAA Batteries (4-pack)	2953868554188	Alimentation	775 Willow St, San Francisco, CA 94016	1	2.99	1.495	2.99	1.495
Sat Jan 26 2019 12:16:00 GMT+0000 (Coordinated Universal Time)	141240	27in 4K Gaming Monitor	5173670800988	Vêtements	979 Park St, Los Angeles, CA 90001	1	389.99	128.69670000000002	389.99	261.2933
Sat Jan 05 2019 12:04:00 GMT+0000 (Coordinated Universal Time)	141241	USB-C Charging Cable	8051736777568	Vêtements	181 6th St, San Francisco, CA 94016	1	11.95	5.975	11.95	5.975
Tue Jan 01 2019 10:30:00 GMT+0000 (Coordinated Universal Time)	141242	Bose SoundSport Headphones	1508418177978	Électronique	867 Willow St, Los Angeles, CA 90001	1	99.99	49.995	99.99	49.995
Tue Jan 22 2019 21:20:00 GMT+0000 (Coordinated Universal Time)	141243	Apple Airpods Headphones	1386344211590	Électronique	657 Johnson St, San Francisco, CA 94016	1	150	97.5	150	52.5


CREATE TABLE sales_data (
  "order_date" TIMESTAMP,
  "order_id" BIGINT,
  "product" VARCHAR,
  "product_ean" DOUBLE,
  "cat_gorie" VARCHAR,
  "purchase_address" VARCHAR,
  "quantity_ordered" BIGINT,
  "price_each" DOUBLE,
  "cost_price" DOUBLE,
  "turnover" DOUBLE,
  "margin" DOUBLE
);