Hi, I'm Ahmed Abdelgawad

A Data Analyst who transforms complex data into clear, actionable insights.

Ahmed Abdelgawad - Crafting Clarity From Complexity

About Me

I’m Ahmed Abdelgawad, a detail-oriented data enthusiast with a solid foundation in data analysis, visualization, and reporting. Skilled in Excel, DAX, Power BI, and Tableau, I have extensive experience sourcing raw datasets from platforms like Kaggle — covering financial companies, sales, and more — then cleaning, transforming, and turning them into interactive dashboards. My specialization lies in financial, sales, and banking, with a focus on delivering clean, accurate, and visually engaging reports that turn complex data into actionable insights.

Education

St. George Secondary School

High School | 2022

Arab Academy For Science, Technology and Maritime Transport (AASTMT)

Business Information System | 2022 - 2026

Skills and Tools

Technical Skills

  • Excel
  • Power BI
  • Tableau
  • Power Query/Pivot
  • SQL
  • PHP
  • Python
  • Java

Soft Skills

  • Analytical Thinking
  • Problem Solving
  • Team Collaboration
  • Attention to Detail
  • Time Management
  • Communication
  • Work Under Pressure

My Work

A Showcase of my work as a Data Analyst

Project 1: Candy Line Sales

These dashboards present candy line sales performance, highlighting key metrics such as total profit, total sales value, number of regions, total orders, number of customers, top state and city, and division performance. They also provide detailed breakdowns of product profitability, shipping modes, and regional profit distribution. The two designs demonstrate different layout and visualization approaches, both aimed at delivering clear, actionable insights for decision-making.

Candy Line Dashboard 1 Candy Line Dashboard 2

Project 2: Sales Performance

This dashboard offers a comprehensive view of sales performance, showing units sold, revenue before and after tax, and overall profit, while highlighting top states and cities. It combines geographic insights, package-type comparisons, and time-based trends to give decision-makers a clear understanding of sales patterns, growth opportunities, and key profit drivers.

Sales Performance Dashboard

Project 3: HR Analysis

This HR dashboard presents insights on 1,326 employees with a balanced gender split. It highlights top education fields, attrition by role (highest in Machine Learning and Engineering Managers), and performance ratings, where most meet or exceed expectations. The average manager rating is 10.4, and most employees are based in California. Salaries total 113 million, led by Senior Software Engineers, while departmental distribution shows Technology as the largest group, followed by Sales and HR.

HR Dashboard

Contact Information

Phone: +20 128 266 4850

Email: ahmedmohamedhany1234567@gmail.com

LinkedIn: linkedin.com/in/ahmed-abdelgawad-1abab8329