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...

Question as been attached in the pdf



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 https://olympus.greatlearning.in/courses/8846/files/1057500/download?wrap=1 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 Sheet1 DateBill Number Item DescTimeQuantityRateTaxDiscountTotalCategory 4/1/10G0470115QUA MINERAL WATER(1000ML) 1:15:11 PM15011.88061.88BEVERAGE 4/1/10G0470115MONSOON MALABAR (AULAIT) 1:15:11 PM110023.750123.75BEVERAGE 4/1/10G0470116MASALA CHAI CUTTING 1:17:35 PM1409.5049.5BEVERAGE 4/1/10G0470117QUA MINERAL WATER(1000ML) 1:19:55 PM15011.88061.88BEVERAGE 4/1/10G0470283MOROCCAN MINT TEA 1:20:18 AM14510.69055.69BEVERAGE 4/1/10G0470283QUA MINERAL WATER(1000ML) 1:20:18 AM15011.88061.88BEVERAGE 4/1/10G0470118MASALA CHAI CUTTING 1:21:34 PM1409.5049.5BEVERAGE 4/1/10G0470118MOROCCAN MINT TEA 1:21:34 PM14510.69055.69BEVERAGE 4/1/10G0470284CAPPUCCINO 1:29:38 AM16014.25074.25BEVERAGE 4/1/10G0470285MOROCCAN MINT TEA 1:29:46 AM14510.69055.69BEVERAGE 4/1/10G0470285SUMATRA MANDHELING (REG) 1:29:46 AM19522.560117.56BEVERAGE 4/1/10G0470285BRAZIL BOURBONSANTOS (AULAIT) 1:29:46 AM111527.310142.31BEVERAGE 4/1/10G0470120LEMON ICED TEA 1:36:33 PM18520.190105.19BEVERAGE 4/1/10G0470122COUNTRY LEMONADE 1:42:05 PM18520.190105.19BEVERAGE 4/1/10G0470122LEMON ICED TEA 1:42:05 PM28540.380210.38BEVERAGE 4/1/10G0470127CAPPUCCINO 2:02:15 PM16014.25074.25BEVERAGE 4/1/10G0470128QUA MINERAL WATER(1000ML) 2:02:35 PM15011.88061.88BEVERAGE 4/1/10G0470133CAPPUCCINO 2:21:32 PM26028.50148.5BEVERAGE 4/1/10G0470139QUA MINERAL WATER(1000ML) 2:53:24 PM15011.88061.88BEVERAGE 4/1/10G0470140MIAMI MELONS 2:54:32 PM18520.190105.19BEVERAGE 4/1/10G0470141CAFFE LATTE 3:08:58 PM17016.63086.63BEVERAGE 4/1/10G0470141CAPPUCCINO 3:08:58 PM26028.50148.5BEVERAGE 4/1/10G0470142COUNTRY LEMONADE 3:09:07 PM18520.190105.19BEVERAGE 4/1/10G0470145COUNTRY LEMONADE 3:39:18 PM18520.190105.19BEVERAGE 4/1/10G0470146RED BULL ENERGY DRINK 3:48:25 PM112529.690154.69BEVERAGE 4/1/10G0470148BRAZIL BOURBONSANTOS (REG) 4:06:01 PM19522.560117.56BEVERAGE 4/1/10G0470149DOPPIO 4:07:55 PM16014.25074.25BEVERAGE 4/1/10G0470153CAFFE LATTE 4:15:45 PM17016.63086.63BEVERAGE 4/1/10G0470154PINK LEMONADE 4:15:50 PM18520.190105.19BEVERAGE 4/1/10G0470156CAPPUCCINO 4:16:40 PM16014.25074.25BEVERAGE 4/1/10G0470157LEMON ICED TEA 4:25:25 PM18520.190105.19BEVERAGE 4/1/10G0470157MIAMI MELONS 4:25:25 PM18520.190105.19BEVERAGE 4/1/10G0470157RED BULL ENERGY DRINK 4:25:25 PM112529.690154.69BEVERAGE 4/1/10G0470159CAPPUCCINO 4:45:12 PM16014.25074.25BEVERAGE 4/1/10G0470161CAPPUCCINO 4:46:08 PM16014.25074.25BEVERAGE 4/1/10G0470162CAFFE LATTE 4:50:57 PM17016.63086.63BEVERAGE 4/1/10G0470163CAFFE LATTE 4:51:48 PM17016.63086.63BEVERAGE 4/1/10G0470166QUA MINERAL WATER(1000ML) 4:58:33 PM15011.88061.88BEVERAGE 4/1/10G0470166CAFFE LATTE 4:58:33 PM17016.63086.63BEVERAGE 4/1/10G0470167BLACK CURRANT ICED TEA 4:59:11 PM18520.190105.19BEVERAGE 4/1/10G0470167CURRANT COOLER 4:59:11 PM19522.560117.56BEVERAGE 4/1/10G0470170MASALA CHAI CUTTING 5:10:45 PM1409.5049.5BEVERAGE 4/1/10G0470170CHAI LATTE 5:10:45 PM17517.81092.81BEVERAGE 4/1/10G0470172MASALA CHAI CUTTING 5:16:18 PM1409.5049.5BEVERAGE 4/1/10G0470173LEMON ICED TEA 5:22:20 PM28540.380210.38BEVERAGE 4/1/10G0470176CAPPUCCINO 5:33:33 PM16014.25074.25BEVERAGE 4/1/10G0470179BLACK CURRANT ICED TEA 5:43:59 PM18520.190105.19BEVERAGE 4/1/10G0470185MOROCCAN MINT TEA 6:04:09 PM14510.69055.69BEVERAGE 4/1/10G0470187GREAT LAKES CREAM 6:05:34 PM114534.440179.44BEVERAGE 4/1/10G0470188MOROCCAN MINT TEA 6:09:04 PM24521.380111.38BEVERAGE 4/1/10G0470189ULTIMATE HOT CHOCOLATE 6:12:21 PM19522.560117.56BEVERAGE 4/1/10G0470193ORANGINA (250ML) 6:35:01 PM15011.88061.88BEVERAGE 4/1/10G0470193CURRANT COOLER 6:35:01 PM19522.560117.56BEVERAGE 4/1/10G0470195QUA MINERAL WATER(1000ML) 6:57:51 PM15011.88061.88BEVERAGE 4/1/10G0470197MOROCCAN MINT TEA 6:58:53 PM14510.69055.69BEVERAGE 4/1/10G0470197EARL GREY 6:58:53 PM15513.06068.06BEVERAGE 4/1/10G0470198COOKIE CRUMBLE 7:00:53 PM111026.130136.13BEVERAGE 4/1/10G0470199RED BULL ENERGY DRINK 7:03:07 PM112529.690154.69BEVERAGE 4/1/10G0470205MASALA CHAI CUTTING 7:29:12 PM1409.5049.5BEVERAGE 4/1/10G0470205QUA MINERAL WATER(1000ML) 7:29:12 PM15011.88061.88BEVERAGE 4/1/10G0470205CAPPUCCINO 7:29:12 PM16014.25074.25BEVERAGE 4/1/10G0470207MASALA CHAI CUTTING 7:33:24 PM1409.5049.5BEVERAGE 4/1/10G0470207QUA MINERAL WATER(1000ML) 7:33:24 PM15011.88061.88BEVERAGE 4/1/10G0470208QUA MINERAL WATER(1000ML) 7:34:52 PM15011.88061.88BEVERAGE 4/1/10G0470208CAPPUCCINO 7:34:52 PM26028.50148.5BEVERAGE 4/1/10G0470210STRAWBERRY ICED TEA 7:40:00 PM18520.190105.19BEVERAGE 4/1/10G0470212BERRY BLAST 7:45:54 PM19522.560117.56BEVERAGE 4/1/10G0470213MOROCCAN MINT TEA 7:53:34 PM14510.69055.69BEVERAGE 4/1/10G0470214MASALA CHAI CUTTING 8:06:10 PM1409.5049.5BEVERAGE 4/1/10G0470215CAPPUCCINO 8:06:59 PM16014.25074.25BEVERAGE 4/1/10G0470217ULTIMATE HOT CHOCOLATE 8:09:52 PM19522.560117.56BEVERAGE 4/1/10G0470219MASALA CHAI CUTTING 8:12:41 PM1409.5049.5BEVERAGE 4/1/10G0470220MIAMI MELONS 8:16:03 PM18520.190105.19BEVERAGE 4/1/10G0470221RED BULL ENERGY DRINK 8:21:33 PM112529.690154.69BEVERAGE 4/1/10G0470222RED BULL ENERGY DRINK 8:32:22 PM112529.690154.69BEVERAGE 4/1/10G0470224LEMON ICED TEA 8:37:49 PM18520.190105.19BEVERAGE 4/1/10G0470226LEMON ICED TEA 8:40:45 PM18520.190105.19BEVERAGE 4/1/10G0470227CAPPUCCINO 8:45:59 PM16014.25074.25BEVERAGE 4/1/10G0470228CAPPUCCINO 8:48:28 PM16014.25074.25BEVERAGE 4/1/10G0470228CAFFE LATTE 8:48:28 PM17016.63086.63BEVERAGE 4/1/10G0470229CAPPUCCINO 8:50:42 PM16014.25074.25BEVERAGE 4/1/10G0470231COOL CALIFORNICA 9:05:48 PM18520.190105.19BEVERAGE 4/1/10G0470234LEMON ICED TEA 9:19:48 PM18520.190105.19BEVERAGE 4/1/10G0470235LEMON ICED TEA 9:26:24 PM18520.190105.19BEVERAGE 4/1/10G0470238COOL CALIFORNICA 9:35:52 PM18520.190105.19BEVERAGE 4/1/10G0470239QUA MINERAL WATER(1000ML) 9:39:01 PM15011.88061.88BEVERAGE 4/1/10G0470239ORANGINA (250ML) 9:39:01 PM15011.88061.88BEVERAGE 4/1/10G0470240PINK LEMONADE 9:39:08 PM18520.190105.19BEVERAGE 4/1/10G0470243QUA MINERAL WATER(1000ML) 10:04:50 PM15011.88061.88BEVERAGE 4/1/10G0470243CAPPUCCINO 10:04:50 PM26028.50148.5BEVERAGE 4/1/10G0470244CURRANT COOLER 10:05:42 PM19522.560117.56BEVERAGE 4/1/10G0470246ULTIMATE HOT CHOCOLATE 10:13:14 PM19522.560117.56BEVERAGE 4/1/10G0470250CAPPUCCINO 10:33:18 PM16014.25074.25BEVERAGE 4/1/10G0470251CAPPUCCINO 10:33:40 PM16014.25074.25BEVERAGE 4/1/10G0470251MIAMI MELONS 10:33:40 PM18520.190105.19BEVERAGE 4/1/10G0470253LEMON ICED TEA 10:34:55 PM18520.190105.19BEVERAGE 4/1/10G0470256MOROCCAN MINT TEA 10:52:32 PM14510.69055.69BEVERAGE 4/1/10G0470260LEMON