How bhupesh-debug/austin-aviation-financial-analytics works
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 Pipeline runner · data_generator.py Dataset generator · excel_power_user_builder.py Excel model builder · visualizations.py Executive charts
Components 16
Pipeline orchestration
- Pipeline runner
run_pipeline.py
Synthetic finance data
- Dataset generator
src/data_generator.py - Revenue data
data/synthetic/enplanements_and_revenue.csv - CIP grant data
data/synthetic/cip_projects_and_faa_grants.csv - GL bank data
data/synthetic/gl_and_bank_reconciliation.csv - Debt schedule
data/synthetic/debt_service_schedule.csv
Financial analytics
- Revenue forecaster
src/forecasting_ml.py - Grant anomaly mining
src/data_mining_anomalies.py - GL bank reconciliation
src/reconciliation_engine.py - Ratios and DSCR stress
src/debt_monte_carlo.py
Decision outputs
- Excel model builder
src/excel_power_user_builder.py - Executive charts
src/visualizations.py - Excel workbook
reports/AUS_Aviation_Financial_Model_Excel2019.xlsx - Chart set
reports/figures - Pipeline metrics
reports/pipeline_metrics.json
Other components
- Pipeline operator
Connections 27
- Pipeline operator → Pipeline runner: runs
README.md - Pipeline runner → Dataset generator: calls
run_pipeline.py - Dataset generator → Revenue data: generates
README.md - Dataset generator → CIP grant data: generates
README.md - Dataset generator → GL bank data: generates
README.md - Dataset generator → Debt schedule: generates
README.md - Pipeline runner → Revenue data: reads
run_pipeline.py - Pipeline runner → CIP grant data: reads
run_pipeline.py - Pipeline runner → GL bank data: reads
run_pipeline.py - Pipeline runner → Debt schedule: reads
run_pipeline.py - Pipeline runner → Revenue forecaster: calls
run_pipeline.py - Pipeline runner → Grant anomaly mining: calls
run_pipeline.py - Pipeline runner → GL bank reconciliation: calls
run_pipeline.py - Pipeline runner → Ratios and DSCR stress: calls
run_pipeline.py - Pipeline runner → Excel model builder: calls
run_pipeline.py - Pipeline runner → Executive charts: calls
run_pipeline.py - Pipeline runner → Excel workbook: writes
run_pipeline.py - Pipeline runner → Chart set: writes
run_pipeline.py - Pipeline runner → Pipeline metrics: writes
run_pipeline.py - Revenue forecaster → Excel model builder: feeds forecast
run_pipeline.py - Grant anomaly mining → Excel model builder: feeds scored grants
run_pipeline.py - GL bank reconciliation → Excel model builder: feeds tie-out
run_pipeline.py - Ratios and DSCR stress → Excel model builder: feeds DSCR
run_pipeline.py - Revenue forecaster → Executive charts: feeds predictions
run_pipeline.py - Grant anomaly mining → Executive charts: feeds scores
run_pipeline.py - GL bank reconciliation → Executive charts: feeds exceptions
run_pipeline.py - Ratios and DSCR stress → Executive charts: feeds simulations
run_pipeline.py