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?? r
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.
| text | stars |
| All I've got to say is this: order the pork tenderloin. It is perfect. Tender. Flavorful. Creative. And if you want something to wash it down with, the margaritas are tasty. | 4 |
| Apitizer was great (tiger prawns with a corn tamale) Dinner was ok (rabbit) a little to much heat for my taste. Service was good though and i must say as a whole i really liked this place. | 4 |
| Appetizers were ok…….I expected more….it wasn't bad but it defiantly wasn't worth the price. We decided to cancel our main courses and try somewhere else. Really disappointed. | 3 |
| Awesome… Definitly one of our mainstays when we are in Vegas…consistent…Knocked a star off because the menu needs updating. Our favs are the pork tenderloin and the yucatan tacos. Delicious. | 4 |
| Bartender was great as where the margaritas! Had a few appetizers, we really liked the smoked chicken quesadilla. Busy spot so make reservations or hope for a spot at the bar. | 4 |
| Been looking forward to this experience for a while. The serves was next level and the food spot on. The environment was a little odd with views of the casino but we loved the experience. | 4 |
| Bobby, I love your books and tv stuff, but have you ever even been in this restaurant? I've been twice and maybe I expect too much but all I can say is, "meh. | 3 |
| Cold fries. Nothing was spectacular, but the bread was the highlight. Goat cheese/jalapeño was greasy. We only had brunch, perhaps dinner would be better. | 3 |
| Delicious appetizers and entrees! Cocktails were also amazing. Desert was just so-so. The shrimp and lobster menu items were fantastic. I had the pork tenderloin and it was divine!! | 4 |
| delicious food from Bobby Flay – food items were perfectly prepared and seasoned well. Make a reservation, because the place gets packed, but if you cannot make it, they will charge you a fee. | 4 |
| Dinner here was just ok….service was outstanding, appetizer was delicious (Quesadillas) However for the main course I had the 22 0z steak, wasn't impressed it was boring. | 3 |
| Expensive, even by Vegas standards. Everything is a la carte and they were out of a few entrees fairly early in the evening. Food was good but I have places in Vegas that I like better. | 3 |
| expensive, you betcha! But a solid place nonetheless. Beer selection is random (don't expect bud or coor's here!) and not worth the 8 bucks per. But overall you cant go away upset with the grub. | 4 |
| First time at one of Bobby Flays restaurants. He is know to cook southwestern food. Mesa did not disappoint. His Take on the Chile Relleno was incredible. Will definitely come back for round two. | 4 |
| Food was good here, nothing that blew me away mind you. The service was very lacking. Our waiter was none existent. The iced tea came served with simple syrup, a nice touch. | 3 |
| Food was good. Service was so snooty it became absolutely rude and obnoxious. Service was so bad I probably won't return. Can't blame the cooks. It was all on the terrible wait staff. | 1 |
| Food was incredible!!! Salmon was cooked to perfection. The service was a bit slow, due to it being New Years weekend. Highly recommend the chocolate cajeta cake for dessert!! | 4 |
| Good food but so expensive comparing For the food they serve, the service is great the margaritas need to be better although they said it was made from scratch but didn't buy that | 3 |
| Good service and nice decor. Ribeye steak was great but the lobster tacos appetizer was disappointing and over priced. Three 2 inch tacos for $21.00! Stick to the beef at this restaurant. | 3 |
| Great Red wine- Curvee/ Geyser Merlot With Shrimp tamale, Nacho w/goat cheese, main (Lamb Chops) and vanilla toffee pudding. Look the ambience! Great for team outting while at Conf. in Vegas. | 4 |
| Great service. But very pricy. I think the price is reflected on the chefs popularity rather than the foods quality. I ordered the NY steak and asked for medium. But it was well done | 3 |
| I had a quick, solo lunch here. The service was fast, professional, and unobtrusive. I had the pork sandwich, which was excellently prepared. I can easily see myself going back. | 4 |
| I had the steamed halibut which was really good, but my friend had the 16 season chicken and it was so dry he couldn't eat it. Such a rookie mistake for a high end dining spot | 3 |
| I love Bobby Flay! But his food is disappointing. We had lunch there and got the chicken salad and sandwich. It's good, but not great. I expected more from the iron chef. Maybe dinner is better. | 3 |
| I only had brunch here and was disappointed with both my entre: chilaquiles and drink. However, the service was fantastic (Thanks Amanda!) and so were the appetizers. | 3 |
| I only ordered 2 small dishes so cannot comment on the entrees. The mashed potatoes and shrimp tamales had good flavor. Also service was attentive. I would come back to try other items. | 4 |
| I wasn't impressed. The food was good, but not outstanding, and definitely overpriced. I expect much more from a celebrity chef. Thanks, but I'll be dining at my locals spots instead. | 3 |
| I'm not gonna go crazy with this review. I had a cheeseburger and fries to go. It was good. It filled me up. It did its job. I didn't want to short change Mesa just because I didn't dine inside. | 3 |
| It was alright,honestly nothing earth shattering.Went on Valentines Day and felt very rushed.I dont think it was worth the $220.Meh..Sorry Bobby Flay,Emeril's Delmonico was far surpurb. | 2 |
| Just ok. Not impressed. Too many flavors that complicate each meal. And the grouper was not cooked properly. Thomas Keller and Mario Batali have this iron chef beat. | 3 |
| Lunch menu tanked and mediocre offering that does NOT scream "iron chef". Hated the fact that the smoke billowing from the casino killed my experience all together. | 2 |
| margaritas were pretty solid. food is pretty tasty. i didnt really like the fries though. service was excellent.. our waitress was sooo hot too. decor is awesome. overall: cuatro stars | 4 |
| Maybe my expectations were too high – but food was very disappointing. It was ok – nothing spectacular or noteworthy. Therefore it was definitely overpriced. Wait staff was great though. | 3 |
| Meh…. Expected a lot from Bobby Flays restaurant and it failed very short of my expectations. I have been to Chef Morimoto's in Napa Valley and the food was fabulous there | 3 |
| My girlfriend and I enjoyed a great meal when we went here. I ordered the 22oz steak and my girlfriend had the lamp. The food was cooked perfectly but expect to dish out alot of cash for your meal. | 4 |
| Not a 3 or 4 star. This place needs some real work and improvement from salads to steak menu if its claiming an Iron chef menu ! You will not get a Bobby Flay experience here just descent food. | 2 |
| Not impressed. We ate here before the Celine concert since it was close and will not go back. The margaritas were great, but you can keep the rest. Average to below average food at best. | 2 |
| Pretty good but not spectacular given the name behind the restaurant. Good place for a burger or tacos and some margaritas but don't expect to have your hair blown back. | 3 |
| Shared a few appetizers here with some friends and ordered some margaritas – everything was very tasty and the service was great. I'd like to try more items from the menu the next time I am in Vegas. | 4 |
| Started with excellent margaritas (no surprise there). Had rabbit that was outstanding and just the right spiciness level, and also had pork that was great but not a standout. | 4 |
| The food was pretty descent for the most part. My biggest issue was that they used really bony scrappy cuts of meat for the lamb tenderloin and thought it was ok. | 3 |
| The food was pretty good, overall very positive. Back home I found that the staff added more tip to the bill. (I had given $40, they added another $20) No way!!! | 1 |
| The margaritas were just okay. I was expecting better. The shrimp tamale was delicious as were the tacos. The dinner menu was limited so we chose to order a few appetizers instead. Ambience was good. | 3 |
| They put chocolate with spinach and salmon. Yes. I typed that correct. CHOCOLATE, with spinach and salmon…enough said. The service was mediocre. Which is why it gets 2 instead of just 1 | 2 |
| This restaurant is delicious!!! Best steak i ever had. The 16 herb crusted chicken was fantastic too. So many flavors. An unexpected surprise. Make sure to make a reservation! | 4 |
| Ummm…this place is good… I had the flounder (the whole fish)…it was very good… Their drink selection is abundant… I thought the prices were a bit high, but otherwise tantalizing… | 4 |
| Very disappointed in this place! They could not even make a good margarita! It was way too sweet!! Couldn't wait to try Bobby's restaurant but the disappointment is real. | 2 |
| Very pricy steak but very tasty. Large portions so you can definitely share. All the dishes are full of flavor. Bobby does not disappoint! Staff was very professional but not super friendly. | 4 |
| We definitely will be back when in Vegas. My hubby ordered coffee rubbed steak and it was delicious! The toffee dessert was melt in your mouth yummy and the prices are really reasonable. | 4 |
| Went for brunch and got the blue corn buttermilk waffle with the spicy mango glazed bacon…yum! Great wait staff, nice mellow atmosphere and good food! | 3 |
,
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): Assignment 3 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 A3_Your userID (i.e. A3-azehr12345.xlsx).
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.
Collepals.com Plagiarism Free Papers
Are you looking for custom essay writing service or even dissertation writing services? Just request for our write my paper service, and we'll match you with the best essay writer in your subject! With an exceptional team of professional academic experts in a wide range of subjects, we can guarantee you an unrivaled quality of custom-written papers.
Get ZERO PLAGIARISM, HUMAN WRITTEN ESSAYS
Why Hire Collepals.com writers to do your paper?
Quality- We are experienced and have access to ample research materials.
We write plagiarism Free Content
Confidential- We never share or sell your personal information to third parties.
Support-Chat with us today! We are always waiting to answer all your questions.
