The goal of this project was to answer business questions on the potential expansion of a fictitious craft brewing company—Campfire Dance Brewing. To do this, I conducted market research and data analysis that I turned into a report for C-Suite decision makers.
Cumulative Tax Revenue Growth for All States
Year-over-Year Tax Revenue Growth for All States
Tax Revenue by State from 2007-2015
Highest ranked states by Year-over-Year Tax Revenue Growth 2007-2015
Highest ranked states by Year-over-Year Tax Revenue Growth 2015-2018
Top States by Drinking Age Population
Top States by Number of Craft Breweries
Figure 8: An interactive map showing craft brewery locations
The number of reviews a beer style receives does not correlate to a top-rated beer. American IPA, the most reviewed style, doesn’t make the top-20 best rated beer styles.
Highest Rated Beer Styles
Top Beers by Number of Reviews on Beeradvocate.com
Correlation Between Beer Rating and ABV
ABV of Top Rated Beer Styles
ABV of Bottom Rated Beer Styles
Based on EDA and data visualization, I can recommend that now is a good time for expansion if year-over-year growth, market demographics, and market saturation are taken into account. One of the best states for expansion, based on my analysis, is Texas.
Regarding beer styles, diversifying with some of the higher-rated beer styles on a rotational basis might keep customers coming back for more. A focus on slightly higher than average ABV stouts and Belgians is ideal.