How kishanrajpurohit260/flight-delay-prediction works
This is a flight-operations analytics and delay-prediction project. Its principal workflow analyzes 2015 flight data, defines delay labels, and trains a Random Forest classifier; separate SQL analysis and a documented Power BI dashboard support operational reporting. The tree contains the notebook and SQL file, but not the dataset or dashboard artifact. The notebook’s internal steps and the dashboard’s data connections are therefore represented only where the README supports them.
Main entry points: flight_delay_prediction.ipynb Flight Analysis Notebook · flight_delay_queries.sql Flight SQL Queries
Components 9
Prediction and EDA
- Flight Analysis Notebook
flight_delay_prediction.ipynb - Exploratory Analysis
flight_delay_prediction.ipynb - Delay Labeling
flight_delay_prediction.ipynb - Random Forest
flight_delay_prediction.ipynb
Database Analytics
- MySQL Database
- Flight SQL Queries
flight_delay_queries.sql
Business Intelligence
- Power BI Dashboard
Other components
- Analyst
- 2015 Flight Data
Connections 8
- Analyst → Flight Analysis Notebook: runs analysis
- 2015 Flight Data → Flight Analysis Notebook: analyzes
- Flight Analysis Notebook → Exploratory Analysis: performs
- Flight Analysis Notebook → Delay Labeling: labels flights
- Flight Analysis Notebook → Random Forest: trains
- Analyst → Flight SQL Queries: runs queries
- Flight SQL Queries → MySQL Database: queries
- Analyst → Power BI Dashboard: views reports