B2B Sales Pipeline & Performance Analytics
B2B Sales Dashboard uncovering hidden risks behind $10M revenue — including 21% Win Rate drop and 73% product dependency
Ahmed Mamdouh Data Analyst
About Me
Data Analyst with hands-on experience in SQL, Python, Excel, and Power BI, focused on turning raw data into clear, actionable insights.
Skilled in data cleaning, analysis, and building interactive dashboards that support decision-making and uncover business opportunities.
Driven by curiosity and a problem-solving mindset, with a strong interest in delivering impactful data solutions.
My Projects
B2B Sales & Distribution Analytics Dashboard
End-to-end Power BI project analyzing B2B sales data with interactive dashboards and actionable business insights.
Real Estate Analytics Project
Real Estate Performance & Client Engagement Dashboard
Uncover the full story behind sales, client behavior, and agent productivity in the real estate market. Dive into actionable insights that drive revenue, optimize inventory, and enhance customer retention.
Uncover the full story behind sales, client behavior, and agent productivity in the real estate market. Dive into actionable insights that drive revenue, optimize inventory, and enhance customer retention.
Skills
Programming & Data Analysis
- Python (Pandas, NumPy, Matplotlib, Seaborn)
Databases
- SQL
Data Visualization & BI
- Power BI (Dashboards, KPIs, DAX)
- Excel (PivotTables, Charts, Power Query)
Core Analytics Skills
- Data Cleaning & Preparation
- Exploratory Data Analysis (EDA)
-
Statistical Analysi
Experience & Training
Power BI Specialist Trainee | Digital Egypt Pioneers Initiative (DEPI)
Jun 2025 – Dec 2025
- Built end-to-end Power BI dashboards for B2B sales analysis using Power Query and DAX
-
Designed star schema model and transformed raw data into structured insights
-
Tracked KPIs including $475K sales, 60% YoY growth, and 91% retention rate
-
Delivered insights on top products, markets, and sales performance
Data Science Intern | MAIM Digital Solutions
July 2025 – September 2025
- Completed end-to-end data science workflow (cleaning, EDA, modeling) using Python
-
Built classification models and K-Means clustering for student performance analysis
-
Performed feature engineering and evaluated models using standard ML metrics
-
Generated insights and recommendations for improving student outcomes
Data Analysis Intern – Uneeq Interns
May 2024
- Performed data cleaning and EDA using Python
- Built Power BI dashboards to visualize insights and trends
Education
B.Sc. in Computers and Data Science – Business Analytics Dept., Alexandria University (2022–2026)
Volunteering
Head of Public Relations |Robotics-FCDS
Dec 2023 – Oct 2024
• Led and coordinated a PR team, assigning tasks, setting priorities, and ensuring alignment with organizational objectives.
• Planned and delivered training sessions and presentations to onboard new members and enhanced internal communication standards.
Contact Me
My inbox is always open, you can contact me with the contact form here or with the details below:
Email: ahmedmamdouh29004@gmail.co,