Please go through the problem statement and find the Dataset attached in the Project Section.

Dataset: Coffee Cafe Night (Attached)

“The data set provided to you is the data set of a Café Chain for one of its restaurants. Do a thorough analysis of the data and come up with the following analysis and present it in a powerpoint deck of 10 – 20 slides.

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 that has customer level information. But, he is able to provide you with a data set for POS (point of sale data) for one of his chains.

1. Exploratory Analysis (45 Marks)

• Exploratory Analysis of data & an executive summary of your top findings, supported by graphs. 15 Marks
• What kind of trends do you notice in terms of consumer behavior over different times of the day and different days of the week? Can you give concrete recommendations based on the same? 10 Marks
• Are there certain menu items that can be taken off the menu? 10 Marks
• Are there trends across months that you are able to notice?  10 Marks

1. Menu Analysis– (45 Marks)

• 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?                                      45 Marks

Please note the following:

• Your submission:should be a PowerPoint Presentation (Deck of 19- 20 slides). Appendices are not counted in the word limit.
• You must give the sources of data presented. Do not refer to blogs; Wikipedia etc.
• Please ensure timely submission as post-deadline assignment will not be accepted.

Scoring guide (Rubric) – Rubric (3)

CriteriaPointsExploratory Analysis of data & executive summary of your top findings, supported by graphs.f criterion15What kind of trends do you notice in terms of consumer behavior over different times of the day and different days of the week? Can you give concrete recommendations based on the same? on10Are there certain menu items that can be taken off the menu?10Are there trends across months that you are able to notice?erion10Identify 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?45Points90