Homework answers / question archive / Dear Participants, Please go through the problem statement and find the Dataset attached in the Project Section

Dear Participants, Please go through the problem statement and find the Dataset attached in the Project Section

Statistics

Share With

Dear Participants, Please go through the problem statement and find the Dataset attached in the Project Section. Dataset: Cafe_Data_MRA.xlsx 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. 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 its revenues. He is able to provide you with a data set for POS (point of sale data) for one of his chains. Exploratory Analysis (45 Marks) ? Exploratory Analysis of data & an executive summary (in PPT) 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? 15 Marks ?

Are there certain menu items that can be taken off the menu? 7.5 Marks ?

Are there trends across months that you are able to notice? 7.5 Marks

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? o Use of Market Basket Analysis (Association Rules) 15 Marks ? Write Something about the association rule and its relevance in this case ? Add KNIME workflow Image or Python package used ? Write about threshold values of Support and Confidence o Associations Identified 15 Marks ? Put the associations in a tabular manner ? Explain about support, confidence, & lift values that are calculated o The suggestion of Possible Combos with Lucrative Offers 15 Marks ? Write recommendations ? Make discount offers or combos ( or buy two get one free) based on the associations and your experience Minimum PPT Requirements: ? Minimum 12 Slides of PPT required: o Minimum 8 slides on EDA and Inferences. o Minimum 2 Slides on Market Basket Analysis o Minimum 2 slides on Market Basket Analysis inferences and recommendations o Do not add code o If you are using KNIME, adding KNIME Workflow is a must o It is a must to add plots/graphs in the PPT itself Refer to Project FAQs in case of any doubt Please note the following: ? Your submission should include the following: o A PowerPoint Presentation - You will be evaluated based upon this. (You can convert PPT to PDF, that is also acceptable) o Supporting file- You can use any tool(Tableau or Python or KNIME) used in the DSBA program for this project. It’s a must to share the code for reference ? Please ensure timely submission as a post-deadline assignment will not be accepted. Thanks Program Office