In the airport traffic spreadsheet, you can see the dates of flights, where they were coming from, where they landed at, and the name of the airport that they flew out of. We chose this dataset because it may be helpful to travelers, flight attendants, piolets, and airport workers because you can see the amount of traffic that typically comes through the airport. All of these numbers are helpful for the workers because they can see the peak travel times, air traffic throughout the year, and the number of people coming in and out of the airport per day, month, and year.
Also, the spreadsheet may help with planning within the airport. From restaurant sales, shop sales, and other items travelers may buy while in the airport. Managers at airports could use this to help with employee numbers, especially through the summer months of June through August, which are the busiest flight times.
The data can also be useful for travelers who want to avoid traveling during busy times. By looking at the monthly flight trends, passengers can see when the busiest, and most expensive time to fly is. Choosing to fly in the off-season could mean shorter wait times inside airports and cheaper flights.
Overall, this spreadsheet was created to help with decision making for travelers. This spreadsheet is helpful for people who like to make the best decisions while traveling. They can use it to make choices about when to fly, when to buy the cheapest tickets, and when airports will be the least busy by looking at flight frequency, peak travel times and airport traffic.
In the line chart below, the total flights for each country’s airport in the year 2025 can be shown. The lowest number of flights was from the Geneva airport with only about 171,000 flights in 2025. The highest number of flights was from the Istanbulairport with a little more than 544,000 flights in 2025. The charts clearness is helpful because it makes the information easy to understand. Airlines and people who make decisions for countries can use this chart to see what is happening with flights in parts of the world throughout the year. The flight operations in each region are very important to these people.
In the scatterplot below, the total flights per country in a month can be shown. Most flights took place in August with Turkey having over 50,000 flights and Paris and Amsterdam having almost 45,000 flights. January and February were the two months with the lowest number of flights. Turkey only had just over 6,000 flights in the month of February and just over 7,000 flights in the month of January. The chart helps us ultimately understand what is going on with air traffic around the world. This chart tells us about how many people are traveling, how well countries are doing economically and how connected they are to their airports.
The bar chart below shows the combined flights from the 17 countries from January 2025 to January 2026. The bar graph shows the total flights from each country by month. August was the busiest month for flights with almost 51,000 flights. February was the slowest month for flights with almost 37,000 flights. In this bar chart it is shown that most people travel during the hot summer months and don’t travel as much during the cold winter months, which makes sense. By comparing monthly patterns, viewers can better understand how the demand for flights ultimately shifts throughout the year. It also helps show how different countries experience increases or decreases in air traffic.
In the scatter plot shown below, it is comparing the aerodromes by their total number of flights in a year. The x-axis shows the total number of flights in 2025 per each country and the y-axis shows the airports ICAO code. The Istanbul airport was the busiest along with Amsterdam Schiphol; one of the slowest airports was Brussels. Aerodromes and ICAO codes are used by pilots and airlines to track traffic levels and international routes. Overall, this chart provides valuable insight into the timing and distribution of flights, helping airlines, analysts, and everyday individuals evaluate travel behavior and operational patterns on a monthly basis.
Below is a violin plot that illustrates the distribution of flights departing from each country in 2025. This visualization shows not only the total number of flights but also how those flights are spread across different time periods within the year. The width of each violin represents the frequency of flight counts, with wider sections indicating higher concentrations of flights. This allows viewers to quickly identify patterns such as consistency, variability, and peak travel periods within each country. Overall, the plot provides a deeper understanding of how flight activity differs across countries beyond simple totals and numbers.
The next chart presented is a pie chart that displays the distribution of total flights among a varitey of airports nationwide in 2025. Each slice represents an individual airport’s contribution to overall flight activity, making it easy to compare their relative volumes of flights. The largest portion of the chart identifies the airport with the highest number of flights, while smaller sections represent airports with lower traffic levels. In this situation, Frankfurt Airport in Germany had the most flights while Bergerac Dordogne Périgord Airport in France had the least amount of flights. This visualization helps highlight how air traffic is concentrated among major hubs versus smaller airports. Overall, the chart provides a clear and concise way to understand which airports dominate flight operations and how traffic is distributed.
Lastly, we have a treemap diagram that illustrates which country recorded the highest number of flights in 2025. In this visualization, each rectangle represents a country, and the size of each block corresponds to its total flight volume. In this example we see that Spain and the United Kingdom are tied for the countries who produced the most flights, while Portugal had one of the least. Larger sections indicate countries with higher levels of air traffic, while smaller sections represent those with fewer flights. This layout makes it easy to compare countries at a glance and identify the dominant contributors to overall aviation activity without reading directly into numbers. Overall, the treemap provides a clear and visually engaging summary of how flight traffic is distributed across countries.