Category: Projects

The objective of this project is to showcase connecting Tableau (could be done with any BI software naturally) and thus reducing the size of the information that is extracted, which greatly improves the visualisation performance. Database design (schema) I first created a mock database in MS Access, with 2 tables: flights – This one contains […]

The following page was copied from a knitted (html) R Markdown document, available at my github page. ICAO traffic ICAO traffic 2023-07-05 R Markdown This dataset and resulting visualisation is simple, the objective was to demonstrate extracting information from a PDF table and creating a simple hybrid chart in R using ggplot2 library. The resulting […]

This visualisation is inspired by the ATM Cost Effectiveness (ACE) Reports, published each year by EUROCONTROL´s PRU. Information on the preparation and validation of the dataset is available in this article. It also describes some of the terms used. The visulisation shows the evolution of the following metrics over 4 years: align=”center” The interesting takeaway […]

Click on the “brick” to see how the delays were distributed during the year. The Union-wide capacity target is set for each year of the reference period 2 (RP2) at 0.5 minutes of average ATFM delay per flight (green color is below the target). The phone version is available here. Data pre-aggregation The great thing […]

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 […]

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, […]

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 […]