# bhupesh-debug/austin-aviation-financial-analytics architecture

> Architecture diagram of the GitHub repository bhupesh-debug/austin-aviation-financial-analytics, generated by GitDiagram from its file tree, README and a sample of source files (last updated 2026-11-20). It is an AI-made overview: check details against the source.

- Interactive diagram: https://gitdiagram.com/bhupesh-debug/austin-aviation-financial-analytics
- Repository: https://github.com/bhupesh-debug/austin-aviation-financial-analytics
- Video tour (about a minute): https://gitdiagram.com/bhupesh-debug/austin-aviation-financial-analytics/video

## Overview

This repository is a synthetic municipal-airport finance analytics suite. Its principal workflow starts with a single pipeline run, generates AUS-calibrated datasets, performs revenue forecasting, FAA grant screening, GL/bank reconciliation, and debt-ratio/DSCR analysis, then assembles an Excel model, charts, and metrics. The map follows the documented pipeline and its explicit calls; unsampled implementation details are not inferred. Dataset and report paths are taken from the repository tree and README.

Main entry points: [`run_pipeline.py`](https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/run_pipeline.py) (Pipeline runner), [`src/data_generator.py`](https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/src/data_generator.py) (Dataset generator), [`src/excel_power_user_builder.py`](https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/src/excel_power_user_builder.py) (Excel model builder), [`src/visualizations.py`](https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/src/visualizations.py) (Executive charts)

## Diagram (Mermaid)

```mermaid
flowchart TD

subgraph group_pipeline["Pipeline orchestration"]
  node_runner["Pipeline runner<br/>[run_pipeline.py]"]
end

subgraph group_data["Synthetic finance data"]
  node_generator["Dataset generator<br/>[data_generator.py]"]
  node_revenue_data["Revenue data"]
  node_grant_data["CIP grant data"]
  node_reconciliation_data["GL bank data"]
  node_debt_data["Debt schedule"]
end

subgraph group_analysis["Financial analytics"]
  node_forecast["Revenue forecaster<br/>[forecasting_ml.py]"]
  node_grant_mining["Grant anomaly mining"]
  node_reconciliation["GL bank reconciliation"]
  node_debt_analysis["Ratios and DSCR stress"]
end

subgraph group_outputs["Decision outputs"]
  node_workbook["Excel model builder"]
  node_visuals["Executive charts<br/>[visualizations.py]"]
  node_excel_artifact["Excel workbook"]
  node_chart_artifacts["Chart set"]
  node_metrics["Pipeline metrics"]
end

node_operator(("Pipeline operator"))

node_operator -->|"runs"| node_runner
node_runner -->|"calls"| node_generator
node_generator -->|"generates"| node_revenue_data
node_generator -->|"generates"| node_grant_data
node_generator -->|"generates"| node_reconciliation_data
node_generator -->|"generates"| node_debt_data
node_runner -->|"reads"| node_revenue_data
node_runner -->|"reads"| node_grant_data
node_runner -->|"reads"| node_reconciliation_data
node_runner -->|"reads"| node_debt_data
node_runner -->|"calls"| node_forecast
node_runner -->|"calls"| node_grant_mining
node_runner -->|"calls"| node_reconciliation
node_runner -->|"calls"| node_debt_analysis
node_runner -->|"calls"| node_workbook
node_runner -->|"calls"| node_visuals
node_runner -->|"writes"| node_excel_artifact
node_runner -->|"writes"| node_chart_artifacts
node_runner -->|"writes"| node_metrics
node_forecast -->|"feeds forecast"| node_workbook
node_grant_mining -->|"feeds scored grants"| node_workbook
node_reconciliation -->|"feeds tie-out"| node_workbook
node_debt_analysis -->|"feeds DSCR"| node_workbook
node_forecast -->|"feeds predictions"| node_visuals
node_grant_mining -->|"feeds scores"| node_visuals
node_reconciliation -->|"feeds exceptions"| node_visuals
node_debt_analysis -->|"feeds simulations"| node_visuals

click node_runner "https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/run_pipeline.py"
click node_generator "https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/src/data_generator.py"
click node_revenue_data "https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/data/synthetic/enplanements_and_revenue.csv"
click node_grant_data "https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/data/synthetic/cip_projects_and_faa_grants.csv"
click node_reconciliation_data "https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/data/synthetic/gl_and_bank_reconciliation.csv"
click node_debt_data "https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/data/synthetic/debt_service_schedule.csv"
click node_forecast "https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/src/forecasting_ml.py"
click node_grant_mining "https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/src/data_mining_anomalies.py"
click node_reconciliation "https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/src/reconciliation_engine.py"
click node_debt_analysis "https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/src/debt_monte_carlo.py"
click node_workbook "https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/src/excel_power_user_builder.py"
click node_visuals "https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/src/visualizations.py"
click node_excel_artifact "https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/reports/AUS_Aviation_Financial_Model_Excel2019.xlsx"
click node_chart_artifacts "https://github.com/bhupesh-debug/austin-aviation-financial-analytics/tree/main/reports/figures"
click node_metrics "https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/reports/pipeline_metrics.json"

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_runner toneBlue
class node_generator,node_revenue_data,node_grant_data,node_reconciliation_data,node_debt_data toneAmber
class node_forecast,node_grant_mining,node_reconciliation,node_debt_analysis toneMint
class node_workbook,node_visuals,node_excel_artifact,node_chart_artifacts,node_metrics toneRose
class node_operator toneIndigo
```

