{"id":560,"date":"2020-11-19T02:47:09","date_gmt":"2020-11-19T00:47:09","guid":{"rendered":"https:\/\/www.realbiathlon.com\/blog\/?p=560"},"modified":"2020-12-17T11:26:21","modified_gmt":"2020-12-17T17:26:21","slug":"improvements-season-to-season-putting-it-to-use","status":"publish","type":"post","link":"https:\/\/biathlonanalytics.com\/TEST\/improvements-season-to-season-putting-it-to-use\/","title":{"rendered":"Improvements season-to-season, putting it to use"},"content":{"rendered":"\n<p class=\"has-medium-font-size\">To highlight what a great site Real biathlon is, and how easily the data can be used to give some great insights, below is a step-by-step on how to make a quick interactive chart based on the data referenced in the previous article. I used Google Sheets and Tableau Public, but you can use any of these kinds of tools that you are comfortable with, and publish a lookup chart within an hour. That&#8217;s how easy the real biathlon site is to collect biathlon data!<\/p>\n\n\n\n<p><div class=\"tableauPlaceholder\" id=\"viz1606170197270\" style=\"position: relative\"><noscript><a href=\"#\"><img decoding=\"async\" alt=\" \" src=\"https:\/\/public.tableau.com\/static\/images\/re\/realbiathlon-overallperformancescore\/realbiathlon\/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=\"realbiathlon-overallperformancescore\/realbiathlon\"><param name=\"tabs\" value=\"no\"><param name=\"toolbar\" value=\"no\"><param name=\"static_image\" value=\"https:\/\/public.tableau.com\/static\/images\/re\/realbiathlon-overallperformancescore\/realbiathlon\/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\"><\/object><\/div>                <script type=\"text\/javascript\">                    var divElement = document.getElementById('viz1606170197270');                    var vizElement = divElement.getElementsByTagName('object')[0];                    if ( divElement.offsetWidth > 800 ) { vizElement.style.width='100%';vizElement.style.height=(divElement.offsetWidth*0.75)+'px';} else if ( divElement.offsetWidth > 500 ) { vizElement.style.width='100%';vizElement.style.height=(divElement.offsetWidth*0.75)+'px';} else { vizElement.style.width='100%';vizElement.style.height='700px';}                     var scriptElement = document.createElement('script');                    scriptElement.src = 'https:\/\/public.tableau.com\/javascripts\/api\/viz_v1.js';                    vizElement.parentNode.insertBefore(scriptElement, vizElement);                <\/script><\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 1 &#8211; download &amp; store the data<\/h3>\n\n\n\n<p class=\"has-medium-font-size\">For the created chart I used the data of the last five season, for both men and women, limiting the data to only those athletes with at least 10 races. Since that never resulted in more than 100 athletes per gender and season, I did not set a filter on that.<\/p>\n\n\n\n<p class=\"has-medium-font-size\">After selecting the Season Statistics, Performance Score (for example, the <a rel=\"noreferrer noopener\" href=\"https:\/\/www.realbiathlon.com\/seasons.html?year=2020&amp;gender=W&amp;type=athletes&amp;period=Season&amp;discipline=NonTeam&amp;category=powerRanking&amp;min=10&amp;chart=false&amp;stat=totalScore&amp;rank=false&amp;movingavg=none&amp;limit=100\" target=\"_blank\">2019-2020 season for women<\/a>), you can just select the table, copy, open a blank Google Sheet, select cell A1 and paste. In my case, my first row showed twice so I just removed one of them. Do this 10 times (five per gender), name the sheets appropriately (W1920, W1819, M1920, M1819, etc.) and export from Google Sheets to an xlsx file. You can export to text, but you would have to do that per sheet, where exporting to Excel (xlsx) exports all sheets at once.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Step 2 &#8211; open data in Tableau<\/h3>\n\n\n\n<p>In Tableau Public connect to the spreadsheet by:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>clicking on the Data menu &gt; New Data Source<\/li><li>click on Microsoft Excel in the Connect window<\/li><li>select the xlsx file you just exported from Google Sheets<\/li><li>at the bottom of the list that shows your sheet names, double click New Union<\/li><li>drag all 10 sheets into the Union window<\/li><li>click OK<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Step 3 &#8211; create some calculated fields<\/h3>\n\n\n\n<ul class=\"wp-block-list\"><li>Full Name = [Given Name] + &#8221; &#8221; + [Family Name]<\/li><li>Gender = <\/li><\/ul>\n\n\n\n<pre class=\"wp-block-code\"><code>IF LEFT(&#91;Table Name],1) = \"M\" THEN \"Men\"\nELSEIF LEFT(&#91;Table Name],1) = \"W\" THEN \"Women\"\nELSE \"Unknown\"\nEND<\/code><\/pre>\n\n\n\n<ul class=\"wp-block-list\"><li>Season = MID([Table Name],2,5)<\/li><\/ul>\n\n\n\n<h3 class=\"wp-block-heading\">Step 4 &#8211; create the chart<\/h3>\n\n\n\n<p class=\"has-medium-font-size\">Depending on what you want to show in your chart, the following differs, but to replicate the chart I made, drag the following pills in the Filters, Marks, Columns and Rows:<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img decoding=\"async\" src=\"https:\/\/www.realbiathlon.com\/blog\/wp-content\/uploads\/2020\/11\/Screen-Shot-2020-11-18-at-5.03.23-PM.png\" alt=\"\" class=\"wp-image-634\"\/><\/figure>\n\n\n\n<h3 class=\"wp-block-heading\">Step 5 &#8211; publish to Tableau Public<\/h3>\n\n\n\n<p class=\"has-medium-font-size\">Once you are happy with your chart, just save the file to Tableau Public.<\/p>\n\n\n\n<p class=\"has-medium-font-size\">Now users can use highlighters to see how their favourite athletes stack up against the field or see how certain Nations fare.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A step-by-step on how to make a quick interactive chart based on data from the real biathlon website<\/p>\n","protected":false},"author":1,"featured_media":1143,"comment_status":"open","ping_status":"open","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":[40,26,41],"class_list":["post-560","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-statistical-analysis","tag-data-use-examples","tag-data-visualization","tag-tableau"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/biathlonanalytics.com\/TEST\/wp-json\/wp\/v2\/posts\/560","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=560"}],"version-history":[{"count":2,"href":"https:\/\/biathlonanalytics.com\/TEST\/wp-json\/wp\/v2\/posts\/560\/revisions"}],"predecessor-version":[{"id":1145,"href":"https:\/\/biathlonanalytics.com\/TEST\/wp-json\/wp\/v2\/posts\/560\/revisions\/1145"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/biathlonanalytics.com\/TEST\/wp-json\/wp\/v2\/media\/1143"}],"wp:attachment":[{"href":"https:\/\/biathlonanalytics.com\/TEST\/wp-json\/wp\/v2\/media?parent=560"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/biathlonanalytics.com\/TEST\/wp-json\/wp\/v2\/categories?post=560"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/biathlonanalytics.com\/TEST\/wp-json\/wp\/v2\/tags?post=560"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}