Flight Data Analysis using SQL

This project analyzes airline flight data using SQL to evaluate airline performance, identify delays, and uncover operational insights.

A relational database was designed with tables for airlines, airports, and flights. Various SQL queries were used to analyze flight volume, delay patterns, airport performance, and common causes of delays.

The project also includes ranking airlines based on their performance using window functions and exploring how factors like distance and delay reasons affect overall flight efficiency.

This analysis helps in understanding inefficiencies in the aviation system and supports data-driven decision-making.