Department Store Sales Dataset

Sales by salespeople at a department store.

@kaggle.raphaelpuziol_department_store_sales_dataset

Table List

1 table(789.09 KB)

Department Store Dataset

@kaggle.raphaelpuziol_department_store_sales_dataset.department_store_dataset

789.09 KB
41629 rows
9 columns

seller Seller	department Department	revenue Revenue	revenue_goal Revenue Goal	margin Margin	margin_goal Margin Goal	date Date	sales_quantity Sales Quantity	customers Customers
Letícia Nascimento	Eletrônicos	6139.41	1857.66	0.14	0.18	Sun Jan 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	50	213
Ana Sousa	Eletrônicos	7044.96	5236.01	0.3	0.17	Sun Jan 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	52	256
Gustavo Martins	Eletrônicos	4109.85	1882.47	0.14	0.2	Sun Jan 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	33	189
Beatriz Santos	Vestuário	315.3	2069.08	0.2	0.17	Sun Jan 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	2	6
Camila Lima	Vestuário	1672.33	3587.07	0.24	0.14	Sun Jan 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	12	50
Thiago Barbosa	Acessórios	2884.52	2005.19	0.4	0.44	Sun Jan 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	23	48
Letícia Ribeiro	Acessórios	3414.28	1302.34	0.26	0.42	Sun Jan 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	30	66
Enzo Nascimento	Casa	9427.77	5667.34	0.37	0.3	Sun Jan 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	82	186
Guilherme Santos	Casa	6039.19	7901.41	0.23	0.29	Sun Jan 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	42	85
Vitória Ribeiro	Brinquedo	6593.46	4112.01	0.36	0.26	Sun Jan 01 2017 00:00:00 GMT+0000 (Coordinated Universal Time)	59	240


CREATE TABLE department_store_dataset (
  "seller" VARCHAR,
  "department" VARCHAR,
  "revenue" DOUBLE,
  "revenue_goal" DOUBLE,
  "margin" DOUBLE,
  "margin_goal" DOUBLE,
  "date" TIMESTAMP,
  "sales_quantity" BIGINT,
  "customers" BIGINT
);