(0) Case Background, Objectives, and Motivation For as long as he can remember, Jean-Luc Fournier dreamed of owning his own bakery. After attending Le Cordon Bleu Paris, he worked hard in his hometown of Aix-en-Provence at his mentors bakery, Boulangerie Jacques. While celebrating in Marseilles for his promotion to head baker, he met an up-and-coming pastry chef, Emma, who was studying the art of French pastries. After a year, they wed and moved to Emmas hometown of New York City. Together they knew they could fulfill Jean-Lucs dream of opening his own bakery by bringing a little bit of France to New York Citys Upper West Side. With Jean-Lucs bakery experience and Emmas pastry experience, they opened Lucs Boulangerie & Patisserie in early 2020. After a difficult year, the bakery finally started doing well in early 2021. It continued to do well in 2022, and Jean-Luc decided to seek outside help to ensure the fledgling business would support them in their future endeavors. Jean-Luc has hired your firm to help him determine the direction he needs to take for optimal profitability. The boulangerie currently offers a wide range of daily-made breads, tarts, and pastries. The daily offerings vary some, and holiday-related baked goods are only available around the specific holidays. In addition to their baked goods, they serve both hot and cold sandwiches and drinks. Other than the cost of goods sold, Lucs has the following expenses: rent $70,000 per year (including electricity), payroll and benefits $100,000 per year, and general selling and administrative expenses $35,000 per year. Because fourth quarter numbers for 2022 are not yet available, you need to forecast revenues and cost of goods sold for the quarter. Assume that other expenses didnt change significantly from the previous year. Provide a comparative analysis of the two years, highlighting any trends you see. Make recommendations based on your analyses. Jean-Luc is thinking about changing his menu and possibly offering fewer items. He would like assistance determining which items are most profitable and if he should discontinue offering any. Jean-Luc also desperately needs a vacation but does not have another baker who can keep the shop open. To take his vacation, he would close Lucs Boulangerie & Patisserie for two weeks. Using analytics, provide the two weeks that would be best for his vacation. Finally, is there any other data you would like to have in order to provide more information for Jean-Luc? Why? Extra Credit (optional): Perform any other analysis you think would be useful to Jean-Luc. You do not have to include this in the presentation. At the end of the report include an Extra Credit section and discuss your findings from the additional analysis. Instructions Data Analysis: Use the data provided for your analysis. You will need to explore and gain an understanding of the data. You may use Excel to do this, but you must use Alteryx for data 1 preparation. All steps must be documented in Alteryx and in the required report. Tableau is to be used for the visualizations and any dashboards you create. You may also use a Tableau story as an alternative to a PowerPoint presentation. Report: You are required to document all the steps you take in the planning, analyzing, and reporting in a written report. You may use visualizations in your report. This document should be a formal report using proper grammar, capitalization, punctuation, and proper sentence and paragraph structure. You should have an introduction and a conclusion. You may use bullet points sparingly if appropriate, but each point must be explained. I do not want lists of bullet points. The report should also have a cover page and a table of contents. Presentation: You are required to submit an 8- to 10-minute presentation regarding the business question(s) at the root of your analysis, the findings, and your conclusion and/or recommendations for improvement. Please note that you should record yourself giving the presentation. You must be on camera for the entire presentation. If you have difficulties recording, then you must contact me for recommendations. Your presentation should include: a compelling opening to outline the problem and/or your solution (1 minutes or shorter). at least one (and no more than 3) recommendations based on your data analysis. at least three (and no more than 5) graphs and/or dashboards created in Tableau that directly support your conclusions or recommendations. This number does not include the Extra Credit graphs. a compelling conclusion that restates the significance of, and motivation behind, your recommendations or conclusions and accompanying analysis (1 minutes or shorter). You will need to prepare your presentation using one of the ways below: 1. The preferred option: A screen capture recording of you giving the presentation. One option is to create this using the free screen capture tool, ScreenPal (formerly ScreencastO-Matic) at https://screenpal.com or other screen capture recording software you may already have. 2. PowerPoint Slide Show with recorded narration option: Create a PowerPoint Slide Show and record narration from the Record Slide Show option in the Set Up section of the Slide Show Ribbon. For more information, refer to the Useful Resources section below. Submissions will be evaluated on: The quality of the opening and conclusion in the presentation The clarity of the graph(s) and visualizations The logic of the data story The feasibility and usefulness of the conclusions/recommendation(s) The presentation design and delivery The quality and completeness of the accompanying written report. Before you record your presentation, I suggest you perform the following steps: 1. Complete the Plan stage of the MOSAIC data analysis process. You may use Excel to understand your data. Everything else must be done in Alteryx and Tableau. 2 2. For the Analyze stage, conduct your data preparation using Alteryx. Perform your data analysis using Tableau. Make sure what you use is appropriate for your analysis. 3. Use Tableau visualizations for the Report stage. Be sure to use visualizations that best support your conclusion(s) and recommendation(s). You may use other tools such as Excel sparingly, but make sure it makes sense to do so. Using Excel because you do not know how to use a formula in Tableau is not a valid reason to not use Tableau. 4. Create an effective draft or outline for the presentation