aviation-analytics

This project develops a machine learning pipeline to analyze and predict air traffic trends using historical aviation data.

Full-stack Aviation BI Dashboard: A Docker-deployed Metabase instance utilizing SQL to monitor Astra aircraft fleet health. Features a 'Maintenance Command Center' tracking 4,200+ airframe hours, fuel efficiency, and real-time alerting for engine component inspections (ATA 72/73) within a 50-hour critical window.

Collection of interactive Tableau dashboards showcasing data visualization expertise across entertainment, real estate, and aviation industries. Features Netflix content analysis, housing market trends, and British Airways customer satisfaction metrics with advanced filtering and drill-down capabilities.

Data analytics applied to aviation operations — punctuality, traffic, fares, and MRO KPIs

PySpark-based analytics project exploring U.S. flight delays, cancellations, route performance, and airport trends through data visualization and interactive dashboards.

End-to-end flight analytics dashboard featuring API integration, SQLite data modelling, dynamic SQL filtering, and interactive Streamlit visualizations.

End-to-end U.S. flight reliability analytics platform with Python ETL, PostgreSQL star schema, SQL analytical views, data-quality validation, and Power BI dashboards.

An end-to-end, containerized data pipeline built with Apache Airflow and PostgreSQL to track commercial aviation reliability. Utilizing a strictly typed Star Schema, it ingests flight events to calculate auditable, industry-standard A15/D15 On-Time Performance (OTP) and Completion Factor metrics for fact-backed reporting.

Data analytics and forecasting system to predict passenger traffic, detect bottlenecks, and optimize airport operations.

SQL Server data analytics project analyzing air traffic passenger trends, airport performance, airline activity, and travel demand using SQL for business insights.

Workforce management tool for predicting ground handling delays and optimizing staff allocation for airport operations.

Interactive dashboard for analyzing Vietnam's aviation sector. Built with React, TypeScript, D3.js, and Python. Visualizes flight density, pricing trends, passenger routes, and airline metrics. Ideal for travelers, airline strategists, and policymakers.

USA flights analysis

✈️ FlightWise AI is an end-to-end Machine Learning project that predicts flight delays using XGBoost and aviation analytics. Features advanced feature engineering, model comparison, interactive Streamlit dashboards, delay risk prediction, and operational recovery recommendations.

A QGIS Plugin to calculate overflight count contours. Calculations are based on the "Definition of Overflight" (CAP 1498) by the UK Civil Aviation Authority (CAA).

Local Generative AI prototype for operational risk analysis and executive reporting using Ollama, Docker, and Open WebUI.

Portside is a cloud-based business aviation management software company headquartered in Cary, North Carolina, serving corporate flight departments, charter and managed fleets, fractional and aircraft management companies, business jet owners, and government and military aviation across more than 30 countries.

Interactive Power BI dashboard analysing 34M U.S. flights across airline, airport, cancellation, diversion, and delay-cause performance from 2017–2022.

Auditing minimum connection time standards at U.S. hub airports using BTS On-Time Performance and DB1B data. January 2019, Python.

This project focuses on the intersection of real-time data engineering and aviation analytics. Built to bridge the gap between raw API streams and structured data insights, it tracks global flight movements, schedules, and historical data while navigating the technical challenges of external API management.