Please help me with a second opinion asap on what you think with this data!

[sam97]

This project is fairly open ended, we are really just looking to see how you think through the data, what insights you can identify, and your used of excel to arrive at those insights.

4	50.00	Kilogram	5/13/2022	A
4	100.00	Kilogram	5/13/2022	C
1	5,000.00	Gram	5/13/2022	C
1	1,000.00	Gram	5/13/2022	I
1	3,000.00	Gram	5/13/2022	S
1	5,000.00	Gram	5/13/2022	S
1	10,000.00	Gram	5/11/2022	D
1	3,000.00	Gram	5/11/2022	I
1	3,000.00	Gram	5/11/2022	I
1	3,000.00	Gram	5/11/2022	P
4	100.00	Kilogram	5/10/2022	B
6	75.00	Kilogram	5/10/2022	I
1	3,000.00	Gram	5/10/2022	P
1	5,000.00	Gram	5/10/2022	P
4	9,000.00	Kilogram	5/9/2022	C
1	500.00	Gram	5/9/2022	N
1	1,000.00	Gram	5/9/2022	N
1	500.00	Gram	5/9/2022	R
4	100.00	Kilogram	5/6/2022	A
1	1,000.00	Gram	5/6/2022	D
4	2,450.00	Kilogram	5/6/2022	D
4	550.00	Kilogram	5/6/2022	D
4	200.00	Kilogram	5/6/2022	D
1	1,000.00	Gram	5/6/2022	G
5	1,050.00	Kilogram	5/5/2022	E
4	100.00	Kilogram	5/5/2022	L
1	2,000.00	Gram	5/3/2022	D
6	825.00	Kilogram	5/3/2022	I
1	4,000.00	Gram	5/3/2022	J
1	15,000.00	Gram	5/3/2022	J
1	5,000.00	Gram	5/3/2022	T
4	225.00	Kilogram	5/2/2022	A
1	10,000.00	Gram	5/2/2022	N
4	1,000.00	Kilogram	5/2/2022	N
6	50.00	Kilogram	4/29/2022	I
4	800.00	Kilogram	4/29/2022	I
3	25.00	Kilogram	4/29/2022	N
1	4,000.00	Gram	4/29/2022	N
7	125.00	Kilogram	4/29/2022	N
7	500.00	Kilogram	4/29/2022	P
1	500.00	Gram	4/29/2022	S
1	100.00	Gram	4/29/2022	S
1	300.00	Gram	4/29/2022	S
1	100.00	Gram	4/29/2022	S
4	625.00	Kilogram	4/27/2022	E
4	1,825.00	Kilogram	4/26/2022	A
4	625.00	Kilogram	4/26/2022	G
1	53,000.00	Gram	4/26/2022	G
1	100,000.00	Gram	4/25/2022	C
4	1,050.00	Kilogram	4/25/2022	N
4	50.00	Kilogram	4/22/2022	B
4	25.00	Kilogram	4/22/2022	C
4	25.00	Kilogram	4/22/2022	C
4	50.00	Kilogram	4/22/2022	C
4	25.00	Kilogram	4/22/2022	M
1	500.00	Gram	4/22/2022	P
1	5,000.00	Gram	4/22/2022	S
4	50.00	Kilogram	4/21/2022	C
3	5.00	Kilogram	4/21/2022	N
1	3,000.00	Gram	4/21/2022	V
1	5,000.00	Gram	4/21/2022	V
1	200.00	Gram	4/20/2022	F
1	1,000.00	Gram	4/20/2022	F
1	1,000.00	Gram	4/20/2022	N
3	50.00	Kilogram	4/20/2022	N
4	475.00	Kilogram	4/19/2022	E
4	25.00	Kilogram	4/19/2022	G
3	275.00	Kilogram	4/19/2022	P
4	25.00	Kilogram	4/19/2022	S
4	25.00	Kilogram	4/19/2022	Z
4	325.00	Kilogram	4/18/2022	B
1	3,000.00	Gram	4/18/2022	E
1	1,000.00	Gram	4/18/2022	R
1	3,000.00	Gram	4/18/2022	W
1	10,000.00	Gram	4/14/2022	B
1	20,000.00	Gram	4/14/2022	B
1	500.00	Gram	4/14/2022	M
1	500.00	Gram	4/14/2022	U
4	100.00	Kilogram	4/13/2022	C
1	10,000.00	Gram	4/13/2022	N
1	16,000.00	Gram	4/12/2022	G
7	50.00	Kilogram	4/12/2022	T
1	1,000.00	Gram	4/11/2022	A
1	4,000.00	Gram	4/11/2022	A
1	2,000.00	Gram	4/11/2022	V
1	3,000.00	Gram	4/11/2022	V
1	25,000.00	Gram	4/11/2022	V
4	50.00	Kilogram	4/8/2022	C
4	75.00	Kilogram	4/8/2022	C
4	100.00	Kilogram	4/8/2022	D
4	75.00	Kilogram	4/8/2022	D
4	25.00	Kilogram	4/8/2022	D
4	100.00	Kilogram	4/8/2022	S
4	350.00	Kilogram	4/8/2022	U
1	500.00	Gram	4/7/2022	A
1	500.00	Gram	4/7/2022	A
4	150.00	Kilogram	4/7/2022	C
4	50.00	Kilogram	4/7/2022	P
4	50.00	Kilogram	4/7/2022	P
6	100.00	Kilogram	4/7/2022	P
1	500.00	Gram	4/7/2022	P
1	5,000.00	Gram	4/7/2022	S
1	25,000.00	Gram	4/7/2022	S
4	325.00	Kilogram	4/6/2022	N
7	525.00	Kilogram	4/5/2022	C
4	100.00	Kilogram	4/5/2022	D
4	150.00	Kilogram	4/4/2022	N
1	5,000.00	Gram	4/4/2022	S
1	25,000.00	Gram	4/4/2022	S
4	125.00	Kilogram	4/4/2022	S
1	2,000.00	Gram	4/4/2022	S
1	10,000.00	Gram	4/4/2022	S
4	2,950.00	Kilogram	3/31/2022	C
1	2,000.00	Gram	3/31/2022	L
4	125.00	Kilogram	3/30/2022	S
4	25.00	Kilogram	3/29/2022	E
4	175.00	Kilogram	3/29/2022	G
7	50.00	Kilogram	3/29/2022	W
1	2,000.00	Gram	3/28/2022	A
1	5,000.00	Gram	3/28/2022	P
4	75.00	Kilogram	3/25/2022	A
6	400.00	Kilogram	3/25/2022	C
4	1,125.00	Kilogram	3/25/2022	C
6	200.00	Kilogram	3/25/2022	C
4	10,700.00	Kilogram	3/25/2022	C
4	25.00	Kilogram	3/25/2022	D
4	100.00	Kilogram	3/25/2022	D
4	75.00	Kilogram	3/24/2022	C
6	775.00	Kilogram	3/24/2022	I
4	100.00	Kilogram	3/24/2022	N
4	50.00	Kilogram	3/24/2022	P
4	50.00	Kilogram	3/24/2022	P
1	26,000.00	Gram	3/22/2022	G
4	100.00	Kilogram	3/22/2022	L
4	400.00	Kilogram	3/22/2022	N
4	10,975.00	Kilogram	3/21/2022	B
4	450.00	Kilogram	3/21/2022	S
4	1,600.00	Kilogram	3/18/2022	A
1	1,000.00	Gram	3/18/2022	D
4	825.00	Kilogram	3/18/2022	E
4	1,300.00	Kilogram	3/18/2022	E
5	750.00	Kilogram	3/18/2022	E
4	100.00	Kilogram	3/18/2022	I
4	25.00	Kilogram	3/18/2022	M
1	2,000.00	Gram	3/18/2022	M
4	150.00	Kilogram	3/18/2022	N
4	450.00	Kilogram	3/18/2022	S
1	1,000.00	Gram	3/18/2022	U
1	300.00	Gram	3/17/2022	A
1	1,000.00	Gram	3/17/2022	A
4	50.00	Kilogram	3/17/2022	C
4	75.00	Kilogram	3/17/2022	C
4	25.00	Kilogram	3/16/2022	C
1	1,000.00	Gram	3/14/2022	D
1	100.00	Gram	3/14/2022	N
4	1,000.00	Kilogram	3/14/2022	N
7	3,600.00	Kilogram	3/14/2022	P
1	2,000.00	Gram	3/14/2022	V
1	3,000.00	Gram	3/14/2022	V
1	25,000.00	Gram	3/14/2022	V
1	4,000.00	Gram	3/11/2022	C
4	25.00	Kilogram	3/11/2022	Z
4	125.00	Kilogram	3/10/2022	D
4	50.00	Kilogram	3/10/2022	D
4	75.00	Kilogram	3/10/2022	D
6	200.00	Kilogram	3/10/2022	P
5	175.00	Kilogram	3/9/2022	I
7	50.00	Kilogram	3/9/2022	S
1	1,000.00	Gram	3/8/2022	Z
1	3,000.00	Gram	3/7/2022	A
1	5,000.00	Gram	3/7/2022	A
1	5,000.00	Gram	3/7/2022	P
4	300.00	Kilogram	3/4/2022	A
4	50.00	Kilogram	3/4/2022	S
4	1,000.00	Kilogram	3/3/2022	N
1	10,000.00	Gram	3/3/2022	W
1	1,000.00	Gram	3/2/2022	A
6	175.00	Kilogram	3/2/2022	I
5	250.00	Kilogram	3/2/2022	L
1	25,000.00	Gram	3/2/2022	S
1	1,000.00	Gram	3/2/2022	V
4	75.00	Kilogram	3/1/2022	A
4	125.00	Kilogram	3/1/2022	A
1	500.00	Gram	3/1/2022	A
1	500.00	Gram	3/1/2022	A
4	50.00	Kilogram	3/1/2022	B
1	1,000.00	Gram	2/28/2022	D
4	100.00	Kilogram	2/28/2022	N
4	2,000.00	Kilogram	2/25/2022	B
4	1,050.00	Kilogram	2/25/2022	B
4	200.00	Kilogram	2/25/2022	G
7	200.00	Kilogram	2/25/2022	M
4	25.00	Kilogram	2/25/2022	S
4	25.00	Kilogram	2/25/2022	T
4	200.00	Kilogram	2/24/2022	A
4	50.00	Kilogram	2/24/2022	C
4	10,000.00	Kilogram	2/24/2022	C
1	20,000.00	Gram	2/24/2022	D
1	1,000.00	Gram	2/24/2022	D
4	150.00	Kilogram	2/24/2022	D
4	25.00	Kilogram	2/24/2022	D
4	25.00	Kilogram	2/24/2022	D
4	25.00	Kilogram	2/24/2022	D
4	25.00	Kilogram	2/24/2022	D
4	150.00	Kilogram	2/24/2022	D
4	25.00	Kilogram	2/24/2022	D
4	25.00	Kilogram	2/24/2022	D
4	25.00	Kilogram	2/24/2022	D
4	25.00	Kilogram	2/24/2022	D
4	50.00	Kilogram	2/24/2022	Z
4	150.00	Kilogram	2/23/2022	A
4	25.00	Kilogram	2/23/2022	C
4	25.00	Kilogram	2/23/2022	C
4	10,000.00	Kilogram	2/23/2022	C
6	1,375.00	Kilogram	2/23/2022	C
4	625.00	Kilogram	2/23/2022	C
4	1,925.00	Kilogram	2/23/2022	C
6	1,250.00	Kilogram	2/23/2022	C
6	50.00	Kilogram	2/23/2022	L
3	350.00	Kilogram	2/23/2022	P
4	6,000.00	Kilogram	2/22/2022	C
4	150.00	Kilogram	2/22/2022	C
4	1,500.00	Kilogram	2/22/2022	C
1	10,000.00	Gram	2/22/2022	F
1	100,000.00	Gram	2/21/2022	C
1	2,000.00	Gram	2/18/2022	V
4	75.00	Kilogram	2/17/2022	S
1	500.00	Gram	2/16/2022	E
1	2,000.00	Gram	2/16/2022	E
7	2,000.00	Kilogram	2/16/2022	P
1	400.00	Gram	2/16/2022	S
1	300.00	Gram	2/15/2022	A
4	25.00	Kilogram	2/15/2022	E
4	2,050.00	Kilogram	2/15/2022	E
1	500.00	Gram	2/15/2022	H
1	75,000.00	Gram	2/15/2022	K
1	300.00	Gram	2/15/2022	M
5	125.00	Kilogram	2/11/2022	S
4	150.00	Kilogram	2/11/2022	S
1	2,000.00	Gram	2/10/2022	J
1	5,000.00	Gram	2/10/2022	J
6	2,625.00	Kilogram	2/10/2022	M
6	250.00	Kilogram	2/10/2022	M
4	375.00	Kilogram	2/10/2022	N
4	1,250.00	Kilogram	2/9/2022	A
4	325.00	Kilogram	2/9/2022	G
7	25.00	Kilogram	2/9/2022	T
1	500.00	Gram	2/8/2022	A
1	500.00	Gram	2/8/2022	A
1	1,000.00	Gram	2/8/2022	C
4	525.00	Kilogram	2/8/2022	F
3	225.00	Kilogram	2/8/2022	P
1	5,000.00	Gram	2/8/2022	S
1	25,000.00	Gram	2/8/2022	S
4	200.00	Kilogram	2/7/2022	I
1	10,000.00	Gram	2/7/2022	L
4	100.00	Kilogram	2/7/2022	P
5	250.00	Kilogram	2/4/2022	E
5	125.00	Kilogram	2/4/2022	E
6	4,825.00	Kilogram	2/3/2022	I
4	650.00	Kilogram	2/3/2022	I
4	175.00	Kilogram	2/3/2022	S
4	350.00	Kilogram	2/3/2022	U
6	175.00	Kilogram	2/3/2022	Z
4	2,000.00	Kilogram	2/2/2022	A
1	10,000.00	Gram	2/2/2022	F
2	25.00	Kilogram	2/2/2022	N
2	200.00	Kilogram	2/2/2022	N
2	800.00	Kilogram	2/2/2022	N
4	75.00	Kilogram	2/2/2022	P
4	200.00	Kilogram	2/1/2022	B
4	150.00	Kilogram	2/1/2022	E
4	750.00	Kilogram	2/1/2022	I
3	25.00	Kilogram	2/1/2022	P
4	7,300.00	Kilogram	1/31/2022	C
4	2,500.00	Kilogram	1/31/2022	C
1	100,000.00	Gram	1/31/2022	C
1	1,000.00	Gram	1/31/2022	E
1	2,000.00	Gram	1/31/2022	I
1	4,000.00	Gram	1/31/2022	I
1	1,000.00	Gram	1/31/2022	N
5	200.00	Kilogram	1/31/2022	S
4	325.00	Kilogram	1/31/2022	S
4	325.00	Kilogram	1/31/2022	S
4	25.00	Kilogram	1/28/2022	C
6	25.00	Kilogram	1/28/2022	G
7	25.00	Kilogram	1/28/2022	G
5	25.00	Kilogram	1/28/2022	G
1	3,000.00	Gram	1/28/2022	H
1	5,000.00	Gram	1/28/2022	P
6	75.00	Kilogram	1/27/2022	S
1	1,000.00	Gram	1/27/2022	S
6	25.00	Kilogram	1/27/2022	T
7	50.00	Kilogram	1/27/2022	W
4	175.00	Kilogram	1/26/2022	N
1	1,000.00	Gram	1/25/2022	D
4	350.00	Kilogram	1/25/2022	F
4	25.00	Kilogram	1/25/2022	I
4	225.00	Kilogram	1/25/2022	I
6	275.00	Kilogram	1/25/2022	I
4	100.00	Kilogram	1/25/2022	I
4	1,000.00	Kilogram	1/25/2022	N
1	1,000.00	Gram	1/24/2022	D
1	1,000.00	Gram	1/24/2022	D
4	125.00	Kilogram	1/24/2022	D
4	25.00	Kilogram	1/24/2022	D
4	25.00	Kilogram	1/24/2022	D
4	25.00	Kilogram	1/24/2022	D
4	25.00	Kilogram	1/24/2022	D
4	25.00	Kilogram	1/24/2022	D
4	1,400.00	Kilogram	1/24/2022	H
4	25.00	Kilogram	1/24/2022	J
3	5.00	Kilogram	1/24/2022	J
1	1,000.00	Gram	1/24/2022	N
4	350.00	Kilogram	1/24/2022	N
4	25.00	Kilogram	1/24/2022	N
7	25.00	Kilogram	1/24/2022	T
4	125.00	Kilogram	1/24/2022	U
1	2,000.00	Gram	1/21/2022	F
4	25.00	Kilogram	1/21/2022	G
1	3,000.00	Gram	1/21/2022	P
1	5,000.00	Gram	1/21/2022	S
1	25,000.00	Gram	1/21/2022	S
4	25.00	Kilogram	1/21/2022	Z
4	50.00	Kilogram	1/21/2022	Z
4	675.00	Kilogram	1/20/2022	C
4	100.00	Kilogram	1/20/2022	C
7	50.00	Kilogram	1/20/2022	N
5	300.00	Kilogram	1/20/2022	S
4	725.00	Kilogram	1/20/2022	S
4	100.00	Kilogram	1/20/2022	S
4	100.00	Kilogram	1/19/2022	B
1	10,000.00	Gram	1/19/2022	N
1	2,000.00	Gram	1/18/2022	A
1	100,000.00	Gram	1/18/2022	C
1	100.00	Gram	1/18/2022	N
1	3,000.00	Gram	1/14/2022	S
1	5,000.00	Gram	1/14/2022	S
4	2,000.00	Kilogram	1/13/2022	A
1	10,000.00	Gram	1/13/2022	I
4	150.00	Kilogram	1/13/2022	N
1	1,000.00	Gram	1/12/2022	A
4	100.00	Kilogram	1/12/2022	B
4	25.00	Kilogram	1/12/2022	C
4	5,275.00	Kilogram	1/12/2022	C
4	2,700.00	Kilogram	1/12/2022	C
5	150.00	Kilogram	1/12/2022	D
7	25.00	Kilogram	1/12/2022	J
1	10,000.00	Gram	1/12/2022	N
7	1,700.00	Kilogram	1/12/2022	P
4	25.00	Kilogram	1/12/2022	V
4	350.00	Kilogram	1/11/2022	M
4	2,400.00	Kilogram	1/11/2022	N
5	100.00	Kilogram	1/11/2022	N
3	25.00	Kilogram	1/11/2022	X
1	200.00	Gram	1/7/2022	A
1	200.00	Gram	1/7/2022	A
4	5,500.00	Kilogram	1/7/2022	A
4	125.00	Kilogram	1/7/2022	G
1	1,000.00	Gram	1/7/2022	V
1	1,000.00	Gram	1/7/2022	V
1	5,000.00	Gram	1/6/2022	A
4	50.00	Kilogram	1/6/2022	C
5	50.00	Kilogram	1/6/2022	G
4	425.00	Kilogram	1/6/2022	N
7	50.00	Kilogram	1/6/2022	N
1	200.00	Gram	1/5/2022	C
1	300.00	Gram	1/5/2022	C
1	1,000.00	Gram	1/5/2022	C
1	1,000.00	Gram	1/5/2022	C
1	10,000.00	Gram	1/5/2022	D
1	1,000.00	Gram	1/5/2022	D
1	6,000.00	Gram	1/5/2022	D
1	200.00	Gram	1/5/2022	N
7	500.00	Kilogram	1/5/2022	S
4	75.00	Kilogram	1/4/2022	A
4	300.00	Kilogram	1/4/2022	F
4	50.00	Kilogram	1/4/2022	M
4	425.00	Kilogram	1/4/2022	N
1	5,000.00	Gram	1/4/2022	S
4	500.00	Kilogram	1/3/2022	A
4	2,000.00	Kilogram	1/3/2022	A

 

