|
|
| (48 intermediate revisions by the same user not shown) |
| Line 18: |
Line 18: |
| | | style="padding:0.3em; font-size:100%; background-color:#FFFFFF; border-bottom:3px solid #35383c; text-align:center; color:#828282" width="11%" | [[Final Deliverable | <font face = "Trebuchet MS" color="#000000" size=2><b>FINAL DELIVERABLE</b></font>]] | | | style="padding:0.3em; font-size:100%; background-color:#FFFFFF; border-bottom:3px solid #35383c; text-align:center; color:#828282" width="11%" | [[Final Deliverable | <font face = "Trebuchet MS" color="#000000" size=2><b>FINAL DELIVERABLE</b></font>]] |
| | |} | | |} |
| − | | + | <!-------------------Menu bar for metrics------------------------> |
| − | <!--main content--> | + | {| style="background-color:#ffffff; margin: 3px auto 0 auto" width="50%" |
| − | <div style="background: #fee5d9; padding: 5px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #cb181d solid 32px; font-size: 16px"><font color="#cb181d">Introduction</font></div>
| + | |- |
| − | <div>
| + | ! style="text-align: center; background-color:#fee5d9; width: 50%"| [[Analysis - MidTerm Analysis| <font face = "Trebuchet MS" color="#cb181d" size=2><b>MidTerm Analysis</b></font>]] |
| − | 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.
| + | ! style="text-align: center; background-color:#fee5d9;width: 50%"| [[Analysis - Final Analysis| <font face = "Trebuchet MS" color="#cb181d" size=2><b>Final Analysis</b></font>]] |
| − | | + | |} |
| − | | + | [[Image:Analysis.jpg|400px|center]] |
| − | 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.
| |
| − | </div> | |
| − | | |
| − | <div>
| |
| − | <div style="background: #fee5d9; padding: 5px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #cb181d solid 32px; font-size: 16px"><font color="#cb181d">What are some common desired attributes that customers are talking about?</font></div>
| |
| − | | |
| − | <div> | |
| − | 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:
| |
| − | | |
| − | [[Image:Bakeries.png|400px|thumb|center|Bakeries]]
| |
| − | [[Image:Bars.png|400px|thumb|center|Bars]]
| |
| − | [[Image:Breakfast.png|400px|thumb|center|BreakfastAndBrunch]] | |
| − | [[Image:Coffee.png|400px|thumb|center|CoffeeAndTea]]
| |
| − | [[Image:Desserts.png|400px|thumb|center|Desserts]]
| |
| − | | |
| − | </div>
| |
| − | | |
| − | <div style="background: #fee5d9; padding: 5px; font-weight: bold; line-height: 1em; text-indent: 15px; border-left: #cb181d solid 32px; font-size: 16px"><font color="#cb181d">Why are some of the businesses thriving and others are not? What are the best practices?</font></div>
| |
