Level 4: The Need for Speed

August 26, 2022
Challenges

Welcome back!

Back in Level 3, we got powered up, now we’re in a race against time to stop the bad guys and win the game. For our next theme we’re valuing “The Need for Speed” as we race around the game world in search of victory. Getting from A to B in the fastest way possible is very challenging so any data we have would be invaluable, and from this data we may want to find out:

  • Is there an optimal route I should go?
  • Where are the fastest vehicles?
  • Who are the fastest competitors in speed runs?

There are three challenges to choose from.

Challenge 1: Fast and Furious

Visualising data about our FAST games, with datasets ranging from the best horses of Red Dead Redemption 2, to the fastest solve times of Rubik cubes

Pick one of the data sets below, or a data set you've found, and visualise it.

Casual Difficulty - For those new to data visualisation or with limited time available)

Normal Difficulty - A fair size data set that could create multiple data visualisations

Heroic Difficulty - A large data set for those with more time available

Legendary difficulty - Bring your own data or expand on the data provided by bringing new data to the project

For those considering the Legendary difficulty (bring your own data), here are a few ideas to get you started:

  • Are there games that you’ve played, or those played competitively and specifically for speed runs (i.e., the Uncharted series has a speed run option)
  • What games give you added benefits for completing things fast and/or perfectly (i.e., Crash Bandicoot level relics based on time completion and if you were able to collect all the fruit)
  • What games use time as a disadvantage? (i.e., Tekken and Mortal Kombat have time limits on how long a match can last, Sonic the Hedgehog only gives you X amount of time to complete a level (as do many Sega games, i.e., Streets of Rage))

Looking for data sets? Check out Sarah Bartlett's Twitter thread for data sources

Challenge 2: Map Layers

Getting up to speed with Tableau’s Map layer functionality and how we use layers to add more detail and data to our visualisations

Create a visualization focused on time using map layers. It does not have to be an actual map if you don’t want to, the goal is to work on your map layer techniques to create the visualization.

The idea with this theme is to emulate speed/time. Depending on the dataset, this could be actual timed events (i.e., a scoreboard), or showcasing items/characters that have different speed-driven metrics. It is up to you how to create the visualization, but keeping the theme of speed/time in mind as designing.

Here are a few blog tutorials from the community

To work with map layers, without using a map, you are likely going to need to use a tool that will allow you to add new shapes or images as shapes that you’ve created, or collected. This includes, but is not limited to tools such as Figma, PowerPoint, Adobe, etc.

If you are looking for icons, thenounproject.com is a great resource.

If you are looking to chart custom paths on a map, there are a few resources that you can use for this: CBI Studio (interworks.com) or PathToPoints (shinao.github.io)

Try to focus on a color blind friendly color palette for an additive accessibility challenge. You can use this tool to test your visualizations color-accessibility: Coblis — Color Blindness Simulator – Colblindor (color-blindness.com)

Here are some great vizzes from the Tableau community to give you an idea what can be done with map layers!

PokeMon: PokeDex (1-20) of Gen One by Joti Gautam

#IronQuest | Movies of the 90s by Priya Padham

Travel Planner + Emissions Calculator by Marc Reid

FIFA Players - One Map Layer by CJ Mayes

South Mountain by Adam E McCann

Table with Map Layers by Luke Stanke

Challenge 3: Wild West Horse

Finding the fastest horse in the west by extracting data from a website to a csv file, we walk you through finding and extracting data on Red Dead Redemption 2’s horses.

For this challenge, we’re trying something new - obtaining data from gtabase.com for our horses of red dead redemption 2 data set. A few notes:

  • This technique will not work for all websites - which depends largely on how they store and surface data on a webpage.
  • We are doing this strictly in the interest of building an engaging non-commercial data visualisation sourcing gtabase.com not to recreate the owner’s website.
  • We will need a Google Chrome browser (other browsers may have similar functionality) for the data clean up you can use a data prep tool, coding language or Excel

Task

Using Google Chrome (or a browser of choice), find the JSON data from gtabase.com/red-dead-redemption-2/horses/. Flatten the JSON data, save the data as a csv and clean up the columns.

  1. Navigate to gtabase.com/red-dead-redemption-2/horses/
  2. Right click on the page and select “inspect” to open the Google Developer tools panel (or Ctrl + Shift + I)
  3. At the top of the Developer tools panel select the tab “Network” and refresh the page - you should now see each section of the webpage being loaded in order
  4. On Developer tools filter for “Fetch/XML” and in the search box type “json”
  5. The first result “7.json?.......” will be our dataset which we can verify using the tab on right “Preview”, return to “Headers” and copy the Request URL.
  6. In a new browser tab search for “JSON to CSV” I have used convertcsv.com/json-to-csv and copy the URL into Step 1, Enter URL and hit “Load URL” and then to Step 3. “Convert JSON to CSV” and then “Download Result”. Coders amongst you may want to have a go at flattening the JSON, for those using data prep tools check whether your tool can intake JSON data.
  7. The data here is rather messy, for example, the 13th column starting “Turkoman Horse” has its correct column heading in the 16th column starting “Horse Breed”. Reduce the data set only keeping columns with the following data: Id, name, image, Horse Breed, Horse Class, Handling, Health, Stamina, Speed, Acceleration, Handling, Release Date, Title Update, Game Edition, Overall Rating, Base Value ($)
  8. Cleanup the release data column so it is of a date format, e.g. YYYY-MM-DD. For this example, we are converting the date string “December 22, 2020”, as the epoch “1608591600” differs by 1 day.
  9. Output the data link

If you’d like to learn more about APIs see Will’s post on FlerlageTwins.com, Tableau Public APIs Plus a VOTD Data Set

Inspiration from the Tableau community

Your content may be different but focus on the choices the authors have made in presenting the data, what would you do differently? And what aspects would you like to emulate? Here are some vizzes to check out for inspiration.

The Evolution of Rubiks Cube Solve Times by Ghafar Shah

Does size matter? How the size of a rubiks cube affect players' performance by Liam Holland

Dark Souls Speedrunning by Mina Ozgen

Kind of the Cubes by Collin Smith

I just wanna watch some speedruns by Ethan Tai

Hypercars - Making the Impossibe Possible by Naresh Suglani

BMW M Performance by Gene Yampolsky

Melbourne Cup: Horse stats by race by Leigh Morrell

Games Done Quick by Kevin Ruprecht

How to Submit

Team GNV

This project focuses a monthly theme that you can participate to challenge either data preparation, data visualization or visual design. Existing datasets on video games will be readily available and comes with difficulty scales to help those newer or with limited time to practice. You can also bring data from your own favorite games too! We love all types of games: card games, board games, video games, party games, game shows, the list goes on!

Related Posts