Hello! Welcome to my dashboard week blogs. Today is the first project of all, we were given the task of building an Alteryx workflow to download data from the MealDB API, and use the downloaded data to create a dashboard. This is a fun project as all the meals look so good 😊.

Alright let’s get started. Free Meal API | TheMealDB.com

PART 1: ALTERYX: GETTING DATA FROM API AND PREPPING DATA

Below is the image of my finished workflow.

The documentation for this API is quite straightforward and easy to understand, however, there is no one endpoint that will allow me to get full details including area, category, ingredients of all meals at once.

To do this, I need to use a few endpoints to get all the data I want.

  • First, I saw that we could get full meal details by meal ID
  • Second, we could get the full list of all categories
  • Third, we could get all meals IDs for a selected category
Hence, my approach for this workflow is:
  • Download a full list of available categories from the API, using the Category List (endpoint number 2).
  • Append them to Category Filter URL (endpoint number 3) to download the full list of meals IDs for all categories.
  • Append all meals IDs to Look up full Meal details by ID (endpoint number 1) to download all details for all meal IDs available from the API.
  • Extract a hyper file for Tableau dashboard.

After successfully downloading the data using Download and JSON parse tools, I also had to perform data partitioning, data cleaning and transforming to get a neat data set for Tableau. This process involved using tools like Text to Columns, Regex, Select, Cross Tab, Transpose and Filter our irrelevant rows.

Note: in my workflow, I had a part where I joined Area and Category before step 2 workflow, I did this first and then realized after step 2 that it was not necessary as area details are also in full meal details, hence it wasn’t needed at all at that step. However, I still left it there as I need to timebox my project and wanted to finish with Alteryx so I could move on to Tableau.

PART 2: TABLEAU

After getting data from Alteryx workflow, I went on and explore the data a bit more in Tableau, tried some visualizations to learn the relationships between all the fields. After a while, I settled with a recipe dashboard rather than business dashboard this time. The data is quite straight forward so I spent time mostly organizing my ideas and dashboard layouts, focusing on user experience. During the process, I have learnt how to use multiple filters together in Tableau, organize them to work in a way that makes it easier for the users.

That was my dashboard week – day 1! Here is the link to my viz on Tableau public:
Mealdb Cookbook – Dashboard Week Day 1 | Tableau Public

Thanks for reading, I’ll see you in the next blog.

Thao

 

The Data School
Author: The Data School