Introduction

As a Data School trainee on the second day of Dashboard Week, I was thrilled to work with a new dataset on flight departures from the US to foreign countries. After exploring the dataset, I decided to create a story around flight efficiency and environmental impact, focusing on vacant seats on flights and their relationship to CO2 emissions.

Data Preparation

To provide more context and insights, I added CO2 emission data for each country from Kaggle and the percentage of CO2 emissions from aviation in total transport emissions. This helped me to understand the environmental impact of flights in different countries and provided a basis for my analysis.

Visualisation

To visualize the relationship between vacant seats and CO2 emissions, I created a line chart that showed the pattern of scheduled and chartered vacant seats over time. This chart highlighted the fluctuation in vacant seats and helped to identify trends in the data. I also created a bar in bar chart that showed the percentage of vacant seats per airline, allowing me to compare the efficiency of different airlines in terms of filling their flights.

To further investigate the relationship between departure and vacant seats, I used a butterfly chart to compare the two variables for flights from US cities. This chart helped me to identify which cities had higher departure rates and which cities had higher vacant seat rates. This insight could be used to optimize flight schedules and improve flight efficiency.

Conclusion

By focusing on vacant seats and their relationship to CO2 emissions, I was able to uncover valuable insights and highlight the environmental impact of air travel. The dashboard I created demonstrated the importance of considering flight efficiency and environmental impact when traveling, and I look forward to applying these insights in the future.

Seema Keswani
Author: Seema Keswani