My initial application to the data school was a dashboard that let you build your ideal Pokémon Team
https://public.tableau.com/app/profile/jacob.kilroy/viz/PokedexExplorerTeamBuilder/TeamOverview
It allows you to filter what Pokémon are shown to and select up to 6 Pokémon to add to your team to compare each Pokémon’s statistics, strengths, and weaknesses
This was my first ever ‘proper’ dashboard and I had great fun building it but I also had plenty of frustrating and tedious moments as I trial and errored my way to the final product.
One of the things that I spent a particularly long time on in Tableau was preparing or manipulating my data so that it could work as intended. Since one of the first things, we did in the data school was use Alteryx, I thought I’d try and redo my Pokémon dashboard from scratch, starting with Alteryx.
There were two main goals that I wanted to do with my data prep
1. Recreate the data that I produced in my original application but using Alteryx
2. Add in Pokémon move set data (in my eventual new dashboard I want users to see what moves a Pokémon can use)
I wish I had known about Alteryx earlier because I would have saved hours on my initial viz. As there are a lot of similar fields in the Pokémon data, I could process new fields with just a single multiple field tool meaning I could eliminate a lot of repetitive copy and pasting that I would have had to do in tableau. Also using Alteryx, I can now skip some of the LOD calculations that I initially had to use in tableau by using the summarize tool.
Adding in the Pokémon move set data was also straightforward but did involve quite a lot of cleaning to make sure that the data joined correctly with the original Pokémon data. In the end I ended using two different move set datasets and joined them to get a) which moves a Pokémon can learn and b) information for each move
Now that I’ve processed my data through Alteryx, I will at some point in the future be giving my original viz a ‘makeover’ to clean up the UI and add in the extra move set data