Overview
This project demonstrates the creation of an interactive Pokemon dashboard using Tableau for data visualisation and SQL for data analysis and exploration. The dashboard insights to various Pokemon attributes, such as its type(s) and stats, as well changes to Pokemon across the generations of the Pokemon games.
Final Result: https://public.tableau.com/app/profile/tinnon.luong/viz/Pokemon_Dashboard_17399959265980/Story1
What We Learn
Tableau Public: Learning the fundamental skills we need to build creative and interactive data visualisations
SQL: Demonstrating our knowledge in intermediate SQL queries to thoroughly explore our dataset.
Project Management: Practice using different technologies together as well as planning out the project from start to finish, from collecting data to generate a dataset to using SQL queries to help visualise the data in Tableau.
Dataset
The dataset used for this project is sourced from https://pokemondb.net, using their 'text list generator' tool which allows us to easily create a csv file as our starting point. The data contains information on various Pokémon, including their names, types, base stats, and other relevant attributes.
Visualizations
In this project, we create five visualizations to utilize in our final resulting dashboard.
- Pokemon Stats Overview
Description: A bar chart that displays the attributes and stats of every pokemon
- Pokemon Type Distribution (both single- and dual-types)
A bar chart and a matrix to compare the numbers of both the single- and dual-typed pokemon
- Stats Trend by Generation
A line graph which displays the trend of increasing stats in each generation of Pokemon
- Number of Pokemon by Generation
A simple bar chart which shows the number of pokemon in each generation.