The topic of dashboard for day 3 is beers and its ingredients.

The data was obtained through an API (link attached). For this dashboard, I used Alteryx and Tableau. Alteryx was used to scrap the data from the API and Tableau was used to create a dashboard.

-Alteryx

I created the following workflow to obtain the data. This workflow only worked for page 1 which only contained data for 25 beers.

Figure 1: Workflow to get initial testing data

 

With this workflow I created an iterative macro to obtain all 325 beers data. Following is the figure showing the tools used to create an interactive macro.

Figure 2: Iterative Macro

This following figure shows how the data was cleaned. I created three different tables and cleaned them separately. One table was created for beers, the other one for its ingredients and the last one for food pairing.

Figure 3: Three different tables and their cleaning

    -Tableau

Using the data tables extracted from Alteryx, I did an ingredient segregation analysis and correlation analysis. In ingredients segregation, the three different types of ingredients I.e., Malt, Hops and yeast were analyzed. I divided the ingredients into most common ingredients, not common nor unique and unique ingredients. This segregation of ingredients was drilled down to each ingredient with how many drinks used that particular ingredient.

Figure 4: Segregation of Ingredients 

The correlation analysis contains 3 scattered plots. One scattered plot, plots Ph level against IBU (bitterness level). Through this chart it was concluded that there is no correlation between these two measures.

Figure 5: Correlation between IBU and Ph

Second scattered plot, plots ABV (Alcohol by Volume) against IBU (bitterness level). Through this chart it was concluded that there is no correlation between these two measures.

Figure 6: Correlation between ABV and IBU

The final scattered plot, plots ABV (Alcohol by Volume) against SRM. It can be seen in the scattered plot that the more the alcohol level, the darker the color of the beer.

Figure 5: Correlation between ABV and SRM

 

If you want to look at this dashboard, click on this Link

Maliha Athar
Author: Maliha Athar