Author: zdenoblasko@gmail.com

  • Top airport pairs, delays and airport information

    This is the most complex project I have created so far. To open it in the Tableau public profile, please click <<here>> or on the image above. The first page gives you more information on the contents. You can also view a static Powerpoint overview of the content <here>, which however obviously lacks the interactivity…

  • Choosing different data visualition/BI applications

    When I first started working with business intelligence applications, I was wondering which one to start with. I did some googling, even asked ChatGTP about it. I started with Power BI, as it uses a UI similar to MS Office. I started to really like it, mainly because it used basically the same Power Query…

  • Airport pairs /top routes dataset preparation

    This dataset was created by combining the information from 34 (EU + UK, MK, ME, TR, IS, NO, CH) detailed datasets called Air passenger transport between the main airports of (COUNTRY) and their main partner airports (routes data), available at the EUROSTAT database page. Honestly, this was so far my biggest data preparation project, I…

  • 3 ways of data aggregation (busiest airports) – Excel, SQL, R

    In this post I want to show 3 different ways to aggregate the data for the busiest airports in EUROCONTROL area over the period of 2016-2022 vizualization.   In one of them I will be using MS Excel with Pivot Table, second one in the second one a  SQL statement (running on a mock database table created in…

  • EUROCONTROL area busiest airports 2016-2022

    This is quite a simple visualisation which is mostly supposed to demonstrate 2 purposes. First, an animation of data – 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,…

  • ESSIP vizualization – data preparation

    Deployment data sourcing, transformation and cleaning  The souce of the data is https://www.atmmasterplan.eu/depl/essip_objectives/map . I couldnt find a way to download a complete raw data for all the objectives for all the years of the ESSIP/LSSIP process, so I downloaded manually data for the last 2 years for 20 objectives.  40 excel files were saved into a folder.  Using the…

  • ATM Master Plan level 3 Deployment Overview (ESSIP) vizualization

    This vizualization, crreated in Tableau, shows the implementation/deployment of selected 20 objectives of the ATM Master Plan level 3 in the EUROCONTROL´s Member States (ESSIP), for the years (editions) 2021 and 2022. All the data is sourced from the atmmasterplan.eu portal. The process of data preparation for this vizualization is summarized in this article. To…