Dashboard Week: Day 1

For Dashboard week day 1, we are working with the National Survey Of College Graduates dataset. For the first part of the day, we received the data at 8:45, and at 9:00 AM, I began data exploration. There are several tables, in different categories, for the most part, time was spent trying to see which angle I was going to take. And trying to have a good understanding of the data.

At the beginning of the day, I picked three tables I would utilize for the dashboard after looking at the different tables. I was planning on cleaning the tables on Alteryx. After I brought the tables into Alteryx, I noticed how different the tables were from each other and the level hierarchy that was present amongst the tables. I spent a good amount of time cleaning one table, and then I noticed I wasn't going to be able to do all three tables I originally planned. Therefore I focused on two only.

After I finished the first table, I worked on the second table; thankfully, it has a similar structure as the previous one in terms of the step taken to clean it. This time around it was faster to clean.


After I fished the Alteryx workflow, I spent a good amount of time testing and making sure the numbers were correct. And the values outputted made sense. When checking the values individually, I obtained the values shown in the original table.

After I had the data, I began sketching what I wanted my dashboard to be, which is shown below.


I wanted to compare genders, with the gender provided in the data tables, which were female and male. I would’ve liked to do an overview dashboard and see what insights I could obtain from it.

Due to time constraints and some data problems, I couldn't create the dashboard I was planning on doing. I had to make a few changes, and the end result is this:

Author:
Jose De La Rosa
Powered by The Information Lab
1st Floor, 25 Watling Street, London, EC4M 9BR
Subscribe
to our Newsletter
Get the lastest news about The Data School and application tips
Subscribe now
© 2025 The Information Lab