Customer feedback and overall rating was taken for a popular restaurant. The .csv file contains a subset of data for one restaurant including text of a customer review and a “star” rating out of 5 (5 being the most positive rating): Data.csv Source: https://www.yelp.com/
You have been hired as a consultant to review the feedback and suggest an improvement to the restaurant Manager that would improve their customer satisfaction rating. Perform qualitative analysis to make a recommendation for the Manager.
Complete the following:
1. Import the file into Excel. Save the file as a MS Excel workbook with the name.
Following the 5 step process for Qualitative Data Analysis, complete the following:
2. Perform any required data cleaning within the worksheet.
3. Review the data.
4. Add a column named “Codes”.
5. Code the data and add the codes within this new column.
6. Add a new Worksheet named “Themes”.
7. Identify patterns in the data and create a list of themes on this new worksheet.
8. Add a description of the themes that you have identified on this worksheet.
9. Add a column in the original data worksheet named “Themes”.
10. List themes specific to the data in this new column.
11. Use at least one chart to visualize the patterns within the data.
12. Put your chart(s) on the “Themes” worksheet.
13. Add a Worksheet in the file named “Conclusions”.
14. Make a recommendation for an improvement at the restaurant based on the data. Write your recommendation on this new sheet.
15. In your conclusions, provide a justification for making this recommendation based on the data. Write your justification on the “Conclusions” sheet.
