Product Sales analysis and create a chart

[David_Billa]

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

[Reeza]

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

[Anandkvn]

Hi David 

This case study task given by wells fargo ?

did you complete this task please post here this case study