Batch & Brew Cafe Sales Data & Dashboard.xlsx

	A	C	D	E	F	G	H	I
1	Transaction ID	Item	Quantity	Price Per Unit	Total Spent	Payment Method	Location	Transaction Date
2	TXN_1961373	Coffee	2	2	4	Credit Card	Takeaway	9/8/2023
3	TXN_4977031	Cake	4	3	12	Cash	In-store	5/16/2023
4	TXN_4271903	Cookie	4	1	ERROR	Credit Card	In-store	7/19/2023
5	TXN_7034554	Salad	2	5	10	UNKNOWN	UNKNOWN	4/27/2023
6	TXN_3160411	Coffee	2	2	4	Digital Wallet	In-store	6/11/2023
7	TXN_2602893	Smoothie	5	4	20	Credit Card		3/31/2023
8	TXN_4433211	UNKNOWN	3	3	9	ERROR	Takeaway	10/6/2023
9	TXN_6699534	Sandwich	4	4	16	Cash	UNKNOWN	10/28/2023
10	TXN_4717867		5	3	15		Takeaway	7/28/2023
11	TXN_2064365	Sandwich	5	4	20		In-store	12/31/2023
12	TXN_2548360	Salad	5	5	25	Cash	Takeaway	11/7/2023
13	TXN_3051279	Sandwich	2	4	8	Credit Card	Takeaway	ERROR
14	TXN_7619095	Sandwich	2	4	8	Cash	In-store	5/3/2023
15	TXN_9437049	Cookie	5	1	5		Takeaway	6/1/2023
16	TXN_8915701	ERROR	2	1.5	3		In-store	3/21/2023
17	TXN_2847255	Salad	3	5	15	Credit Card	In-store	11/15/2023
18	TXN_3765707	Sandwich	1	4	4			6/10/2023
19	TXN_6769710	Juice	2	3	6	Cash	In-store	2/24/2023
20	TXN_8876618	Cake	5	3	15	Cash	ERROR	3/25/2023
21	TXN_3709394	Juice	4	3	12	Cash	Takeaway	1/15/2023
22	TXN_3522028	Smoothie	ERROR	4	20	Cash	In-store	4/4/2023
23	TXN_3567645	Smoothie	4	4	16	Credit Card	Takeaway	3/30/2023
24	TXN_5132361	Sandwich	3	4	12	Digital Wallet	Takeaway	12/1/2023
25	TXN_2616390	Sandwich	2	4	8			9/18/2023
26	TXN_9400181	Sandwich	5	4	20	Cash	In-store	6/3/2023
27	TXN_7958992	Smoothie	3	4		UNKNOWN	UNKNOWN	12/13/2023
28	TXN_5183041	Cookie	5	1	5	Credit Card	In-store	4/20/2023
29	TXN_5695074	Juice	4	3	12	Credit Card	Takeaway	4/10/2023
30	TXN_8467949	Smoothie	5	4	20	Credit Card		3/11/2023
31	TXN_7640952	Cake	4	3	12	Digital Wallet	Takeaway	ERROR
32	TXN_1736287		5	2	10	Digital Wallet		6/2/2023
33	TXN_8927252	UNKNOWN	2	1	ERROR	Credit Card	ERROR	11/6/2023
34	TXN_9677376	Smoothie	4	4	16		In-store	8/15/2023
35	TXN_7710508	UNKNOWN	5	1	5	Cash		ERROR
36	TXN_8853997	Smoothie	2	4	8	Digital Wallet	Takeaway	10/9/2023
37	TXN_9130559	Sandwich	1	4	4	Credit Card	UNKNOWN	5/28/2023
38	TXN_6855453	UNKNOWN	4	3	12		In-store	7/17/2023
39	TXN_1080432	Salad	2	5	10	Credit Card	In-store	4/29/2023
40	TXN_2655815	Smoothie	4	4	16		Takeaway	6/8/2023
41	TXN_6688524	Coffee	4	2	8	ERROR		6/29/2023
42	TXN_2083138	Smoothie	3	4	12		In-store	4/17/2023
43	TXN_2427584	Sandwich	4	4	16		Takeaway	12/22/2023
44	TXN_6650263	Tea	2	1.5	UNKNOWN		Takeaway	1/10/2023
45	TXN_9620080	Juice	4	3	12		Takeaway	10/2/2023
46	TXN_1491578	Cookie	2	1	2			2/23/2023
47	TXN_5455792	Salad	3	5	15	Cash		3/22/2023
48	TXN_8078640	Juice	4	3	12	Digital Wallet	In-store	11/3/2023
49	TXN_9499313	Juice	5	3	15			3/2/2023
50	TXN_8201146	Juice	5	3	15	Cash		6/26/2023
51	TXN_8230936	Cake	3	3	9		ERROR	5/2/2023
52	TXN_7742742	Cake	5	3	15		Takeaway	9/5/2023
53	TXN_6342161	Salad	5	5	25	ERROR	Takeaway	1/8/2023
54	TXN_8914892	UNKNOWN	5	5	25	Digital Wallet		3/15/2023
55	TXN_3363746	Smoothie	3	4	12	Credit Card		11/25/2023
56	TXN_8614868	Smoothie	5	4	20	Digital Wallet	Takeaway	12/5/2023
57	TXN_5522862	Cookie	ERROR	1	2	Credit Card	Takeaway	3/19/2023
58	TXN_3578141	Cake	5		15		Takeaway	6/27/2023
59	TXN_2080895	Cake	UNKNOWN	3	3	Digital Wallet	In-store	4/19/2023
60	TXN_6421134	Sandwich	4	4	16	Cash	Takeaway	11/3/2023
61	TXN_8813311	Juice	5	3	15		In-store	10/7/2023
62	TXN_9023317	Salad	1	5	5			9/30/2023
63	TXN_8051289		1	3	3		In-store	10/9/2023
64	TXN_2537617	Sandwich	1	4	4	Cash		5/27/2023
65	TXN_9099694	UNKNOWN	3	5	15		Takeaway	11/18/2023
66	TXN_9230615	Smoothie	4	4	16	Digital Wallet		6/1/2023
67	TXN_4987129	Sandwich	3				In-store	10/20/2023
68	TXN_8501819	Juice		3	6	Cash		3/30/2023
69	TXN_3068204	Cookie	1	1	1	Credit Card	Takeaway	10/3/2023
70	TXN_8427104	Salad	2	ERROR	10		In-store	10/27/2023
71	TXN_8471743	ERROR	5	3	15	Digital Wallet	In-store	4/6/2023
72	TXN_2621580	Tea	2	1.5	3	Cash	In-store	3/22/2023
73	TXN_4726376	Cake	2	3	6	Credit Card	In-store	1/31/2023
74	TXN_6044979		1	1	1	Cash	In-store	12/8/2023
75	TXN_4238417	Salad	2	5	10		ERROR	6/19/2023
76	TXN_1900620	Smoothie	2	4	8	Credit Card	ERROR	12/14/2023
77	TXN_6420335	Coffee	1	2	2	Cash	Takeaway	7/16/2023
78	TXN_3858209	Sandwich	4	4	16	Cash		2/22/2023
79	TXN_2091733	Salad	1	5	5		In-store
80	TXN_8735480	Tea	5	1.5	7.5	Cash		6/2/2023
81	TXN_3829165	Juice	4	3	12	Cash	In-store	6/15/2023
82	TXN_3748616	Coffee	2	2	4	Credit Card	In-store	12/9/2023
83	TXN_1993289	Sandwich	2	4	8		In-store	4/18/2023
84	TXN_2123367	Cookie	2	1	2			11/7/2023
85	TXN_5266394	Cake	3	3	9	Cash	In-store	10/28/2023
86	TXN_5107946	Cake	4	3	12	Credit Card		12/22/2023
87	TXN_8035512	Tea	3		4.5	Cash	UNKNOWN	10/29/2023
88	TXN_8718498	Cake	5	3	15	Credit Card	ERROR	4/30/2023
89	TXN_3955361	Cookie	5	1	5		Takeaway	4/2/2023
90	TXN_9487821	ERROR	1	5	5	Digital Wallet	Takeaway	5/24/2023
91	TXN_4132730		5	1	5		In-store	3/12/2023
92	TXN_8976658	Tea	2	1.5	3	Credit Card	In-store	8/16/2023
93	TXN_5455936	UNKNOWN	5	3	15		In-store	10/28/2023
94	TXN_2725602	Juice	5	3	15	Credit Card		9/10/2023
95	TXN_3011323	Coffee	3	2	6	Credit Card		3/7/2023
96	TXN_6289610	Juice	3	3	UNKNOWN	Cash	Takeaway	8/7/2023
97	TXN_8268061	Salad	3	5	15	ERROR	Takeaway	8/20/2023
98	TXN_5220895	Salad	5	5	25	Cash	In-store	6/10/2023
99	TXN_3085509	Coffee	4	2	8	Digital Wallet	In-store	4/15/2023
100	TXN_9999113	Juice	4	3	12	Cash	Takeaway	5/27/2023