topic Re: Product Sales analysis and create a chart in SAS Programming

Product Sales analysis and create a chart

David_Billa — Mon, 22 Nov 2021 13:45:23 GMT

This is little off topic. Given below is the sample product sales data. What are the different types of analysis one can perform with this data? After the analysis I want to find the inferences and create some charts (e.g. bar, pie..) Any help?

I just looking for an idea to start with.

REST_KEY	MITM_KEY	Menu Item	Menu Item Combo Meal Flag	Reporting Day	POS Consumer Price	POS Total Units Sold Promo and Regular	POS Promotion Units Sold	POS Units Sold	POS Combo Units Sold
1364	7	00000007- FRENCH CHEESE	N	27-01-2011	3.79	196	0	196	189
1364	7	00000007- FRENCH CHEESE	N	28-01-2011	3.79	211	0	211	202
5357	35	00000035-HASH BROWN	N	07-01-2011	1	205	0	205	161

Re: Product Sales analysis and create a chart

Reeza — Mon, 22 Nov 2021 16:30:44 GMT

Something along the lines of:

Highest product sellers
What sells best at what time of day/week (heatmaps)
If you have ID of customers, repeat sellers/favourites
If you have ID of sales, best sales person, most sales per person
Best day of the week sales, worst day of the week
Combos versus individual items
Profit analysis sliced by all the above if you have cost or can assume a percentage markup

Re: Product Sales analysis and create a chart

BrahmanandaRao — Thu, 11 May 2023 06:58:54 GMT

Hi David

This case study task given by wells fargo ?

did you complete this task please post here this case study