{"id":956,"date":"2020-12-02T06:40:40","date_gmt":"2020-12-02T04:40:40","guid":{"rendered":"https:\/\/www.realbiathlon.com\/blog\/?p=956"},"modified":"2020-12-17T11:21:11","modified_gmt":"2020-12-17T17:21:11","slug":"shooting-speed","status":"publish","type":"post","link":"https:\/\/biathlonanalytics.com\/TEST\/shooting-speed\/","title":{"rendered":"Shooting Speed"},"content":{"rendered":"\n<p class=\"has-medium-font-size\">An analysis of shooting speed in biathlon, using the women&#8217;s individual race in Kontiolahti as an example. The data came from the real biathlon website, here is the <a rel=\"noreferrer noopener\" href=\"https:\/\/www.realbiathlon.com\/races.html?raceId=BT2021SWRLCP01SWIN&amp;year=2021&amp;discipline=Total&amp;category=shooting&amp;relative=total&amp;overview=false&amp;min=120&amp;chart=false&amp;stat=&amp;rank=false&amp;movingavg=none&amp;localtime=false\" target=\"_blank\">exact link<\/a>.<\/p>\n\n\n\n<p class=\"has-medium-font-size\">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 some calculation 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 unnecessarily complicated in Tableau, just much easier to calculate the fields in Google Sheets.<\/p>\n\n\n\n<p class=\"has-medium-font-size\">Just a reminder the Tableau Dashboard below is interactive and intended to be used for further exploration of data. If you open it on <a href=\"https:\/\/public.tableau.com\/profile\/rj7974#!\/vizhome\/BiathlonShootingSpeed\/ShootingSpeedinBiathlon\" data-type=\"URL\" data-id=\"https:\/\/public.tableau.com\/profile\/rj7974#!\/vizhome\/BiathlonShootingSpeed\/ShootingSpeedinBiathlon\" target=\"_blank\" rel=\"noreferrer noopener\">the Tableau Public site<\/a> you can use it full screen. Enjoy!<\/p>\n\n\n\n<p><\/p><div class=\"tableauPlaceholder\" id=\"viz1606883522674\" style=\"position: relative\"><noscript><a href=\"#\"><img decoding=\"async\" alt=\" \" src=\"https:\/\/public.tableau.com\/static\/images\/Bi\/BiathlonShootingSpeed\/ShootingSpeedinBiathlon\/1_rss.png\" style=\"border: none\"><\/a><\/noscript><object class=\"tableauViz\" style=\"display:none;\"><param name=\"host_url\" value=\"https%3A%2F%2Fpublic.tableau.com%2F\"> <param name=\"embed_code_version\" value=\"3\"> <param name=\"site_root\" value=\"\"><param name=\"name\" value=\"BiathlonShootingSpeed\/ShootingSpeedinBiathlon\"><param name=\"tabs\" value=\"no\"><param name=\"toolbar\" value=\"yes\"><param name=\"static_image\" value=\"https:\/\/public.tableau.com\/static\/images\/Bi\/BiathlonShootingSpeed\/ShootingSpeedinBiathlon\/1.png\"> <param name=\"animate_transition\" value=\"yes\"><param name=\"display_static_image\" value=\"yes\"><param name=\"display_spinner\" value=\"yes\"><param name=\"display_overlay\" value=\"yes\"><param name=\"display_count\" value=\"yes\"><param name=\"language\" value=\"en-GB\"><param name=\"filter\" value=\"publish=yes\"><\/object><\/div>                <script type=\"text\/javascript\">                    var divElement = document.getElementById('viz1606883522674');                    var vizElement = divElement.getElementsByTagName('object')[0];                    if ( divElement.offsetWidth > 800 ) { vizElement.style.width='850px';vizElement.style.height='1127px';} else if ( divElement.offsetWidth > 500 ) { vizElement.style.width='850px';vizElement.style.height='1127px';} else { vizElement.style.width='100%';vizElement.style.height='1527px';}                     var scriptElement = document.createElement('script');                    scriptElement.src = 'https:\/\/public.tableau.com\/javascripts\/api\/viz_v1.js';                    vizElement.parentNode.insertBefore(scriptElement, vizElement);                <\/script>\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>An analysis of shooting speed in biathlon, using the women&#8217;s individual race in Kontiolahti as an example.<\/p>\n","protected":false},"author":1,"featured_media":1140,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[34],"tags":[26,33,35],"class_list":["post-956","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-statistical-analysis","tag-data-visualization","tag-puck-possessed","tag-shooting"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/biathlonanalytics.com\/TEST\/wp-json\/wp\/v2\/posts\/956","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/biathlonanalytics.com\/TEST\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/biathlonanalytics.com\/TEST\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/biathlonanalytics.com\/TEST\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/biathlonanalytics.com\/TEST\/wp-json\/wp\/v2\/comments?post=956"}],"version-history":[{"count":3,"href":"https:\/\/biathlonanalytics.com\/TEST\/wp-json\/wp\/v2\/posts\/956\/revisions"}],"predecessor-version":[{"id":1142,"href":"https:\/\/biathlonanalytics.com\/TEST\/wp-json\/wp\/v2\/posts\/956\/revisions\/1142"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/biathlonanalytics.com\/TEST\/wp-json\/wp\/v2\/media\/1140"}],"wp:attachment":[{"href":"https:\/\/biathlonanalytics.com\/TEST\/wp-json\/wp\/v2\/media?parent=956"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/biathlonanalytics.com\/TEST\/wp-json\/wp\/v2\/categories?post=956"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/biathlonanalytics.com\/TEST\/wp-json\/wp\/v2\/tags?post=956"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}