# kishanrajpurohit260/flight-delay-prediction architecture

> Architecture diagram of the GitHub repository kishanrajpurohit260/flight-delay-prediction, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-09-26). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/kishanrajpurohit260/flight-delay-prediction
- Repository: https://github.com/kishanrajpurohit260/flight-delay-prediction

## Overview

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`](https://github.com/kishanrajpurohit260/flight-delay-prediction/blob/main/flight_delay_prediction.ipynb) (Flight Analysis Notebook), [`flight_delay_queries.sql`](https://github.com/kishanrajpurohit260/flight-delay-prediction/blob/main/flight_delay_queries.sql) (Flight SQL Queries)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_ml["Prediction and EDA"]
  node_notebook["Flight Analysis Notebook"]
  node_eda["Exploratory Analysis"]
  node_labeling["Delay Labeling"]
  node_classifier["Random Forest"]
end

subgraph group_sql["Database Analytics"]
  node_mysql[("MySQL Database")]
  node_queries["Flight SQL Queries"]
end

subgraph group_bi["Business Intelligence"]
  node_dashboard["Power BI Dashboard"]
end

node_analyst(("Analyst"))
node_dataset["2015 Flight Data"]

node_analyst -->|"runs analysis"| node_notebook
node_dataset -->|"analyzes"| node_notebook
node_notebook -->|"performs"| node_eda
node_notebook -->|"labels flights"| node_labeling
node_notebook -->|"trains"| node_classifier
node_analyst -->|"runs queries"| node_queries
node_queries -->|"queries"| node_mysql
node_analyst -->|"views reports"| node_dashboard

click node_notebook "https://github.com/kishanrajpurohit260/flight-delay-prediction/blob/main/flight_delay_prediction.ipynb"
click node_eda "https://github.com/kishanrajpurohit260/flight-delay-prediction/blob/main/flight_delay_prediction.ipynb"
click node_labeling "https://github.com/kishanrajpurohit260/flight-delay-prediction/blob/main/flight_delay_prediction.ipynb"
click node_classifier "https://github.com/kishanrajpurohit260/flight-delay-prediction/blob/main/flight_delay_prediction.ipynb"
click node_queries "https://github.com/kishanrajpurohit260/flight-delay-prediction/blob/main/flight_delay_queries.sql"

classDef toneNeutral fill:#f8fafc,stroke:#334155,stroke-width:1.5px,color:#0f172a
classDef toneBlue fill:#dbeafe,stroke:#2563eb,stroke-width:1.5px,color:#172554
classDef toneAmber fill:#fef3c7,stroke:#d97706,stroke-width:1.5px,color:#78350f
classDef toneMint fill:#dcfce7,stroke:#16a34a,stroke-width:1.5px,color:#14532d
classDef toneRose fill:#ffe4e6,stroke:#e11d48,stroke-width:1.5px,color:#881337
classDef toneIndigo fill:#e0e7ff,stroke:#4f46e5,stroke-width:1.5px,color:#312e81
classDef toneTeal fill:#ccfbf1,stroke:#0f766e,stroke-width:1.5px,color:#134e4a
class node_notebook,node_eda,node_labeling,node_classifier toneBlue
class node_mysql,node_queries toneAmber
class node_dashboard toneMint
class node_analyst,node_dataset toneIndigo
```

## Components

### Prediction and EDA

- [Flight Analysis Notebook](https://github.com/kishanrajpurohit260/flight-delay-prediction/blob/main/flight_delay_prediction.ipynb): `flight_delay_prediction.ipynb`
- [Exploratory Analysis](https://github.com/kishanrajpurohit260/flight-delay-prediction/blob/main/flight_delay_prediction.ipynb): `flight_delay_prediction.ipynb`
- [Delay Labeling](https://github.com/kishanrajpurohit260/flight-delay-prediction/blob/main/flight_delay_prediction.ipynb): `flight_delay_prediction.ipynb`
- [Random Forest](https://github.com/kishanrajpurohit260/flight-delay-prediction/blob/main/flight_delay_prediction.ipynb): `flight_delay_prediction.ipynb`

### Database Analytics

- **MySQL Database**
- [Flight SQL Queries](https://github.com/kishanrajpurohit260/flight-delay-prediction/blob/main/flight_delay_queries.sql): `flight_delay_queries.sql`

### Business Intelligence

- **Power BI Dashboard**

### Other components

- **Analyst**
- **2015 Flight Data**

## Connections

- 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