Case Study 1: Final Presentation

Jaclyn Coate & Huy Hoang Nguyen

2019-10-26

Budweiser an InBev Company

Budweiser

  • Microbrewery Analysis
  • Recommended beer releases for microbrewery market entry

Contributors

Huy Hoang Nguyen

  • Data Cruncher
  • Hype Crew

Jaclyn Coate

  • Architect
  • Visualization Lover

Brewery Geo Distribution

Breweries by State

Alcohol by Volume (ABV) Analysis

Median ABV by State

Highest ABV

Colorado at 12.8%

ABV Distribution & Summary

75% of the ABV falls between 5.5% - 5.8%

Higher than Budweiser’s 4.2%

Bitterness (IBU) Analysis

Median IBU by State

Highest IBU

Oregon at 138

IBU Distribution & Summary

75% of the IBU falls between 30 - 43

Higher than Budweiser’s 7

ABV & IBU Correlation

ABV vs IBU by Region

ABV vs IBU Summary

  • Positive correlation
  • No confirmed causation

Beer Styles by Region

Top 5 Beer Styles in the South

Top 5 Beer Styles in the Midwest

Top 5 Beer Styles in the West

Top 5 Beer Styles in the Northeast

Regional Style Summary

  • Very common trend among styles by region
  • Only 6 different beer style favorites between all 4 regions

Top 6 Beer Styles in the US

Top 6 Beer Styles in the US

ABV & IBU by Region

Average ABV by Region

Median IBU by Region

Data Review

Histogram & Pattern of Missing Data

Missing Data Pattern

##      Brew_ID Name_Brew City State Name_Beer Beer_ID Style Ounces ABV  IBU
## 1405       1         1    1     1         1       1     1      1   1    1
## 943        1         1    1     1         1       1     1      1   1    0
## 62         1         1    1     1         1       1     1      1   0    0
##            0         0    0     0         0       0     0      0  62 1005
##          
## 1405    0
## 943     1
## 62      2
##      1067

K Nearest Neighbors Model

  • 77% Confidence
  • 75% - 82% Confidence Interval

Final Recommendations & Summary

New Release Beer Charactersitics

Styles

  • IPA
  • Pale Ale
  • Amber
  • Blonde Ale
  • Double IPA
  • Pale Wheat Ale

ABV & IBU Ranges

  • ABV: 5.8 - 6.0%
  • IBU: 20 - 40

In Closing

  • Scarcity creates demand
  • Beers tailored by region
  • Competitive ranges of ABV and IBU

Thank You