Scenario

You have been asked to provide recommendations to help a local restaurant increase sales and customer satisfaction. You are also responsible to create some dashboards that make it easy to understand what our survey and sales data may help us to learn. As always, you are expected to follow the Standards of Professionalism e, including the use of spellcheck.

The restaurant administered a survey to current and potential customers to discover key information, including preferences, shopping patterns, and demographics (such as age and gender). You also have access to historic sales by server by weekday.

The first sheet of the project workbook contains a placeholder for the questions asked in the survey and the second sheet shows the question text (on row 1) on and the results from all respondents. The results in the spreadsheet are in a partially organized format because that is how the data came from the online survey program when exported into Excel. You will need to explore the data to determine how it can be useful. You are welcome to rearrange and reformat the sheet.

The company believes that the data may be useful, but they do not know how to manipulate or summarize the data. This is where they need your help. They have hired you to help them organize and summarize the data so that it is meaningful, easy to interpret, and useful for their marketing decisions.

Requirements

Survey questions

Before creating pivot tables, take some time to get familiar with the data by copying the questions from the Survey Results sheet to the Survey Questions sheet. This will allow you to get a feel for the survey structure before trying to work with the data.

Survey dashboards (one sheet per survey question)

Use the data from the Survey Results sheet. Create a pivot table and pivot chart for your choice of five survey questions (excluding the age and gender questions). Every table and chart needs to be connected to a slicer for gender and another slicer for age (meaning there will be two slicers on each of the five new sheets). Label each sheet so the user can quickly determine which question it corresponds to.

Depending on the type of data provided in the responses (text or numeric) you will need to set up the pivot table differently.

Server performance dashboard

Use the data from the Servers Info sheet. The management team wants a dashboard showing the performance of the servers by weekday.

• Create two input drop-down lists: "Server" and "Day of the Week". Each drop-down list must show a unique list of choices.

• Add output cells that use formulas to show (with the appropriate number format) the following information for the selected server and selected day of the week:

o Total number of tables served – a count of the number of times the selected server's name appears for the selected day

o Total sales – a sum of the cost of the meals for the selected server and selected day

o Average sales – an average of the cost of the meals for the selected server and selected day

Recommendation sheet

Microsoft Word On the Recommendations sheet please provide what you feel are the five most important recommendations to the restaurant management team to help them increase sales and customer

Data