An analysis of shooting speed in biathlon, using the women’s individual race in Kontiolahti as an example. The data came from the real biathlon website, here is the exact link.
To get this data in a workable format, I just copied the table, pasted it in a text editor and copied/pasted that to Google Sheets. From there I had to do some splitting and moving things around but it was still fairly easy to get a working table. The only time consuming part was manually assigning hits or misses, and for that reason I only did to for the top 30 athletes. Then I added som ecalcualtion for athlete averages, max and min shooting times, etc. Although that can be done in Tableau, I find once you start working with filters etc. in becomes unnessessarily compicated in Tableau, just much easier to calculate the fields in Google Sheets.
Just a reminder the Tableau Dashboard below is interactive and intended to be used for further exploration of data. If you open it on the Tableau Public site you can use it full screen. Enjoy!
About Post Author
Proud dad&husband; analyst & visualization specialist (Tableau, SQL & R); creator of Biathlon Analytics; blog poster on realbiathlon.com; passionate about biathlon, cross country skiing and canoeing