[sam97]

did you follow

offthelip​

advice and change all the KG to grams - so the units are the same

does the company have any strategy , business plan, KPI, that perhaps maybe relevant

do you know how to create pivot table - this would be ideal for slicing the data

Sales Data Project.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S
1
2	Row Labels	Sum of Qty
3	C	489,825.00
4	1	412,500.00
5	4	73,575.00
6	6	3,225.00
7	7	525.00
8	S	189,875.00
9	1	185,400.00
10	4	3,225.00
11	5	625.00
12	6	75.00
13	7	550.00
14	G	97,625.00
15	1	96,000.00
16	4	1,500.00
17	5	75.00
18	6	25.00		Customer C noticably has higher quantites than any other customer with a total of 36.99% of the orders belonging to them. With that information, we should ensure we have enough inventory especially for SKU 1 as that item is the most ordered.
19	7	25.00
20	K	75,000.00		Throughout all customers SKU 1 is the the most odered item with over 1.1 million orders between all customers.
21	1	75,000.00
22	V	73,025.00
23	1	73,000.00								Row Labels	Sum of Qty
24	4	25.00								1	1,155,800.00
25	D	61,775.00								4	139,525.00
26	1	57,000.00								6	13,750.00
27	4	4,625.00								7	9,550.00
28	5	150.00								5	3,550.00
29	N	60,930.00								2	1,025.00
30	1	48,900.00								3	985.00
31	2	1,025.00								Grand Total	1,324,185.00
32	3	80.00
33	4	10,600.00
34	5	100.00
35	7	225.00
36	A	47,050.00
37	1	29,000.00
38	4	18,050.00
39	B	44,950.00
40	1	30,000.00
41	4	14,950.00
42	P	39,350.00
43	1	30,000.00
44	3	875.00
45	4	375.00
46	6	300.00
47	7	7,800.00
48	I	33,025.00
49	1	23,000.00
50	4	2,850.00
51	5	175.00
52	6	7,000.00
53	J	26,055.00
54	1	26,000.00
55	3	5.00
56	4	25.00
57	7	25.00
58	F	24,375.00
59	1	23,200.00
60	4	1,175.00
61	E	14,150.00
62	1	6,500.00
63	4	5,475.00
64	5	2,175.00
65	W	13,100.00
66	1	13,000.00
67	7	100.00
68	L	12,500.00
69	1	12,000.00
70	4	200.00
71	5	250.00
72	6	50.00
73	M	6,325.00
74	1	2,800.00
75	4	450.00
76	6	2,875.00
77	7	200.00
78	T	5,150.00
79	1	5,000.00
80	4	25.00
81	6	25.00
82	7	100.00
83	H	4,900.00
84	1	3,500.00
85	4	1,400.00
86	U	2,325.00
87	1	1,500.00
88	4	825.00
89	R	1,500.00
90	1	1,500.00
91	Z	1,350.00
92	1	1,000.00
93	4	175.00
94	6	175.00
95	X	25.00
96	3	25.00
97	Grand Total	1,324,185.00
sku