MahmoudHossamAi/Egypt-Public-Investment-Development-Needs-Analysis

An end-to-end data analytics project exploring public investment patterns, sector distribution, and development perspectives across Egyptian governorates using Python, SQL, Power BI, and DAX. # Egypt Public Investment & Development Needs Analysis ## Turning Public Investment Data into Development Insights Python • SQL • Power BI • DAX • Data Analytics ------------------------------------------------------------------------ ## Project Overview This project represents my first end-to-end Data Analytics project, applying Python, SQL, Power BI, and DAX to explore real-world development data. As a **Public Policy and Information Systems (PPIS) student** building my path in **AI & Data Science**, I wanted to connect technical analysis with real-world decision-making. The project explores public investment patterns across Egyptian governorates and sectors, focusing on investment distribution, geographic patterns, and development perspectives. ------------------------------------------------------------------------ ## Main Question **How is public investment distributed across Egyptian governorates and sectors, and how can analytical perspectives help understand development patterns?** ------------------------------------------------------------------------ ## Objectives - Analyze public investment distribution. - Explore sector investment patterns. - Understand geographic concentration. - Compare investment with population perspectives. - Evaluate sector coverage and investment intensity. - Build an interactive Power BI dashboard. ------------------------------------------------------------------------ ## Tools & Technologies Tool Usage ---------- --------------------------------------------- Python Data preparation, exploration, and analysis SQL Analytical queries and KPI extraction Power BI Dashboard development and visualization DAX Analytical measures and KPIs ------------------------------------------------------------------------ ## Workflow Data Understanding ↓ Data Preparation & Exploration (Python) ↓ SQL Analysis ↓ Power BI Dashboard Development ↓ Insights & Interpretation ------------------ …