Supermarket Sales Dashboard.xlsx

	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1	Invoice ID	Branch	City	Customer type	Gender	Product line	Unit price	Quantity	Tax 5%	Total	Date	Time	Payment	Rating
2	750-67-8428	A	Yangon	Member	Female	Health and beauty	74.69	7	26.1415	548.9715	1/5/2019	13:08	Ewallet	9.1
3	226-31-3081	C	Naypyitaw	Normal	Female	Electronic accessories	15.28	5	3.82	80.22	3/8/2019	10:29	Cash	9.6
4	631-41-3108	A	Yangon	Normal	Male	Home and lifestyle	46.33	7	16.2155	340.5255	3/3/2019	13:23	Credit card	7.4	SUM->	322966.749
5	123-19-1176	A	Yangon	Member	Male	Health and beauty	58.22	8	23.288	489.048	1/27/2019	20:33	Ewallet	8.4
6	373-73-7910	A	Yangon	Normal	Male	Sports and travel	86.31	7	30.2085	634.3785	2/8/2019	10:37	Ewallet	5.3
7	699-14-3026	C	Naypyitaw	Normal	Male	Electronic accessories	85.39	7	29.8865	627.6165	3/25/2019	18:30	Ewallet	4.1
8	355-53-5943	A	Yangon	Member	Female	Electronic accessories	68.84	6	20.652	433.692	2/25/2019	14:36	Ewallet	5.8
9	315-22-5665	C	Naypyitaw	Normal	Female	Home and lifestyle	73.56	10	36.78	772.38	2/24/2019	11:38	Ewallet	8
10	665-32-9167	A	Yangon	Member	Female	Health and beauty	36.26	2	3.626	76.146	1/10/2019	17:15	Credit card	7.2
11	692-92-5582	B	Mandalay	Member	Female	Food and beverages	54.84	3	8.226	172.746	2/20/2019	13:27	Credit card	5.9
12	351-62-0822	B	Mandalay	Member	Female	Fashion accessories	14.48	4	2.896	60.816	2/6/2019	18:07	Ewallet	4.5
13	529-56-3974	B	Mandalay	Member	Male	Electronic accessories	25.51	4	5.102	107.142	3/9/2019	17:03	Cash	6.8
14	365-64-0515	A	Yangon	Normal	Female	Electronic accessories	46.95	5	11.7375	246.4875	2/12/2019	10:25	Ewallet	7.1
15	252-56-2699	A	Yangon	Normal	Male	Food and beverages	43.19	10	21.595	453.495	2/7/2019	16:48	Ewallet	8.2
16	829-34-3910	A	Yangon	Normal	Female	Health and beauty	71.38	10	35.69	749.49	3/29/2019	19:21	Cash	5.7
17	299-46-1805	B	Mandalay	Member	Female	Sports and travel	93.72	6	28.116	590.436	1/15/2019	16:19	Cash	4.5
18	656-95-9349	A	Yangon	Member	Female	Health and beauty	68.93	7	24.1255	506.6355	3/11/2019	11:03	Credit card	4.6
19	765-26-6951	A	Yangon	Normal	Male	Sports and travel	72.61	6	21.783	457.443	1/1/2019	10:39	Credit card	6.9
20	329-62-1586	A	Yangon	Normal	Male	Food and beverages	54.67	3	8.2005	172.2105	1/21/2019	18:00	Credit card	8.6
21	319-50-3348	B	Mandalay	Normal	Female	Home and lifestyle	40.3	2	4.03	84.63	3/11/2019	15:30	Ewallet	4.4
22	300-71-4605	C	Naypyitaw	Member	Male	Electronic accessories	86.04	5	21.51	451.71	2/25/2019	11:24	Ewallet	4.8
23	371-85-5789	B	Mandalay	Normal	Male	Health and beauty	87.98	3	13.197	277.137	3/5/2019	10:40	Ewallet	5.1
24	273-16-6619	B	Mandalay	Normal	Male	Home and lifestyle	33.2	2	3.32	69.72	3/15/2019	12:20	Credit card	4.4
25	636-48-8204	A	Yangon	Normal	Male	Electronic accessories	34.56	5	8.64	181.44	2/17/2019	11:15	Ewallet	9.9
26	549-59-1358	A	Yangon	Member	Male	Sports and travel	88.63	3	13.2945	279.1845	3/2/2019	17:36	Ewallet	6
27	227-03-5010	A	Yangon	Member	Female	Home and lifestyle	52.59	8	21.036	441.756	3/22/2019	19:20	Credit card	8.5
28	649-29-6775	B	Mandalay	Normal	Male	Fashion accessories	33.52	1	1.676	35.196	2/8/2019	15:31	Cash	6.7
29	189-17-4241	A	Yangon	Normal	Female	Fashion accessories	87.67	2	8.767	184.107	3/10/2019	12:17	Credit card	7.7
30	145-94-9061	B	Mandalay	Normal	Female	Food and beverages	88.36	5	22.09	463.89	1/25/2019	19:48	Cash	9.6
31	848-62-7243	A	Yangon	Normal	Male	Health and beauty	24.89	9	11.2005	235.2105	3/15/2019	15:36	Cash	7.4
32	871-79-8483	B	Mandalay	Normal	Male	Fashion accessories	94.13	5	23.5325	494.1825	2/25/2019	19:39	Credit card	4.8
33	149-71-6266	B	Mandalay	Member	Male	Sports and travel	78.07	9	35.1315	737.7615	1/28/2019	12:43	Cash	4.5
34	640-49-2076	B	Mandalay	Normal	Male	Sports and travel	83.78	8	33.512	703.752	1/10/2019	14:49	Cash	5.1
35	595-11-5460	A	Yangon	Normal	Male	Health and beauty	96.58	2	9.658	202.818	3/15/2019	10:12	Credit card	5.1
36	183-56-6882	C	Naypyitaw	Member	Female	Food and beverages	99.42	4	19.884	417.564	2/6/2019	10:42	Ewallet	7.5
37	232-16-2483	C	Naypyitaw	Member	Female	Sports and travel	68.12	1	3.406	71.526	1/7/2019	12:28	Ewallet	6.8
38	129-29-8530	A	Yangon	Member	Male	Sports and travel	62.62	5	15.655	328.755	3/10/2019	19:15	Ewallet	7
39	272-65-1806	A	Yangon	Normal	Female	Electronic accessories	60.88	9	27.396	575.316	1/15/2019	17:17	Ewallet	4.7
40	333-73-7901	C	Naypyitaw	Normal	Female	Health and beauty	54.92	8	21.968	461.328	3/23/2019	13:24	Ewallet	7.6
41	777-82-7220	B	Mandalay	Member	Male	Home and lifestyle	30.12	8	12.048	253.008	3/3/2019	13:01	Cash	7.7
42	280-35-5823	B	Mandalay	Member	Female	Home and lifestyle	86.72	1	4.336	91.056	1/17/2019	18:45	Ewallet	7.9
43	554-53-8700	C	Naypyitaw	Member	Male	Home and lifestyle	56.11	2	5.611	117.831	2/2/2019	10:11	Cash	6.3
44	354-25-5821	B	Mandalay	Member	Female	Sports and travel	69.12	6	20.736	435.456	2/8/2019	13:03	Cash	5.6
45	228-96-1411	C	Naypyitaw	Member	Female	Food and beverages	98.7	8	39.48	829.08	3/4/2019	20:39	Cash	7.6
46	617-15-4209	C	Naypyitaw	Member	Male	Health and beauty	15.37	2	1.537	32.277	3/16/2019	19:47	Cash	7.2
47	132-32-9879	B	Mandalay	Member	Female	Electronic accessories	93.96	4	18.792	394.632	3/9/2019	18:00	Cash	9.5
48	370-41-7321	B	Mandalay	Member	Male	Health and beauty	56.69	9	25.5105	535.7205	2/27/2019	17:24	Credit card	8.4
49	727-46-3608	B	Mandalay	Member	Female	Food and beverages	20.01	9	9.0045	189.0945	2/6/2019	15:47	Ewallet	4.1
50	669-54-1719	B	Mandalay	Member	Male	Electronic accessories	18.93	6	5.679	119.259	2/10/2019	12:45	Credit card	8.1
51	574-22-5561	C	Naypyitaw	Member	Female	Fashion accessories	82.63	10	41.315	867.615	3/19/2019	17:08	Ewallet	7.9
52	326-78-5178	C	Naypyitaw	Member	Male	Food and beverages	91.4	7	31.99	671.79	2/3/2019	10:19	Cash	9.5
53	162-48-8011	A	Yangon	Member	Female	Food and beverages	44.59	5	11.1475	234.0975	2/10/2019	15:10	Cash	8.5
54	616-24-2851	B	Mandalay	Member	Female	Fashion accessories	17.87	4	3.574	75.054	3/22/2019	14:42	Ewallet	6.5
55	778-71-5554	C	Naypyitaw	Member	Male	Fashion accessories	15.43	1	0.7715	16.2015	1/25/2019	15:46	Credit card	6.1
56	242-55-6721	B	Mandalay	Normal	Male	Home and lifestyle	16.16	2	1.616	33.936	3/7/2019	11:49	Ewallet	6.5
57	399-46-5918	C	Naypyitaw	Normal	Female	Electronic accessories	85.98	8	34.392	722.232	2/28/2019	19:01	Cash	8.2
58	106-35-6779	A	Yangon	Member	Male	Home and lifestyle	44.34	2	4.434	93.114	3/27/2019	11:26	Cash	5.8
59	635-40-6220	A	Yangon	Normal	Male	Health and beauty	89.6	8	35.84	752.64	2/7/2019	11:28	Ewallet	6.6
60	817-48-8732	A	Yangon	Member	Female	Home and lifestyle	72.35	10	36.175	759.675	1/20/2019	15:55	Cash	5.4
61	120-06-4233	C	Naypyitaw	Normal	Male	Electronic accessories	30.61	6	9.183	192.843	3/12/2019	20:36	Cash	9.3
62	285-68-5083	C	Naypyitaw	Member	Female	Sports and travel	24.74	3	3.711	77.931	2/15/2019	17:47	Credit card	10
63	803-83-5989	C	Naypyitaw	Normal	Male	Home and lifestyle	55.73	6	16.719	351.099	2/24/2019	10:55	Ewallet	7
64	347-34-2234	B	Mandalay	Member	Female	Sports and travel	55.07	9	24.7815	520.4115	2/3/2019	13:40	Ewallet	10
65	199-75-8169	A	Yangon	Member	Male	Sports and travel	15.81	10	7.905	166.005	3/6/2019	12:27	Credit card	8.6
66	853-23-2453	B	Mandalay	Member	Male	Health and beauty	75.74	4	15.148	318.108	2/14/2019	14:35	Cash	7.6
67	877-22-3308	A	Yangon	Member	Male	Health and beauty	15.87	10	7.935	166.635	3/13/2019	16:40	Cash	5.8
68	838-78-4295	C	Naypyitaw	Normal	Female	Health and beauty	33.47	2	3.347	70.287	2/10/2019	15:43	Ewallet	6.7
69	109-28-2512	B	Mandalay	Member	Female	Fashion accessories	97.61	6	29.283	614.943	1/7/2019	15:01	Ewallet	9.9
70	232-11-3025	A	Yangon	Normal	Male	Sports and travel	78.77	10	39.385	827.085	1/24/2019	10:04	Cash	6.4
71	382-03-4532	A	Yangon	Member	Female	Health and beauty	18.33	1	0.9165	19.2465	2/2/2019	18:50	Cash	4.3
72	393-65-2792	C	Naypyitaw	Normal	Male	Food and beverages	89.48	10	44.74	939.54	1/6/2019	12:46	Credit card	9.6
73	796-12-2025	C	Naypyitaw	Normal	Male	Fashion accessories	62.12	10	31.06	652.26	2/11/2019	16:19	Cash	5.9
74	510-95-6347	B	Mandalay	Member	Female	Food and beverages	48.52	3	7.278	152.838	3/5/2019	18:17	Ewallet	4
75	841-35-6630	C	Naypyitaw	Normal	Female	Electronic accessories	75.91	6	22.773	478.233	3/9/2019	18:21	Cash	8.7
76	287-21-9091	A	Yangon	Normal	Male	Home and lifestyle	74.67	9	33.6015	705.6315	1/22/2019	10:55	Ewallet	9.4
77	732-94-0499	C	Naypyitaw	Normal	Female	Electronic accessories	41.65	10	20.825	437.325	1/13/2019	17:04	Credit card	5.4
78	263-10-3913	C	Naypyitaw	Member	Male	Fashion accessories	49.04	9	22.068	463.428	1/9/2019	14:20	Credit card	8.6
79	381-20-0914	A	Yangon	Member	Female	Fashion accessories	20.01	9	9.0045	189.0945	1/12/2019	15:48	Credit card	5.7
80	829-49-1914	C	Naypyitaw	Member	Female	Food and beverages	78.31	10	39.155	822.255	3/5/2019	16:24	Ewallet	6.6
81	756-01-7507	C	Naypyitaw	Normal	Female	Health and beauty	20.38	5	5.095	106.995	1/22/2019	18:56	Cash	6
82	870-72-4431	C	Naypyitaw	Normal	Female	Health and beauty	99.19	6	29.757	624.897	1/21/2019	14:42	Credit card	5.5
83	847-38-7188	B	Mandalay	Normal	Female	Food and beverages	96.68	3	14.502	304.542	1/26/2019	19:56	Ewallet	6.4
84	480-63-2856	C	Naypyitaw	Normal	Male	Food and beverages	19.25	8	7.7	161.7	1/23/2019	18:37	Ewallet	6.6
85	787-56-0757	C	Naypyitaw	Member	Female	Food and beverages	80.36	4	16.072	337.512	2/23/2019	18:45	Credit card	8.3
86	360-39-5055	C	Naypyitaw	Member	Male	Sports and travel	48.91	5	12.2275	256.7775	3/9/2019	10:17	Cash	6.6
87	730-50-9884	C	Naypyitaw	Normal	Female	Sports and travel	83.06	7	29.071	610.491	3/5/2019	14:31	Ewallet	4
88	362-58-8315	C	Naypyitaw	Normal	Male	Fashion accessories	76.52	5	19.13	401.73	3/25/2019	10:23	Cash	9.9
89	633-44-8566	A	Yangon	Member	Male	Food and beverages	49.38	7	17.283	362.943	3/27/2019	20:35	Credit card	7.3
90	504-35-8843	A	Yangon	Normal	Male	Sports and travel	42.47	1	2.1235	44.5935	1/2/2019	16:57	Cash	5.7
91	318-68-5053	B	Mandalay	Normal	Female	Health and beauty	76.99	6	23.097	485.037	2/27/2019	17:55	Cash	6.1
92	565-80-5980	C	Naypyitaw	Member	Female	Home and lifestyle	47.38	4	9.476	198.996	1/23/2019	10:25	Cash	7.1
93	225-32-0908	C	Naypyitaw	Normal	Female	Sports and travel	44.86	10	22.43	471.03	1/26/2019	19:54	Ewallet	8.2
94	873-51-0671	A	Yangon	Member	Female	Sports and travel	21.98	7	7.693	161.553	1/10/2019	16:42	Ewallet	5.1
95	152-08-9985	B	Mandalay	Member	Male	Health and beauty	64.36	9	28.962	608.202	3/12/2019	12:09	Credit card	8.6
96	512-91-0811	C	Naypyitaw	Normal	Male	Health and beauty	89.75	1	4.4875	94.2375	2/6/2019	20:05	Credit card	6.6
97	594-34-4444	A	Yangon	Normal	Male	Electronic accessories	97.16	1	4.858	102.018	3/8/2019	20:38	Ewallet	7.2
98	766-85-7061	B	Mandalay	Normal	Male	Health and beauty	87.87	10	43.935	922.635	3/29/2019	10:25	Ewallet	5.1
99	871-39-9221	C	Naypyitaw	Normal	Female	Electronic accessories	12.45	6	3.735	78.435	2/9/2019	13:11	Cash	4.1
100	865-92-6136	A	Yangon	Normal	Male	Food and beverages	52.75	3	7.9125	166.1625	3/23/2019	10:16	Ewallet	9.3