Mindblown: a blog about philosophy.

  • pairs2

  • Number of arriving flights by arrival ATFM delay in minutes, grouped by “CP1 airports”

  • SQL to Tableau

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

  • Comparing ICAO world pax and cargo traffic – ggplot2 (R)

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

  • Simple data verification

    In this article I want to compare the accuraccy of the data and the calculations used in some of the visualisations, en-route ATFM delay, to be more precise. The reference for comparison will be the document EUROCONTROL Standard Inputs for Economic Analyses. In here, in chapter, the average en-route delay is defined like this: In […]

  • ATM/CNS provision costs and traffic volumes – data preparation and validation

    For this visulasation, I needed two sets of data: Definitions First the definitions. ATM/CNS provision costs is a metric used in the ACE reports and it excludes MET costs, EUROCONTROL costs and States/NSAs costs from the overal costs equation. The “composite gate-to-gate flight-hours”considers a “gate-to-gate” perspective, “because the boundaries used to allocate costs between en-route […]

  • Changes in ATM/CNS provision costs and traffic volumes

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

  • En-route delay per state heatmap

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

  • Simple linear regression – how dataset sample influences the outcome

    First I wanted to create a simple linear regression, plotting the number of flights and the number of delays in the SES area (RP1-RP2), for the period of years 2016-2019. I extracted the data from the EUROCONTROL datasets – Daily IFR traffic and en-route ATFM delay by entity and delay cause (FIR based) and Monthly […]

  • Preparing ICAO World total revenue traffic

    I sourced the data from the tables published as annexes to the ICAO Annual Reports of the Council (and/or “World of air transport in year YYYY”). These were downloaded from the ICAO public website. The oldest edition with data available was from 2006, which would contain data down to year 1998. I downloaded 4 different […]

Got any book recommendations?

Get In Touch