Analysis

HOME

PROJECT OVERVIEW

PROJECT MANAGEMENT

ANALYSIS

FINAL DELIVERABLE

Introduction

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.

What are some common desired attributes that customers are talking about?

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:

Bakeries

Bars

BreakfastAndBrunch

CoffeeAndTea

Desserts

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 favourite flavour of its customers so they will come back again
3. Desserts restaurants to employ friendly stuff to provide friendly service

Besides examining the positive bigram word clouds, one can also examine the positive sentiment word types such as word, adjective and noun word clouds. Wordcloud is good as it tells people what are top words by its size. The larger the size, the more frequent the word appears in the Yelp Review. At the same time, the colour of the wordcloud can be used to indicate the different groups of words. In our case, we decided to use the colour green to indicate positive sentiment word and the colour red to indicate negative sentiment word.

Due to word cloud limitation of comparing relative frequency between words , we decided to include barchats to help us visualise the frequency of the wordcloud. Let us take a look at how the barcharts can help to answer the desired attributes of the bakeries that are located in the NV state in the US.

NV:

NV Bakery

NV Bars

NV Breakfast

NV Coffee

NV Desserts

PA:

PA

From the above picture, we can see that the top 5 positive sentiment adjectives that are associated with the chosen business categories in both NV and PA are quite similar.

From the above picture, we can see that top 5 positive sentiment adjectives that are associated with Bakeries with business ratings >= 4.5 stars are good, great, delicious, sweet and fresh. As such, it is quite important for the bakeries to sell delicious, sweet and fresh bread and cake to attract the customers. At the same time, good and great service are also important to the customers.

Why are some of the businesses thriving and others are not? What are the best practices?