Mahmoud Elmahdy - Data Analyst

About Me

Data Analyst with 3+ years of experience transforming complex data into strategic insights that drive business decisions. Proven expertise in building dashboards and reports using Excel, SQL, and Power BI to support cross-functional teams and strategic planning initiatives. Demonstrated success in ensuring data accuracy, streamlining workflows, and delivering actionable recommendations that improve operational efficiency by up to 30%.

View My Resume

120+ Projects
Completed

3+ Years
Experience

30+ Clients

23+ Client
Reviews

Technical Skills

Database & Analytics

SQL MySQL PostgreSQL Data Modeling ETL Processes

Programming

Python Scikit-learn TensorFlow Pandas NumPy Matplotlib Seaborn

Visualization

Excel Power BI Tableau Dashboard Design Reporting

Automation

Process Automation Report Automation Data Pipeline Workflow Optimization

Soft Skills

Analytical Thinking Problem-Solving Communication Adaptability Resilience Relationship Management Well-Being

Professional Experience

Data Analyst

Khamsat and Mostaql (Freelance Platforms)

09/2021 - Present

Designed and delivered over 70 dashboards using Excel and Power BI, enabling clients to make data- driven decisions across multiple departments.
Collaborated with cross-functional stakeholders to identify business trends and patterns, translating complex data into actionable insights.
Built Excel reporting frameworks enhanced client decision-making efficiency by over 30% through consistent data accuracy and validation protocols.
Developed automated reporting mechanisms using Excel Pivot Tables and VBA, reducing processing time by 50%..
Collected, cleaned, and analyzed data from multiple sources, maintaining database integrity and ensuring data quality standards.
Supported strategic planning initiatives by providing data-driven insights on customer behavior, sales performance, and operational metrics.
Maintained and optimized client databases, ensuring data accuracy and availability for reporting needs.

Featured Projects

GitHub All Projects

Data Warehouse and Analytics Project

Building a modern data warehouse with SQL Server using Medallion Architecture (Bronze, Silver, Gold layers). Includes ETL processes, data modeling, and analytics for customer behavior, product performance, and sales trends.

SQL Server ETL Data Modeling Data Analytics Data Warehouse

GitHub

Sales Analytics Dashboard

Comprehensive sales performance dashboard featuring KPI tracking and trend analysis, allowing us to identify trends and determine which products are the most profitable.

Power BI ETL Dax Data Modeling

Big Mart Sales Dashboard

An interactive dashboard analyzing Big Mart's sales data to uncover performance trends and identify the primary drivers of revenue across different products and outlets.

Power BI ETL Dax Data Modeling

Report GitHub

Finding Donors for Charity

This project involved a comparative analysis of supervised learning algorithms from the scikit-learn library. I developed a framework to evaluate and contrast the performance of various models, providing insights into their practical application and the critical skill of selecting the most suitable algorithm for a given machine learning task.

Python Scikit-learn Pandas NumPy Matplotlib Feature Engineering

GitHub

Bikes Market EDA

Exploratory data analysis on bikes market data to uncover trends, patterns, and insights. Analyzing market dynamics, pricing, and customer preferences using data analysis techniques.

Python EDA Pandas Data Visualization

GitHub

SQL User Journey Analysis

An advanced MySQL project extracting and concatenating website user journeys for paying customers to analyze conversion funnels. Built using CTEs, Window Functions, and GROUP_CONCAT.

MySQL Window Functions CTEs Data Analysis

GitHub

View All Projects