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]

there are loads of insights you could summarise from that info

but if homeowrk / assignment i would not list them now - also i spent years in Business MI and consultancy doing these sort of Metrics and KPIs

the idea is you learn and see it - not me , i'm retired now .... and not learning

i have listed about 12 off the top of my head

have a go - and post back

are you expected to actually do the stats - or just provide insights as a list

what would a business want to know about there sales , customer, SKU's invoices

just to provide insights as a list in an open-ended form kind of way

 

[etaf]

ok, its homework then ?
YES

 

[sam97]

ok, its homework then ?
YES

its for work

 

[etaf]

ok
so not homework or an assignment - sorry to be arkward - but often people come onto forums with homework / assignements and by forum members giving you answers your no tgoing to learn

i dont quite see why work would want a list .....

anyway

what would the company want to know
think about looking at the data from various view points
SKU ,
CUSTOMER
REVENUE
INVOICE
Ratios
Averages / max / Min
frequency
best sales
worse sales
Timescales - weekly , daily , monthly

develop some ideas from that and post back the KPI - metrics stats

sorry but i think you do need to think about this as asked to produce for work

 

[sam97]

ok
so not homework or an assignment - sorry to be arkward - but often people come onto forums with homework / assignements and by forum members giving you answers your no tgoing to learn

i dont quite see why work would want a list .....

anyway

what would the company want to know
think about looking at the data from various view points
SKU ,
CUSTOMER
REVENUE
INVOICE
Ratios
Averages / max / Min
frequency
best sales
worse sales
Timescales - weekly , daily , monthly

develop some ideas from that and post back the KPI - metrics stats

sorry but i think you do need to think about this as asked to produce for work

they want us to see what we can point out with the data. For example, I noticed immediately how customer "C" had ordered noticeably higher quantity.

also SKU "1" accounts for the majority of Qty

and Customer "J" has ordered more in Qty over the few months

 

[etaf]

there you go
and customer C - what SKU - what weight - what time - any pattern
SKU 1 - revenue earned - highest QTY - but whats the revenue - from that weight
What is customer J ordering - what SKUs can they be incentivised to buy different SKUs - graph the invoices by timeline - maybe its seasonal

how about looking at

SKU , - most sales overall - by time week/month/etc - by customer - biggest earning, lowest earning - average, mean , Max customers ,
CUSTOMER - - most sales overall - by time week/month/etc - by SKU - biggest earning, lowest earning - average, mean , Max SKUs each month - most skus per customer - customer who buy only 1 SKU , possible upsale ,
REVENUE - highest revenue sku/customer - things like parato - top 80% revenue come from X SKU , X customer
INVOICE - max revenue per invoice , number of invoices per week/month
Ratios - SKU to customer , sku to revenue
Averages / max / Min / mean - look at some of those see if things stand out
frequency
best sales - Customer, SKU ,
worse sales
Timescales - weekly , daily , monthly
Same thing for the Weight - Revenue per kilogram - per customer - per sku -

Graph the SKUs by time
Graph the SKUs by weight
see what stands out from that type of thing
Maybe even look at SPC - any outliers

play around with the data like the above - see what may stick out

 

[sam97]

thank you I've been really stuck its a work project for supply chain and I'm fairly new to it. any other advice on what I should add to my report?

 

[etaf]

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

 

[Michael M]

AND also Custom filtering !!

 

[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
	K
37
sku

ive split the data up to get a clear look at the data this way