Dashboard Week Day 5: Iowa Liquor Sales Dashboard

July 9, 2021

This post was originally published on The Data School blog between 2018 and July 2025, before our program was renamed to MIP’s Analytics Career Accelerator. References throughout this article to “The Data School” or “DS” all refer to what is now MIP’s Analytics Career Accelerator. The program, its people, and its commitment to launching outstanding analytics careers remain the same – just under a new name.

If you are having trouble viewing this article, please report it here.

Iowa Liquor Sales Dashboard

The Dataset

For the last day of our Dashboard Week, we are given the Iowa liquor sales dataset. There’s nothing fancy about the dataset. The trouble is, we only have around six hours to create a dashboard about it and present together with our dashboard from yesterday. Here is my approach on how I created my Iowa Liquor Sales Dashboard.

Alteryx Workflow

Since there is very limited time, I have to spend little time on Alteryx. Instead of thinking about the efficient usage of tools, I just did whatever will work immediately. Look at this monster:

Iowa Liquor Sales - Alteryx Workflow

Charts Used in Tableau

Again, due to time constraint, I have to stick with charts I am comfortable to create easily: bar, line and map. The only special about my dashboard is that the labels are dynamic based on the measure selected.

The Final Product:

Here’s a preview on my dashboard and you can always view it in Tableau Public:

Iowa Liquor Sales - Preview