Coffee Chain Sales Analysis

Exploring Coffee Chain Sales Data: Analyzing Sales Trends and Insights

@kaggle.amruthayenikonda_coffee_chain_sales_dataset

Table List

1 table(43.02 KB)

Coffee Chain Sales

@kaggle.amruthayenikonda_coffee_chain_sales_dataset.coffee_chain_sales

43.02 KB
1062 rows
21 columns

area_code Area Code	cogs Cogs	differencebetweenactualandtargetprofit DifferenceBetweenActualandTargetProfit	date Date	inventory_margin Inventory Margin	margin Margin	market_size Market Size	market Market	marketing Marketing	product_line Product Line	product_type Product Type	product Product	profit Profit	sales Sales	state State	target_cogs Target Cogs	target_margin Target Margin	target_profit Target Profit	target_sales Target Sales	total_expenses Total Expenses	type Type
303	51	-35	Mon Oct 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	503	71	Major Market	Central	46	Leaves	Herbal Tea	Lemon	-5	122	Colorado	30	60	30	90	76	Decaf
970	52	-24	Mon Oct 01 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	405	71	Major Market	Central	17	Leaves	Herbal Tea	Mint	26	123	Colorado	30	60	50	90	45	Decaf
409	43	-22	Tue Oct 02 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	419	64	Major Market	South	13	Leaves	Herbal Tea	Lemon	28	107	Texas	30	60	50	90	36	Decaf
850	38	-15	Wed Oct 03 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	871	56	Major Market	East	10	Leaves	Tea	Darjeeling	35	94	Florida	40	60	50	100	21	Regular
562	72	6	Thu Oct 04 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	650	110	Major Market	West	23	Leaves	Tea	Green Tea	56	182	California	20	60	50	80	54	Regular
712		-29	Fri Oct 05 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	430	43	Small Market	Central		Beans	Espresso	Decaf Espresso	31	43	Iowa		60	60	60	12	Decaf
860	47	-29	Sat Oct 06 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	375	64	Small Market	East	15	Beans	Espresso	Decaf Espresso	21	111	Connecticut	30	60	50	90	43	Decaf
918	27	-39	Sun Oct 07 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	859	39	Small Market	South	7	Beans	Coffee	Decaf Irish Cream	21	66	Oklahoma	30	60	60	90	18	Decaf
775	31	-43	Mon Oct 08 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	1000	37	Small Market	West	9	Beans	Coffee	Decaf Irish Cream	7	68	Nevada	30	60	50	90	30	Decaf
435	40	-23	Tue Oct 09 2012 00:00:00 GMT+0000 (Coordinated Universal Time)	881	59	Small Market	West	11	Beans	Espresso	Decaf Espresso	37	99	Utah	20	60	60	80	22	Decaf


CREATE TABLE coffee_chain_sales (
  "area_code" BIGINT,
  "cogs" BIGINT,
  "differencebetweenactualandtargetprofit" BIGINT,
  "date" TIMESTAMP,
  "inventory_margin" BIGINT,
  "margin" BIGINT,
  "market_size" VARCHAR,
  "market" VARCHAR,
  "marketing" BIGINT,
  "product_line" VARCHAR,
  "product_type" VARCHAR,
  "product" VARCHAR,
  "profit" BIGINT,
  "sales" BIGINT,
  "state" VARCHAR,
  "target_cogs" BIGINT,
  "target_margin" BIGINT,
  "target_profit" BIGINT,
  "target_sales" BIGINT,
  "total_expenses" BIGINT,
  "type" VARCHAR
);