## Components

### Pipeline orchestration

- [Pipeline runner](https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/run_pipeline.py): `run_pipeline.py`

### Synthetic finance data

- [Dataset generator](https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/src/data_generator.py): `src/data_generator.py`
- [Revenue data](https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/data/synthetic/enplanements_and_revenue.csv): `data/synthetic/enplanements_and_revenue.csv`
- [CIP grant data](https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/data/synthetic/cip_projects_and_faa_grants.csv): `data/synthetic/cip_projects_and_faa_grants.csv`
- [GL bank data](https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/data/synthetic/gl_and_bank_reconciliation.csv): `data/synthetic/gl_and_bank_reconciliation.csv`
- [Debt schedule](https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/data/synthetic/debt_service_schedule.csv): `data/synthetic/debt_service_schedule.csv`

### Financial analytics

- [Revenue forecaster](https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/src/forecasting_ml.py): `src/forecasting_ml.py`
- [Grant anomaly mining](https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/src/data_mining_anomalies.py): `src/data_mining_anomalies.py`
- [GL bank reconciliation](https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/src/reconciliation_engine.py): `src/reconciliation_engine.py`
- [Ratios and DSCR stress](https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/src/debt_monte_carlo.py): `src/debt_monte_carlo.py`

### Decision outputs

- [Excel model builder](https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/src/excel_power_user_builder.py): `src/excel_power_user_builder.py`
- [Executive charts](https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/src/visualizations.py): `src/visualizations.py`
- [Excel workbook](https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/reports/AUS_Aviation_Financial_Model_Excel2019.xlsx): `reports/AUS_Aviation_Financial_Model_Excel2019.xlsx`
- [Chart set](https://github.com/bhupesh-debug/austin-aviation-financial-analytics/tree/main/reports/figures): `reports/figures`
- [Pipeline metrics](https://github.com/bhupesh-debug/austin-aviation-financial-analytics/blob/main/reports/pipeline_metrics.json): `reports/pipeline_metrics.json`

### Other components

- **Pipeline operator**

## Connections

- Pipeline operator → Pipeline runner: runs (evidence: `README.md`)
- Pipeline runner → Dataset generator: calls (evidence: `run_pipeline.py`)
- Dataset generator → Revenue data: generates (evidence: `README.md`)
- Dataset generator → CIP grant data: generates (evidence: `README.md`)
- Dataset generator → GL bank data: generates (evidence: `README.md`)
- Dataset generator → Debt schedule: generates (evidence: `README.md`)
- Pipeline runner → Revenue data: reads (evidence: `run_pipeline.py`)
- Pipeline runner → CIP grant data: reads (evidence: `run_pipeline.py`)
- Pipeline runner → GL bank data: reads (evidence: `run_pipeline.py`)
- Pipeline runner → Debt schedule: reads (evidence: `run_pipeline.py`)
- Pipeline runner → Revenue forecaster: calls (evidence: `run_pipeline.py`)
- Pipeline runner → Grant anomaly mining: calls (evidence: `run_pipeline.py`)
- Pipeline runner → GL bank reconciliation: calls (evidence: `run_pipeline.py`)
- Pipeline runner → Ratios and DSCR stress: calls (evidence: `run_pipeline.py`)
- Pipeline runner → Excel model builder: calls (evidence: `run_pipeline.py`)
- Pipeline runner → Executive charts: calls (evidence: `run_pipeline.py`)
- Pipeline runner → Excel workbook: writes (evidence: `run_pipeline.py`)
- Pipeline runner → Chart set: writes (evidence: `run_pipeline.py`)
- Pipeline runner → Pipeline metrics: writes (evidence: `run_pipeline.py`)
- Revenue forecaster → Excel model builder: feeds forecast (evidence: `run_pipeline.py`)
- Grant anomaly mining → Excel model builder: feeds scored grants (evidence: `run_pipeline.py`)
- GL bank reconciliation → Excel model builder: feeds tie-out (evidence: `run_pipeline.py`)
- Ratios and DSCR stress → Excel model builder: feeds DSCR (evidence: `run_pipeline.py`)
- Revenue forecaster → Executive charts: feeds predictions (evidence: `run_pipeline.py`)
- Grant anomaly mining → Executive charts: feeds scores (evidence: `run_pipeline.py`)
- GL bank reconciliation → Executive charts: feeds exceptions (evidence: `run_pipeline.py`)
- Ratios and DSCR stress → Executive charts: feeds simulations (evidence: `run_pipeline.py`)
