Exploratory Analysis of the data and an executive summary of your top findings, supported by graphs.
What kind of trends do you notice in terms of consumer behaviour over different times of the day and different days of the week? Can you give concrete recommendations based on the same?
Are there certain menu items that can be taken off the menu?
Are there trends across months that you are able to notice?
Menu Analysis- Identify the most popular combos that can be suggested to the restaurant chain after a thorough analysis of the most commonly occurring sets of menu items in the customer orders
The restaurant doesn’t have any combo meals.
Can you suggest the best combo meals?
3. Price Analysis - Can you identify the pricing changes that have happened and which menu items saw a positive impact of the price changes and which menu items saw a negative impact of the price changes?
Can you show a price analysis chart where you show a four-quadrant price analysis as below? Please do quantify the volume increase and decrease as well in relation to the price changes
Price increased – sales volume decreased in post period of 2-4 weeks ( take a pre-period window of sales of 1-2 weeks)
Price increased – Sales volume increased
Price decreased – Sales volume increased
Price decreased – Sales volume decreased
The owner of the restaurant wants you to use this data to come up with a set of recommendations that can help his Café Chain increase his revenues. He has not been able to launch a loyalty program and is unable to provide you with a data set which has customer level information. But, he is able to provide you with a data set for POS (point of sale data) for one his chains.