AinomugishaA/Kampala-EMobility-Transit-Analysis

An end-to-end data project using MySQL, Python, and Power BI analyzing electric vehicles vs. petrol bikes in Uganda. # Kampala E-Mobility Transition Study: Petrol vs. Electric An end-to-end data analytics project evaluating the economic and environmental (climate) impacts of transitioning from internal combustion engine (ICE) petrol Boda Bodas to clean, hydro-powered electric motorcycles in Kampala, Uganda. ## Interactive Executive Dashboard *Take a high-resolution screenshot of your beautiful Power BI dashboard and drag/drop the image file right onto this line in your GitHub editor box to insert it automatically!* --- ## Project Tech Stack * **Database:** MySQL (Relational Schema Design & Data Modeling) * **Data Pipeline:** Python / Jupyter Notebooks (Pandas & Seaborn Visualization) * **Business Intelligence:** Power BI (Advanced DAX Metrics & Dark-Theme UI/UX) --- ## Core Data Insights * **85% Operating Cost Drop:** Electric motorcycles cost roughly **UGX 2,132** per day to operate compared to **UGX 15,349** for conventional petrol variants under baseline Kampala fuel pumps and domestic electricity tariffs. * **99% Carbon Footprint Mitigation:** Driven by Uganda's highly renewable, hydro-dominant national electricity grid, charging an EV motorcycle produces near-zero emissions (~42g CO₂ daily) compared to burning fossil fuels (~5,583g CO₂ daily). * **Economic Impact:** Choosing an electric motorcycle over petrol saves an average Kampala delivery/Boda rider over **UGX 66,000** within just a 5-day operational tracking loop. --- ## Repository Contents * `schema.sql`: Production script initializing the relational tables, data constraints, and baseline Ugandan pricing tracking indicators. * `Uganda_EMobility_Analysis.ipynb`: Python connection pipeline executing automated calculations and tracking statistical plotting metrics. * `Uganda_EMobility_Dashboard.pbix`: Interactive, production-ready Power BI dashboard optimized for executive reporting. --- *Developed as a portfolio showcase asset by Ainomugisha Andrew. Connect with me on LinkedIn!*