Nouramabrouk/Data-Jobs-Pulse-Egypt-Gulf

Data Analyst Job Market Analysis — Egypt & Gulf 2024 # Data-Jobs-Pulse-Egypt-Gulf Data Analyst Job Market Analysis — Egypt & Gulf 2024 # 📊 Data Jobs Pulse — Egypt & Gulf 2024 ## Project Overview Analysis of 40 real Data Analyst job postings across Egypt & the Gulf region, exploring market trends, in-demand skills, and salary benchmarks. --- ## 🛠️ Tools Used - **Excel Power Query** — Data cleaning & transformation - **Power BI** — Dashboard & visualization - **DAX** — Calculated measures & KPIs --- ## 🔍 Data Cleaning Challenges The raw data had several real-world issues that required fixing: - ✅ Duplicate rows (same job posted on multiple platforms) - ✅ Inconsistent text (data analyst / DATA ANALYST / Data Analyst) - ✅ Mixed date formats (2024-01-15 / 15/01/2024 / 03-02-2024) - ✅ Missing salary values (null) - ✅ Mixed currencies (EGP / AED / USD) - ✅ Inconsistent sector names (telecom / Telecom / TELECOM) --- ## 📈 Dashboard Pages ### Page 1 — Market Overview - Total Jobs, Companies, Sectors & Gulf Jobs % - Job distribution by Sector - Jobs by Experience Level - Job Volume by Source - Geographic distribution ### Page 2 — Skills Analysis - Top 5 In-Demand Skills - Skills Distribution by Industry Sector - Required Skills by Region (Egypt vs Gulf) ### Page 3 — Salary & Experience - Average Salary (EGP & AED) - Top Salary in the market - Average Salary by Job Title - Salary Comparison: Egypt vs Gulf - Highest Paying Sectors - Salary Growth by Experience Level --- ## 💡 Key Insights | Insight | Finding | | Most demanded skill | SQL — in 87% of postings | | Highest paying role | Senior BI Developer (33K EGP) | | Top hiring sector | Tech | | Gulf opportunities | 21% of all postings | | Salary range Egypt | 8,000 – 38,000 EGP | | Salary range Gulf | ~16,000 AED average |