Category: Articles. Few pages, on importing and tidying the data …
-
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 […]
-
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 […]
-
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 […]
-
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 […]