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.