Skip to content
View ahmedmamdouh29004's full-sized avatar

Block or report ahmedmamdouh29004

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
ahmedmamdouh29004/README.md

👋 Hi there, I'm Ahmed Mamdouh


🚀 About Me

Data Analyst focused on translating business problems into analytical solutions using data exploration, visualization, and reporting.


🛠️ Skills


📊 Projects

Power BI DAX Power Query GitHub: [Repo Link]

  • Built a Power BI dashboard analyzing 8,800 B2B sales opportunities across a full CRM pipeline
  • Developed 15+ DAX measures for KPIs, time intelligence, and performance segmentation
  • Identified 21% win rate drop in Q2 despite revenue peaking at $3.1M, revealing hidden pipeline inefficiencies
  • Discovered key risks: 11.5% dependency on a single agent and 73% revenue concentration in GTX product line

Power BI DAX Power Query

GitHub: Repo Link

  • Tracked $1.54B total sales with 40% conversion rate and 21.4% YoY growth
  • Key finding: 71.9% of sales happened on weekdays; properties 350–500 m² were highest demand — used to guide agent scheduling and inventory strategy
  • 52% repeat buyer rate tracked via DAX retention measures

Power BI DAX Power Query Team Lead

GitHub: Repo Link

  • Led a 5-member team to define KPIs and deliver 7 interactive dashboards tracking $475K revenue and 60.31% YoY growth across sales, customers, products, shipping, and geography
  • Designed a 7-table Star Schema and developed 30+ DAX measures covering time intelligence, customer retention (91.86%), segmentation, and geographic performance — achieving $5.34K average sales per customer
  • Identified that 81.68% of sales are international across 21 countries, with the USA and Germany contributing 34% of total revenue, translating insights into a data-driven market expansion roadmap

Python Pandas Matplotlib Seaborn GitHub: [Repo Link]

  • EDA on 6,800+ film records analyzing revenue, votes, and IMDb score distributions
  • Animation & Family genres generate 45–60% higher average gross than other categories
  • Marvel outperforms the industry average by 25%+; 8.0–9.0 IMDb range = peak revenue segment

📫 Connect with Me


⭐ Open to Data Analyst & Business Intelligence opportunities

Pinned Loading

  1. Excel-Projects Excel-Projects Public

  2. PowerBI-Projects PowerBI-Projects Public

  3. Python-Projects Python-Projects Public

    A collection of Python projects for data analysis and exploration

    Jupyter Notebook