What is Brewdog & Punk API?

BrewDog is a multinational brewery and pub chain based in Ellon, Scotland. With the production of over 800,000hl, BrewDog claims to be the “#1 Craft Brewer in Europe”. It was founded in 2007 by James Watt and Martin Dickie, who together own 46% of the company. The Punk API takes Brewdog’s DIY Dog and turns it into a searchable, filterable API that’s completely free and open source. In this blog, I’ll show my process of creating a dashboard based on the Punk API data.


Alteryx Workflow

Firstly, collect the data from Punk API.

To be convenient for the visualization, I split the data into several tables.

Figure 1. API Scraping


Dashboard Creation

a) Title & Introduction

Figure 2. Intro of the dashboard


b) Show key metrics

Figure 3. The overview of the data


c) Show ABV Strength Category & Beers First Brewed Year

Figure 4. Category & Trend


d) List the top 10 strongest, bitterest, darkest alcohol

Figure 5. Top 10 Alcohol by different standards


d) List the top 10 popular yeast, malt, hops

Figure 6. Top 10 popular ingredients


e) Compare the relationship between ABV and IBU

In 2014, there was a moderately strong relationship between IBU and ABV. The higher the ABV, the bitter the alcohol.

Figure 7. ABV vs IBU

e) Arrange the Layout and Finalise the Dashboard

It’s a data exploration dashboard. You can click one of the charts to filter the others.

You can click here to interact with the dashboard functionality.

Figure 8. Final Dashboard


If there are any problems, please feel free to point them out. Besides, you can reach out to me on LinkedIn. I will try my best to answer your questions about Tableau or Alteryx.


Joe Chan
Author: Joe Chan

Joe has an IT background with a master's degree in UNSW, majoring in AI and Data Science. During his studies, he realized Data is one of the most valuable assets a business can have and potentially has a tremendous impact on its long-term success. After graduation, his desire to level up his data analytics skills led him to join The Data School. He is interested in Data Wrangling, Data Visualization, and Machine Learning, eager to be a great Data Analyst to help businesses grow.