Pokemon Summary Statistics Tableau Dashboard - danieljamesdavis/Portfolio GitHub Wiki

Making a Tableau Dashboard in pretty colors with Pokemon data from an unknown source. (Thank you, whoever you are.) This data includes all Pokemon from the Red/Blue games through the X/Y games, so Bulbasaur through Zygarde.

Please see the accompanying .ipynb file in this Repo if you are interested in learning more about the cleaning I did on this data. Please forgive the appearance of the "Ã" or "Â" characters, this is a bug from hosting Jupyter Notebooks inside Git I haven't solved yet.

Project files in this Repo:

  1. The dashboard itself hosted on Tableau Public - Link!
  2. PokemonTableau.ipynb - Summary of data cleaning - Link!
  3. pokemon_clean.xlsx - Cleaned data - Link!
  4. pokemon.xlsx - Original data - Link!

To Do List

-Make user filtering possible by creating a custom filter option for the viewer on the dashboard, for example being able to filter based by games/generation, perhaps storing an array of games they occur in in a single field to demonstrate field nesting

-Make clicking a tooltip of a certain type trigger a filtering on a table of all the pokemon.

-Counting the number of evolutions per type

-How many evolutions change the pokemons type? (Is there a new Type1 ever, or does it only ever just add/remove a Type2?)

-Create parameters that allow the user to only show certain types of data in the views. Examples are being able to select types, pokemon from a certain game (would require a calculated field assigning the game each section of the pokedex comes from - red/blue, gold/silver, ruby/sapphire, etc.), first/second/third evolutions (would require a calculated field that checks if the pokemon is an evolved or base evolution)

-Come up with some ideas for tooltip vizzes and add them accordingly to certain views

-Break out the views into seperate sheets so that there is less clutter

Completed To Do's

-Counting the number of pokemon total by type - DONE

-Average stats of each pokemon by type - DONE

-Average attack power of pokemon moves per type - DONE

-Instead of having 2 entries for a pokemon, make a Type1 and Type2 column, with Type2 able to have a null value - DONE