Kingston Supermarket Sales

A case study of sales of a supermart showcase a dashboard

@kaggle.akinbosede_kingston_supermarket_sales_dashboard

Table List

1 table(30.17 KB)

Kingston Supermarket Sales

@kaggle.akinbosede_kingston_supermarket_sales_dashboard.kingston_supermarket_sales

30.17 KB
228 rows
25 columns

invoice_id Invoice ID	branch Branch	city City	customer_type Customer Type	gender Gender	product_line Product Line	n__unit_price Unit Price	quantity Quantity	n__cogs Cogs	tax_5 Tax 5%	n__total Total	date Date	time Time	payment Payment	gross_margin_percentage Gross Margin Percentage	gross_income Gross Income	rating Rating	unnamed_18 Unnamed: 18	unnamed_19 Unnamed: 19	unnamed_21 Unnamed: 21	unnamed_24 Unnamed: 24
651-88-7328	Central Area	Abuja	Normal	Female	Fashion accessories	?65.74	9	?591.66	29.583	?621.24	Tue Jan 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	13:55	Cash	4.761904762	29.583	7.7	nan	nan	nan
416-17-9926	Central Area	Abuja	Member	Female	Electronic accessories	?74.22	10	?742.20	37.11	?779.31	Tue Jan 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	14:42	Credit card	4.761904762	37.11	4.3	nan	nan	nan
746-04-1077	Bodija	Ibadan	Member	Female	Food and beverages	?84.63	10	?846.30	42.315	?888.62	Tue Jan 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	11:36	Credit card	4.761904762	42.315	9	nan	nan	nan
552-44-5977	Bodija	Ibadan	Member	Male	Health and beauty	?62.00	8	?496.00	24.8	?520.80	Thu Jan 03 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	19:08	Credit card	4.761904762	24.8	6.2	count	nan	nan
672-51-8681	Lekki	Lagos	Member	Female	Electronic accessories	?66.65	9	?599.85	29.9925	?629.84	Fri Jan 04 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	18:19	Credit card	4.761904762	29.9925	9.7	Female	121	Electronic accessories	26953.6575
750-67-8428	Central Area	Abuja	Member	Female	Health and beauty	?74.69	7	?522.83	26.1415	?548.97	Sat Jan 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	13:08	Ewallet	4.761904762	26.1415	9.1	Male	106	Food and beverages	26723.1405
433-08-7822	Lekki	Lagos	Normal	Female	Health and beauty	?78.89	7	?552.23	27.6115	?579.84	Sat Jan 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	19:48	Ewallet	4.761904762	27.6115	7.5	Total	227	Health and beauty	25403.868
489-82-1237	Central Area	Abuja	Normal	Female	Electronic accessories	?93.88	7	?657.16	32.858	?690.02	Sat Jan 05 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	11:51	Credit card	4.761904762	32.858	7.3	nan	nan	Fashion accessories	25187.379
393-65-2792	Lekki	Lagos	Normal	Male	Food and beverages	?89.48	10	?894.80	44.74	?939.54	Sun Jan 06 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	12:46	Credit card	4.761904762	44.74	9.6	Gender	nan	Sports and travel	27872.922
729-06-2010	Bodija	Ibadan	Member	Male	Health and beauty	?80.47	9	?724.23	36.2115	?760.44	Sun Jan 06 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	11:18	Cash	4.761904762	36.2115	9.2	member	119	Home and lifestyle	27413.6625


CREATE TABLE kingston_supermarket_sales (
  "invoice_id" VARCHAR,
  "branch" VARCHAR,
  "city" VARCHAR,
  "customer_type" VARCHAR,
  "gender" VARCHAR,
  "product_line" VARCHAR,
  "n__unit_price" VARCHAR,
  "quantity" DOUBLE,
  "n__cogs" VARCHAR,
  "tax_5" DOUBLE,
  "n__total" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "payment" VARCHAR,
  "gross_margin_percentage" DOUBLE,
  "gross_income" DOUBLE,
  "rating" DOUBLE,
  "unnamed_17" VARCHAR,
  "unnamed_18" VARCHAR,
  "unnamed_19" VARCHAR,
  "unnamed_20" VARCHAR,
  "unnamed_21" VARCHAR,
  "unnamed_22" DOUBLE,
  "unnamed_23" VARCHAR,
  "unnamed_24" DOUBLE
);