{"id":131,"date":"2023-06-01T16:26:50","date_gmt":"2023-06-01T15:26:50","guid":{"rendered":"https:\/\/zdebla.me\/?p=131"},"modified":"2023-06-16T19:42:51","modified_gmt":"2023-06-16T18:42:51","slug":"eurocontrol-area-busiest-airport-2016-2022","status":"publish","type":"post","link":"https:\/\/zdebla.me\/index.php\/2023\/06\/01\/eurocontrol-area-busiest-airport-2016-2022\/","title":{"rendered":"EUROCONTROL area busiest airports 2016-2022"},"content":{"rendered":"\n<p>This is quite a simple visualisation which is mostly supposed to demonstrate 2 purposes. First, an animation of data &#8211; how the rank of the busiest airports changed over the years. <\/p>\n\n\n\n<p>Another (the main) purpose of this small project was <a href=\"https:\/\/zdebla.me\/index.php\/2023\/06\/01\/2-ways-of-data-aggregation-busiest-airports\/\" data-type=\"post\" data-id=\"137\">to showcase<\/a> how the data for this visualisation can be aggregated from a source dataset, using 3 different means &#8211; Excel, SQL and R. <a href=\"https:\/\/zdebla.me\/index.php\/2023\/06\/01\/2-ways-of-data-aggregation-busiest-airports\/\" data-type=\"post\" data-id=\"137\">The article <\/a>also contains the legal information on the dataset source (EUROCONTROL).<\/p>\n\n\n\n<p>The visualisation shows top 30 airports in the EUROCONTROL area over the period of 2016-2022 (obviously including the figures fall over the COVID period). The sorting is based on the <em>Number of total IFR movements<\/em>. <\/p>\n\n\n\n<p>If the animation doesn\u00b4t start automatically, please press the &#8220;play&#8221; button on the bottom right.<\/p>\n\n\n\n<div class='tableauPlaceholder' id='viz1686659730384' style='position: relative'><noscript><a href='#'><img alt='Dashboard 1 ' src='https:&#47;&#47;public.tableau.com&#47;static&#47;images&#47;bu&#47;busiest_airports_2&#47;Dashboard1&#47;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='busiest_airports_2&#47;Dashboard1' \/><param name='tabs' value='no' \/><param name='toolbar' value='yes' \/><param name='static_image' value='https:&#47;&#47;public.tableau.com&#47;static&#47;images&#47;bu&#47;busiest_airports_2&#47;Dashboard1&#47;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-US' \/><\/object><\/div>                <script type='text\/javascript'>                    var divElement = document.getElementById('viz1686659730384');                    var vizElement = divElement.getElementsByTagName('object')[0];                    if ( divElement.offsetWidth > 800 ) { vizElement.style.width='550px';vizElement.style.height='1427px';} else if ( divElement.offsetWidth > 500 ) { vizElement.style.width='550px';vizElement.style.height='1427px';} else { vizElement.style.width='100%';vizElement.style.height='977px';}                     var scriptElement = document.createElement('script');                    scriptElement.src = 'https:\/\/public.tableau.com\/javascripts\/api\/viz_v1.js';                    vizElement.parentNode.insertBefore(scriptElement, vizElement);                <\/script>\n\n\n\n<p>You can note the prominence of the &#8220;new&#8221; Istanbul Airport.<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"497\" src=\"https:\/\/zdebla.me\/wp-content\/uploads\/2023\/06\/obrazok-32-1024x497.png\" alt=\"\" class=\"wp-image-295\" srcset=\"https:\/\/zdebla.me\/wp-content\/uploads\/2023\/06\/obrazok-32-1024x497.png 1024w, https:\/\/zdebla.me\/wp-content\/uploads\/2023\/06\/obrazok-32-300x146.png 300w, https:\/\/zdebla.me\/wp-content\/uploads\/2023\/06\/obrazok-32-768x373.png 768w, https:\/\/zdebla.me\/wp-content\/uploads\/2023\/06\/obrazok-32-1536x745.png 1536w, https:\/\/zdebla.me\/wp-content\/uploads\/2023\/06\/obrazok-32.png 2044w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>This is quite a simple visualisation which is mostly supposed to demonstrate 2 purposes. First, an animation of data &#8211; how the rank of the busiest airports changed over the years. Another (the main) purpose of this small project was to showcase how the data for this visualisation can be aggregated from a source dataset, [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-131","post","type-post","status-publish","format-standard","hentry","category-projects"],"_links":{"self":[{"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/posts\/131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/comments?post=131"}],"version-history":[{"count":13,"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/posts\/131\/revisions"}],"predecessor-version":[{"id":329,"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/posts\/131\/revisions\/329"}],"wp:attachment":[{"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/media?parent=131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/categories?post=131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/zdebla.me\/index.php\/wp-json\/wp\/v2\/tags?post=131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}