Coffee Shop Sales Management Dashboard.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L
1	transaction_id	transaction_date	transaction_time	transaction_qty	store_id	store_location	product_id	unit_price	product_category	product_type	Size	product_detail
2	1	1/1/2023	12/30/1899	2	5	Lower Manhattan	32	3	Coffee	Gourmet brewed coffee	Rg	Ethiopia Rg
3	2	1/1/2023	12/30/1899	2	5	Lower Manhattan	57	3.1	Tea	Brewed Chai tea	Lg	Spicy Eye Opener Chai Lg
4	3	1/1/2023	12/30/1899	2	5	Lower Manhattan	59	4.5	Drinking Chocolate	Hot chocolate	Lg	Dark chocolate Lg
5	4	1/1/2023	12/30/1899	1	5	Lower Manhattan	22	2	Coffee	Drip coffee	Sm	Our Old Time Diner Blend Sm
6	5	1/1/2023	12/30/1899	2	5	Lower Manhattan	57	3.1	Tea	Brewed Chai tea	Lg	Spicy Eye Opener Chai Lg
7	6	1/1/2023	12/30/1899	1	5	Lower Manhattan	77	3	Bakery	Scone	Scone	Oatmeal Scone
8	7	1/1/2023	12/30/1899	1	5	Lower Manhattan	22	2	Coffee	Drip coffee	Sm	Our Old Time Diner Blend Sm
9	8	1/1/2023	12/30/1899	2	5	Lower Manhattan	28	2	Coffee	Gourmet brewed coffee	Sm	Columbian Medium Roast Sm
10	9	1/1/2023	12/30/1899	1	5	Lower Manhattan	39	4.25	Coffee	Barista Espresso	Rg	Latte Rg
11	10	1/1/2023	12/30/1899	2	5	Lower Manhattan	58	3.5	Drinking Chocolate	Hot chocolate	Rg	Dark chocolate Rg
12	11	1/1/2023	12/30/1899	1	5	Lower Manhattan	56	2.55	Tea	Brewed Chai tea	Rg	Spicy Eye Opener Chai Rg
13	12	1/1/2023	12/30/1899	2	5	Lower Manhattan	33	3.5	Coffee	Gourmet brewed coffee	Lg	Ethiopia Lg
14	13	1/1/2023	12/30/1899	1	5	Lower Manhattan	51	3	Tea	Brewed Black tea	Lg	Earl Grey Lg
15	14	1/1/2023	12/30/1899	1	5	Lower Manhattan	57	3.1	Tea	Brewed Chai tea	Lg	Spicy Eye Opener Chai Lg
16	15	1/1/2023	12/30/1899	2	5	Lower Manhattan	87	3	Coffee	Barista Espresso	shot	Ouro Brasileiro shot
17	16	1/1/2023	12/30/1899	2	5	Lower Manhattan	47	3	Tea	Brewed Green tea	Lg	Serenity Green Tea Lg
18	17	1/1/2023	12/30/1899	1	5	Lower Manhattan	79	3.75	Bakery	Scone	Scone	Jumbo Savory Scone
19	18	1/1/2023	12/30/1899	1	8	Hell's Kitchen	42	2.5	Tea	Brewed herbal tea	Rg	Lemon Grass Rg
20	19	1/1/2023	12/30/1899	2	8	Hell's Kitchen	59	4.5	Drinking Chocolate	Hot chocolate	Lg	Dark chocolate Lg
21	20	1/1/2023	12/30/1899	1	8	Hell's Kitchen	61	4.75	Drinking Chocolate	Hot chocolate	Lg	Sustainably Grown Organic Lg
22	21	1/1/2023	12/30/1899	2	8	Hell's Kitchen	33	3.5	Coffee	Gourmet brewed coffee	Lg	Ethiopia Lg
23	22	1/1/2023	12/30/1899	2	5	Lower Manhattan	56	2.55	Tea	Brewed Chai tea	Rg	Spicy Eye Opener Chai Rg
24	23	1/1/2023	12/30/1899	1	5	Lower Manhattan	69	3.25	Bakery	Biscotti	Biscotti	Hazelnut Biscotti
25	24	1/1/2023	12/30/1899	1	8	Hell's Kitchen	56	2.55	Tea	Brewed Chai tea	Rg	Spicy Eye Opener Chai Rg
26	25	1/1/2023	12/30/1899	1	8	Hell's Kitchen	40	3.75	Coffee	Barista Espresso	Cappuccino	Cappuccino
27	26	1/1/2023	12/30/1899	1	5	Lower Manhattan	43	3	Tea	Brewed herbal tea	Lg	Lemon Grass Lg
28	27	1/1/2023	12/30/1899	1	5	Lower Manhattan	76	3.5	Bakery	Biscotti	Biscotti	Chocolate Chip Biscotti
29	28	1/1/2023	12/30/1899	2	5	Lower Manhattan	45	3	Tea	Brewed herbal tea	Lg	Peppermint Lg
30	29	1/1/2023	12/30/1899	1	5	Lower Manhattan	71	3.75	Bakery	Pastry	Croissant	Chocolate Croissant
31	30	1/1/2023	12/30/1899	2	8	Hell's Kitchen	40	3.75	Coffee	Barista Espresso	Cappuccino	Cappuccino
32	31	1/1/2023	12/30/1899	1	8	Hell's Kitchen	38	3.75	Coffee	Barista Espresso	Latte	Latte
33	32	1/1/2023	12/30/1899	1	5	Lower Manhattan	26	3	Coffee	Organic brewed coffee	Rg	Brazilian Rg
34	33	1/1/2023	12/30/1899	2	5	Lower Manhattan	27	3.5	Coffee	Organic brewed coffee	Lg	Brazilian Lg
35	34	1/1/2023	12/30/1899	2	5	Lower Manhattan	29	2.5	Coffee	Gourmet brewed coffee	Rg	Columbian Medium Roast Rg
36	35	1/1/2023	12/30/1899	1	8	Hell's Kitchen	54	2.5	Tea	Brewed Chai tea	Rg	Morning Sunrise Chai Rg
37	36	1/1/2023	12/30/1899	1	5	Lower Manhattan	26	3	Coffee	Organic brewed coffee	Rg	Brazilian Rg
38	37	1/1/2023	12/30/1899	1	5	Lower Manhattan	55	4	Tea	Brewed Chai tea	Lg	Morning Sunrise Chai Lg
39	38	1/1/2023	12/30/1899	2	8	Hell's Kitchen	40	3.75	Coffee	Barista Espresso	Cappuccino	Cappuccino
40	39	1/1/2023	12/30/1899	1	8	Hell's Kitchen	45	3	Tea	Brewed herbal tea	Lg	Peppermint Lg
41	40	1/1/2023	12/30/1899	2	8	Hell's Kitchen	45	3	Tea	Brewed herbal tea	Lg	Peppermint Lg
42	41	1/1/2023	12/30/1899	1	8	Hell's Kitchen	24	3	Coffee	Drip coffee	Lg	Our Old Time Diner Blend Lg
43	42	1/1/2023	12/30/1899	2	5	Lower Manhattan	60	3.75	Drinking Chocolate	Hot chocolate	Rg	Sustainably Grown Organic Rg
44	43	1/1/2023	12/30/1899	1	5	Lower Manhattan	78	4.5	Bakery	Scone	Scone	Scottish Cream Scone
45	44	1/1/2023	12/30/1899	1	5	Lower Manhattan	56	2.55	Tea	Brewed Chai tea	Rg	Spicy Eye Opener Chai Rg
46	45	1/1/2023	12/30/1899	1	5	Lower Manhattan	77	3	Bakery	Scone	Scone	Oatmeal Scone
47	46	1/1/2023	12/30/1899	1	5	Lower Manhattan	44	2.5	Tea	Brewed herbal tea	Rg	Peppermint Rg
48	47	1/1/2023	12/30/1899	2	5	Lower Manhattan	56	2.55	Tea	Brewed Chai tea	Rg	Spicy Eye Opener Chai Rg
49	48	1/1/2023	12/30/1899	1	5	Lower Manhattan	48	2.5	Tea	Brewed Black tea	Rg	English Breakfast Rg
50	49	1/1/2023	12/30/1899	1	8	Hell's Kitchen	23	2.5	Coffee	Drip coffee	Rg	Our Old Time Diner Blend Rg
51	50	1/1/2023	12/30/1899	1	8	Hell's Kitchen	46	2.5	Tea	Brewed Green tea	Rg	Serenity Green Tea Rg
52	51	1/1/2023	12/30/1899	1	8	Hell's Kitchen	32	3	Coffee	Gourmet brewed coffee	Rg	Ethiopia Rg
53	52	1/1/2023	12/30/1899	2	5	Lower Manhattan	47	3	Tea	Brewed Green tea	Lg	Serenity Green Tea Lg
54	53	1/1/2023	12/30/1899	2	5	Lower Manhattan	43	3	Tea	Brewed herbal tea	Lg	Lemon Grass Lg
55	54	1/1/2023	12/30/1899	2	5	Lower Manhattan	25	2.2	Coffee	Organic brewed coffee	Sm	Brazilian Sm
56	55	1/1/2023	12/30/1899	1	8	Hell's Kitchen	59	4.5	Drinking Chocolate	Hot chocolate	Lg	Dark chocolate Lg
57	56	1/1/2023	12/30/1899	1	5	Lower Manhattan	38	3.75	Coffee	Barista Espresso	Latte	Latte
58	57	1/1/2023	12/30/1899	1	8	Hell's Kitchen	45	3	Tea	Brewed herbal tea	Lg	Peppermint Lg
59	58	1/1/2023	12/30/1899	1	5	Lower Manhattan	34	2.45	Coffee	Premium brewed coffee	Sm	Jamaican Coffee River Sm
60	59	1/1/2023	12/30/1899	2	8	Hell's Kitchen	36	3.75	Coffee	Premium brewed coffee	Lg	Jamaican Coffee River Lg
61	60	1/1/2023	12/30/1899	1	8	Hell's Kitchen	74	3.5	Bakery	Biscotti	Biscotti	Ginger Biscotti
62	61	1/1/2023	12/30/1899	1	8	Hell's Kitchen	53	3	Tea	Brewed Chai tea	Lg	Traditional Blend Chai Lg
63	62	1/1/2023	12/30/1899	2	8	Hell's Kitchen	41	4.25	Coffee	Barista Espresso	Lg	Cappuccino Lg
64	63	1/1/2023	12/30/1899	1	5	Lower Manhattan	41	4.25	Coffee	Barista Espresso	Lg	Cappuccino Lg
65	64	1/1/2023	12/30/1899	2	5	Lower Manhattan	45	3	Tea	Brewed herbal tea	Lg	Peppermint Lg
66	65	1/1/2023	12/30/1899	1	5	Lower Manhattan	79	3.75	Bakery	Scone	Scone	Jumbo Savory Scone
67	66	1/1/2023	12/30/1899	2	5	Lower Manhattan	54	2.5	Tea	Brewed Chai tea	Rg	Morning Sunrise Chai Rg
68	67	1/1/2023	12/30/1899	1	5	Lower Manhattan	24	3	Coffee	Drip coffee	Lg	Our Old Time Diner Blend Lg
69	68	1/1/2023	12/30/1899	2	5	Lower Manhattan	37	3	Coffee	Barista Espresso	shot	Espresso shot
70	69	1/1/2023	12/30/1899	2	8	Hell's Kitchen	40	3.75	Coffee	Barista Espresso	Cappuccino	Cappuccino
71	70	1/1/2023	12/30/1899	2	5	Lower Manhattan	37	3	Coffee	Barista Espresso	shot	Espresso shot
72	71	1/1/2023	12/30/1899	1	5	Lower Manhattan	69	3.25	Bakery	Biscotti	Biscotti	Hazelnut Biscotti
73	72	1/1/2023	12/30/1899	1	5	Lower Manhattan	50	2.5	Tea	Brewed Black tea	Rg	Earl Grey Rg
74	73	1/1/2023	12/30/1899	1	8	Hell's Kitchen	47	3	Tea	Brewed Green tea	Lg	Serenity Green Tea Lg
75	74	1/1/2023	12/30/1899	2	8	Hell's Kitchen	40	3.75	Coffee	Barista Espresso	Cappuccino	Cappuccino
76	75	1/1/2023	12/30/1899	1	8	Hell's Kitchen	72	3.25	Bakery	Scone	Scone	Ginger Scone
77	76	1/1/2023	12/30/1899	1	8	Hell's Kitchen	35	3.1	Coffee	Premium brewed coffee	Rg	Jamaican Coffee River Rg
78	77	1/1/2023	12/30/1899	1	5	Lower Manhattan	23	2.5	Coffee	Drip coffee	Rg	Our Old Time Diner Blend Rg
79	78	1/1/2023	12/30/1899	2	5	Lower Manhattan	43	3	Tea	Brewed herbal tea	Lg	Lemon Grass Lg
80	79	1/1/2023	12/30/1899	1	8	Hell's Kitchen	22	2	Coffee	Drip coffee	Sm	Our Old Time Diner Blend Sm
81	80	1/1/2023	12/30/1899	2	8	Hell's Kitchen	32	3	Coffee	Gourmet brewed coffee	Rg	Ethiopia Rg
82	81	1/1/2023	12/30/1899	2	8	Hell's Kitchen	36	3.75	Coffee	Premium brewed coffee	Lg	Jamaican Coffee River Lg
83	82	1/1/2023	12/30/1899	1	5	Lower Manhattan	26	3	Coffee	Organic brewed coffee	Rg	Brazilian Rg
84	83	1/1/2023	12/30/1899	1	5	Lower Manhattan	71	3.75	Bakery	Pastry	Croissant	Chocolate Croissant
85	84	1/1/2023	12/30/1899	2	5	Lower Manhattan	32	3	Coffee	Gourmet brewed coffee	Rg	Ethiopia Rg
86	85	1/1/2023	12/30/1899	1	8	Hell's Kitchen	54	2.5	Tea	Brewed Chai tea	Rg	Morning Sunrise Chai Rg
87	86	1/1/2023	12/30/1899	2	8	Hell's Kitchen	41	4.25	Coffee	Barista Espresso	Lg	Cappuccino Lg
88	87	1/1/2023	12/30/1899	2	5	Lower Manhattan	25	2.2	Coffee	Organic brewed coffee	Sm	Brazilian Sm
89	88	1/1/2023	12/30/1899	2	5	Lower Manhattan	23	2.5	Coffee	Drip coffee	Rg	Our Old Time Diner Blend Rg
90	89	1/1/2023	12/30/1899	1	8	Hell's Kitchen	54	2.5	Tea	Brewed Chai tea	Rg	Morning Sunrise Chai Rg
91	90	1/1/2023	12/30/1899	2	8	Hell's Kitchen	56	2.55	Tea	Brewed Chai tea	Rg	Spicy Eye Opener Chai Rg
92	91	1/1/2023	12/30/1899	2	5	Lower Manhattan	58	3.5	Drinking Chocolate	Hot chocolate	Rg	Dark chocolate Rg
93	92	1/1/2023	12/30/1899	1	5	Lower Manhattan	74	3.5	Bakery	Biscotti	Biscotti	Ginger Biscotti
94	93	1/1/2023	12/30/1899	2	8	Hell's Kitchen	47	3	Tea	Brewed Green tea	Lg	Serenity Green Tea Lg
95	94	1/1/2023	12/30/1899	1	5	Lower Manhattan	35	3.1	Coffee	Premium brewed coffee	Rg	Jamaican Coffee River Rg
96	95	1/1/2023	12/30/1899	1	5	Lower Manhattan	70	3.25	Bakery	Scone	Scone	Cranberry Scone
97	96	1/1/2023	12/30/1899	1	8	Hell's Kitchen	60	3.75	Drinking Chocolate	Hot chocolate	Rg	Sustainably Grown Organic Rg
98	97	1/1/2023	12/30/1899	1	5	Lower Manhattan	59	4.5	Drinking Chocolate	Hot chocolate	Lg	Dark chocolate Lg
99	98	1/1/2023	12/30/1899	2	5	Lower Manhattan	36	3.75	Coffee	Premium brewed coffee	Lg	Jamaican Coffee River Lg
100	99	1/1/2023	12/30/1899	2	8	Hell's Kitchen	51	3	Tea	Brewed Black tea	Lg	Earl Grey Lg