Europe Bike Store Sales

Excel Pivot Tables Example

@kaggle.prepinstaprime_europe_bike_store_sales

Table List

1 table(937 KB)

Sales

@kaggle.prepinstaprime_europe_bike_store_sales.sales

937 KB
113036 rows
18 columns

date Date	day Day	month Month	year Year	customer_age Customer Age	age_group Age Group	customer_gender Customer Gender	country Country	state State	product_category Product Category	sub_category Sub Category	product Product	order_quantity Order Quantity	unit_cost Unit Cost	unit_price Unit Price	profit Profit	cost Cost	revenue Revenue
Tue Nov 26 2013 00:00:00 GMT+0000 (Coordinated Universal Time)	26	November	2013	19	Youth (<25)	M	Canada	British Columbia	Accessories	Bike Racks	Hitch Rack - 4-Bike	8	45	120	590	360	950
Thu Nov 26 2015 00:00:00 GMT+0000 (Coordinated Universal Time)	26	November	2015	19	Youth (<25)	M	Canada	British Columbia	Accessories	Bike Racks	Hitch Rack - 4-Bike	8	45	120	590	360	950
Sun Mar 23 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	23	March	2014	49	Adults (35-64)	M	Australia	New South Wales	Accessories	Bike Racks	Hitch Rack - 4-Bike	23	45	120	1366	1035	2401
Wed Mar 23 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	23	March	2016	49	Adults (35-64)	M	Australia	New South Wales	Accessories	Bike Racks	Hitch Rack - 4-Bike	20	45	120	1188	900	2088
Thu May 15 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	15	May	2014	47	Adults (35-64)	F	Australia	New South Wales	Accessories	Bike Racks	Hitch Rack - 4-Bike	4	45	120	238	180	418
Sun May 15 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	15	May	2016	47	Adults (35-64)	F	Australia	New South Wales	Accessories	Bike Racks	Hitch Rack - 4-Bike	5	45	120	297	225	522
Thu May 22 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	22	May	2014	47	Adults (35-64)	F	Australia	Victoria	Accessories	Bike Racks	Hitch Rack - 4-Bike	4	45	120	199	180	379
Sun May 22 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	22	May	2016	47	Adults (35-64)	F	Australia	Victoria	Accessories	Bike Racks	Hitch Rack - 4-Bike	2	45	120	100	90	190
Sat Feb 22 2014 00:00:00 GMT+0000 (Coordinated Universal Time)	22	February	2014	35	Adults (35-64)	M	Australia	Victoria	Accessories	Bike Racks	Hitch Rack - 4-Bike	22	45	120	1096	990	2086
Mon Feb 22 2016 00:00:00 GMT+0000 (Coordinated Universal Time)	22	February	2016	35	Adults (35-64)	M	Australia	Victoria	Accessories	Bike Racks	Hitch Rack - 4-Bike	21	45	120	1046	945	1991


CREATE TABLE sales (
  "date" TIMESTAMP,
  "day" BIGINT,
  "month" VARCHAR,
  "year" BIGINT,
  "customer_age" BIGINT,
  "age_group" VARCHAR,
  "customer_gender" VARCHAR,
  "country" VARCHAR,
  "state" VARCHAR,
  "product_category" VARCHAR,
  "sub_category" VARCHAR,
  "product" VARCHAR,
  "order_quantity" BIGINT,
  "unit_cost" BIGINT,
  "unit_price" BIGINT,
  "profit" BIGINT,
  "cost" BIGINT,
  "revenue" BIGINT
);