Flight Analytics: Aviation Data and Dashboards
Airlines generate millions of records on flights, delays, revenue, and fleet utilization. Analyzing that data requires choosing the right database for each question. This project takes 5.74M real airline operation records, analyzes them in PostgreSQL to understand how to optimize queries from the engine level, migrates them to BigQuery to compare both database paradigms, and presents the findings in an interactive dashboard: route map, delay patterns, revenue concentration, and fleet performance.





