Analysis
| HOME | PROJECT OVERVIEW | PROJECT MANAGEMENT | ANALYSIS | FINAL DELIVERABLE |
For this project, our group would be focusing on the text and sentiment analysis of the Yelp reviews. We would be analysing the Yelp reviews for the Bars, BreakfastAndBrunch, CoffeeAndTea, Desserts and Bakeries that are located in the US states. We have chosen this 5 restaurant categories as they provide the Yelp users with a relatively comprehensive list of food selection. In addition, We have chosen the US states as Yelp has a lot of active users there.
After some discussion and consultation, we have came up with several questions as stated below. We felt that these questions would be useful to the restaurants located in the US. Now, lets examine these questions more closely with the Tableau Dashboard that we have built for this project.
The common desired attributes can vary across the 5 main restaurant categories that we have chosen previously. For example, the people who visit the bars value the attribute: happy hour. This is understandable because the people go to the bar primarily to drink and they can get their beer at a relatively lower price. As such, they are able to enjoy their friends' companion while at the same time enjoy cheap beer. On the other hand, when people go to visit the restaurants to consume breakfast or brunch, they value the attribute: good food such as fried chicken etc. This is because they are hungry and need to fill their stomach.
By generating the bigrams (adjective + nouns) in the form of word cloud across the different business categories in the US, our group is better able to understand the desired attributes that the customers value.Below are the positive sentiment word clouds for the different business categories across all 6 US states namely AZ, IL, NC, NV, PA and WI:
From the positive sentiment bigram word clouds, we can infer that it is important for
Bakeries: 1) Bakeries to provide delicious fresh and great bread i.e. French bakery 2) Bakeries to employ friendly stuff to provide friendly and great service
Bars: 1) Bars to have happy hours so that the cheap beers can attract more people to drink beers there. 2) Bars to have a great atmosphere / place by having good music, good beer, good selection and excellent service
Breakfast And Brunch: 1) Breakfast and Brunch restaurants to employ friendly stuff to provide friendly and great service 2) Breakfast and Brunch restaurants to provide great and amazing food i.e. coffee and French toast
Coffee And Tea 1) Coffee And Tea restaurants to provide great, delicious and iced coffee 2) Coffee And Tea restaurants employ stuff to provide friendly service
Desserts 1) Desserts restaurants to provide great food such as hot chocolate, delicious ice and great yoghurt etc. 2) Desserts restaurants to know the favorite flavor of its customers so they will come back again 3) Desserts restaurants to employ friendly stuff to provide friendly service
