discoverbrewery / where is ISS?
Web • Responsive • Loads live data from API • HTML/CSS • JavaScript • Python • Data Analytics and Visualizations
Project Overview
The goal of the project was to design and code a responsive website that loads live data from an open-source public API. I chose to work with two APIs: one for brewery locations across the U.S. and another for the current location of the International Space Station. I also worked on a data analysis project to create strategies for expanding the brewery business in the U.S.
​
​
My Contributions
Everything you see has been designed and developed by me. I used Figma to create the basic structure of the webpages, coded them using HTML and CSS, and utilized JavaScript to host the open-source public APIs.
I used Python for the data visualizations and created them in a Kaggle notebook.
​
Click here for the Github repository.
Defining the flow and
Initial Design
I defined the structure of the webpage on Figma. I used the same for both the webpages.
Random Brewery Generator
Initially, I started with a design that allowed users to search for random breweries across the country, including the type of brewery, its address, and a Google Maps location. I implemented a linear background gradient from white to yellow to depict different shades of beer.
There was no initial plan to work with the "Where the ISS at?" API.
What went wrong?
Unsuccessful in finding/creating a GeoJSON file
I was unable to highlight individual states with colors and borders because I couldn't find a GeoJSON file containing the boundaries of each state in the U.S. Additionally, my attempts to create one were unsuccessful.
Background Animation
Due to difficulties, I couldn't fully achieve a full-page beer glass background animation. As an alternative, I decided to implement bubbles using CSS animation, which proved to be a simpler option.
Links
Data Visualizations (View Kaggle Notebook for code and detailed analysis)
Business Objective
Develop a data-driven market expansion strategy for a beverage distribution company operating in the United States by analyzing the distribution and types of breweries to identify optimal regions for growth.
​
Analytical Questions
-
Regional Brewery Landscape: What patterns can be identified in the distribution of breweries based on their addresses or types? Are there cities/states/regions where specific types of breweries are more prevalent?
-
Brewery Type Distribution: How many breweries of each type exist in each state?
-
Urban-Rural Analysis: What are the characteristics (such as the presence of websites, population of cities), of urban regions with the highest concentration of breweries? Can we identify any urban cities for market expansion within the brewery industry?
-
Cities with Unique Characteristics: Are there any cities in rural areas that are low in population, have few breweries, but are also famous tourist spots/growing cities? Can these be identified for market expansion?
-
Population Correlation: Finally, is there a direct relationship between the population size of states and the concentration of breweries? How does this correlation differ between urban and rural areas?
Code Snippets
Data exploring and cleaning / Importing necessary libraries
Brewpub is the most popular type of brewery in the U.S. There are 1320 brewpubs in the country. A MultitapBar is the least common.
In the bar chart above, I set a population threshold of 275,000 people to define urban cities. Any city below this threshold is considered rural. The plot highlights major populous cities, often popular among tourists, making it easier to identify urban areas with fewer breweries. This analysis helps pinpoint opportunities for business expansion strategies.
For example, while California cities are saturated with breweries, cities like Omaha, Lincoln, Honolulu, Lexington, Louisville, Tulsa, Nashville, Memphis, Washington DC, Virginia Beach, Phoenix, and Tucson have fewer than 50 breweries each.
Checking for total number of breweries for each type in the country, to explore the spatial distribution of breweries and identify patterns related to brewery types and geographical regions.
California has the highest number of breweries, signaling a thriving craft brewing scene. Colorado and Oregon follow suit, while other states show lower counts, indicating potential opportunities for the beverage distribution company to expand and cater to the demand for locally brewed beer.
How different types of breweries are distributed across various states.
​
Region Wise Distribution - Most Breweries: The West Coast, particularly states like California, Oregon, and Washington, has a high concentration of breweries. States in the South West Central region, such as Oklahoma and Arkansas, also have a significant number of breweries.
​
Region Wise Distribution - Fewer Breweries: The Midwest, including states like Wisconsin, Michigan, and Minnesota have fewer breweries due to various factors, including population density, regulations, market demand, and/or cultural preferences.
​
Possible region for expansion growth (based on the scatter plot): The Mountain West region, the states like Colorado, and states in the Southeast Region, could be a good area for expansion, because of the diverse market having both urban and rural areas and a steady stream of tourists. It doesn't have all types of breweries yet, and there could be room for possibilities.
Explore potential brewery market expansion in cities like Frederick, Maryland, known for its historic charm; Conway, Arkansas, a growing hub with a focus on education; and McLean, Virginia, an upscale suburb near Washington, D.C., offering a mix of affluence and strategic location. These cities, each with unique attractions, present opportunities for tapping into a diverse and emerging market.
In this scatter plot, each point represents a state, and its position is determined by its population size (in 10,00,000) and the number of breweries. The hue distinguishes between urban and rural areas. The visualization identifies the correlations between population size and brewery distribution, considering the urban-rural classification.
Although the above bar plots gave individual city wise corelations, this scatter plot proves that higher the population, higher number of breweries. This is a potential factor influencing the distribution of breweries in different regions.
Conclusion
In conclusion, the analysis of brewery data has highlighed strategic opportunities for market expansion, both at the city and regional levels:
-
The West Coast, particularly California, dominates the brewery landscape, while the Southeast Region emerges as an untapped market with promising potential.
-
Urban areas with populations below 275,000, such as Omaha and Nashville, present opportunities for targeted expansion due to their lower brewery counts. Cities with unique characteristics, including Frederick and Fargo, offer avenues for niche market engagement.
-
The positive correlation between population size and brewery count, as highlighted in the scatter plot, underscores the importance of demographic factors in brewery distribution.
​
Combining these insights, Nashville stands out as a promising city-level expansion target, while the Southeast Region emerges as a strategic focus for broader market growth. This comprehensive analysis equips the beverage distribution company with actionable insights for informed and successful expansion strategies.
