AinomugishaA/uganda-airlines-fleet-expansion-analytics

An end-to-end MySQL and Power BI framework modeling the commercial profitability and macroeconomic GDP impact of Uganda's 2026 aircraft procurement. # Uganda Airlines Fleet Expansion: Economic Impact & Route Profitability Framework ## Project Overview On June 10, 2026, Uganda Airlines finalized a landmark Shs 3.7 Trillion ($982 Million) procurement deal with Boeing for 10 new aircraft. This project develops an end-to-end data pipeline (MySQL to Power BI) that models the commercial profitability of this fleet injection and simulates its macroeconomic multiplier effect on Uganda's national GDP. ## Tech Stack & Skills Showcased - **Database Engineering**: MySQL (Schema creation, DDL/DML execution, relational constraints). - **Macroeconomic Modeling**: Applied an operational 2.1x GDP multiplier against air tourism and cargo export lane vectors. - **Business Intelligence**: Power BI Desktop, DAX optimization (`SUMX` row-by-row iterators), interactive canvas design with high-readability custom grids. - **Autonomous Systems Link**: Strategic framing of middle-mile cargo logistics integration using autonomous drone flight paths. ## Core Analytical Insights Found - **Direct Commercial Profitability**: The incoming fleet scales operations sustainably, yielding an estimated **$14.00 Million** in net direct annual operating profits. - **Macroeconomic Value Added**: The structural injection of passenger and cargo capacity generates **$512.40 Million (Shs 1.92 Trillion)** in total annual value-added to Uganda's GDP. - **Logistical Asymmetry**: Cargo trade value heavily dominates the Guangzhou and Jeddah lanes, vindicating the strategic decision to include dedicated Boeing freighters to correct regional trade deficits.