In the previous blog post you can see our visualization of our story.
The story starts with todays numbers of schiphol’s number of passengers, flights and transport of cargo. All these aspects contribute to the economy of the Netherlands. But what has changed in time? In the second part of the infographic, we visualized what has changed over time (passengers in relation to total revenue) and some interesting facts in a timeline. Both aspects have QR codes where one can see our timeline we have made with Kightlab, and the reason for a drop in passengers and revenue in the years 2008-2010 (crisis). The the second to last part we wanted to visualize where schiphol wants to go, visualizing their vision of cleaner energy and social reliability to the world. In the last part of the infographic we wanted to show how they are planning to reach these achievements by showing their strategy of connecting the netherlands, collaboration and contributing to the social economical task they have. With the visualization you can see that they are getting bigger every year, and because of this they have a great responsibility. Therefore, they are trying to be on top of ecological developments and getting the best for their passengers, for the Netherlands, and for the world.
Click on the picture for a takeoff flight with Schiphol from 1916-2015
With the use of TimelineJS, which is an open-source tool that enables anyone to build visually,rich, interactive timelines we have created a timeline of Schiphol from 1916 untill now. So have a look and have fun!
How did we process the data (mention methods and tricks)
For data processing we mainly used the annual reports of Schiphol from 2004 untill 2014. In the report we looked at interesting and compelling data to use for the infographic. In order to tell the story, we combined the data and imported them in an excel file. Moreover, we used statistics that Schiphol put om their website. The trick was to combine raw data with eachother, but with the help of the annual report we knew what the data was about. Therefore, we were able to tell a story about and use data A and data B to see the overall picture of Schiphol. The only thing we found difficult was to work with Tableau. As we all never had used it before, it was quite difficult to understand the program. However, with the help of Suleman and use of videos from youtube we were able to link two data sets together.
Young pilots still have major problems with finding work. As many as 1200 graduate pilots sitting at home without a job..
Aviation schools have created a certain image with stories of Boeing and Airbus, while many of these stories are fictitious. (BNR News)
How much?!
Unemployment rate pilots (%)
The jobless pilots sit with an average debt of 150,000 euros. Often they can not meet the monthly financial obligations. According Otjan de Bruijn of the Dutch Airline Pilots Association (DAPA), there are several reasons for the high unemployment rate among pilots. “Since 2008 far too many people have been trained”. There are too many flight schools that educate too many people. The second cause is found in the role of funding. In particular, the ABN AMRO bank, which is currently the only bank that provides loans. They continued providing too many loans in the past seven years without wondering if these people could ever get a job that also allows to carry this heavy financial pressure. However, the main reason causing the decline in young pilots finding a job lie with the economic crisis, as mentioned in the annual report of the DAPA.
Consequences
In a recent survey by Vliegtuigschulden, who looked at the negative (psychological) the effects of the huge debts which many young pilots face were investigated. The findings are from 200 Dutch young pilots, who filled in a questionnaire. When interpreting the results, one must take into account the fact that pilots are selected for their resistance to stress. Looking at the survey the most interesting result shows that 24% of the young pilots mention that they have psychological problems because of the enormous debt. This varies from mild symptoms such as sleep problems (21%) to severe symptoms such as self mutilation. Furthermore, 41% indicate to seriously have considered fleeing to another country to evade the payment. Given the psychological symptoms, it is furthermore not surprising that 76% of respondents say that with the knowledge of today they would never had started training to become a pilot. Moreover, 73% regret the fact that they have borrowed so much for their study. How can these problems be tackled? And what are important prevention measures that the government needs to implement?
Future solutions
Discouraging young people from becoming a pilot is not what the DAPA is aiming for. However, what DAPA do need to do is better guidance and aftercare for the young pilots. The pilot school created a certain image with stories of Boeing and Airbus, which are not based on reality. Therefore, students who want to become a pilot have to be well informed about the changes of becoming a pilot, the financial problems that may occur, and have to collect as much information about the differences between pilot schools. In addition, the DAPA advises students to have an alternative available. “Make sure you have a program where you can fall back on if it fails to get a job as a pilot”. Consequently, the future for current young pilots is still uncertain..
Hey there Pilot, great to have you flying in our Blog! Here you can find general information on aviation and we will offer you many interesting facts and figures about Schiphol Airport. Moreover, you can join the discussions about factual events happening in the airline and aviation industries and we hope to point out things you may have not heard yet..
So come fly with us, let’s fly let’s fly away!
Group Assignment – Amsterdam Airport Schiphol
Short description – Schiphol
Schiphol Group is an airport company and Amsterdam Airport Schiphol is its principal airport. Amsterdam Airport Schiphol is a well-equipped international airport that offers state-of-the-art facilities to 99 airlines which, in 2013, carried a total of 52.6 million travellers and over 1.5 million tonnes of cargo from Schiphol to destinations all over the world. For our operations we depend strongly on our home carrier KLM and its SkyTeam partners, which account for approximately 70% of all air traffic to and from Schiphol. Via Amsterdam Airport Schiphol, passengers and cargo can reach 323 direct destinations worldwide, several times per day or per week. In addition, our regional airports – Eindhoven Airport and Rotterdam The Hague Airport – offer numerous flights to destinations within Europe.
Group project proposal – Create ‘interactive’ data
Due to the position and fucnction of Schiphol in Dutch society, aviation activities increasingly serve as a breeding ground for new and innovative technologies and, as such, constitute an attractive environment for businesses and employment. With a ‘tentative’ dataset we will visualise interesting facts and ‘interactive’ figures about Amsterdam Airport Schiphol, so stay tuned!.. For now, have a look at our project group members and our individual proposals! Happy take Off!
SChiphol take off 