We wanted to generate a segmentation based on external data and came up with a scoring system for bars. The system creates a bar rating based on average Beer Advocate rating of the beers served at the bar (by volume).

What it does

Bars are ranked based on their Beer Advocate-based score. We display the beers they serve and compare to a list of the top 10 beers served by bars in a similar rating range. Sales reps can use this data to recommend beers based on sales across the category.

How we built it

Pre-processed the data with SQL server and validated our hypothesis. We deployed an API. We created a desktop and a web version using our data analysis.

Challenges we ran into

The data wasn't clean. The external identifier wasn't in the draft table so we had to merge multiple tables. The large data set introduced problems with AWS. The beer data included third party beers which did not have ratings in Beer Advocate.

Accomplishments that we're proud of

We got a few versions of a working product up in 2 days.

Share this project: