Mahmoud Elmahdy - Data Analyst

About Me

Results-driven Data Analyst & BI Consultant with 3+ years of experience specializing in Advanced Excel, Power BI, and SQL. Across 120+ freelance projects and corporate roles at SGS, I build automated reporting systems and dashboards that cut manual processing time by up to 90%. Bilingual in English and German, I am passionate about translating complex data into actionable business value.

View My Resume

120+ Projects
Completed

3+ Years
Experience

30+ Global
Clients

20+ 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 & BI Consultant

SGS – Saudi Ground Services (Remote / Freelance)

03/2022 - 05/2023

Analyzed passenger load, boarding, and delay data across 3 daily shifts during Hajj season — enabling strategic staff reallocation without new hiring costs.
Identified operational bottlenecks through statistical modeling, reducing passenger wait times and cutting flight delay costs by 20%+ per shift.
Built a multi-module Excel KPI dashboard and PowerPoint presentation for real-time ground operations monitoring; automated reporting pipeline from 10 days to 1 day.
Facilitated stakeholder workshops to translate complex data into actionable process redesigns and sustainable operating models.

Data Analyst – Freelance

Khamsat & Mostaql (International)

09/2021 - Present

Designed 120+ end-to-end analytics projects for 30+ clients: dashboards, ETL pipelines, KPI reporting, and process automation across multiple industries.
Built 70+ Power BI & Excel dashboards; engineered VBA/Power Query automation that cut manual processing time by 50% across client workflows.
Conducted root cause analysis on operational data, translating complex findings into clear recommendations and data-driven process redesigns.
Maintained 20+ verified 5-star reviews reflecting consistent delivery quality, clear communication, and business-focused outcomes.

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

SGS - Mega-Event Operations & Hiring Automated Report (Client Project)

A centralized Excel data model aggregating massive volumes of operational and hiring data for the Hajj season, with automated PowerPoint integration for real-time executive reporting of charts, hiring progress, and budget KPIs.

Advanced Excel Data Aggregation PowerPoint Automation Dynamic Linking

SAR - Excel Automation Suite (Client Project)

Devised a 4-system Excel automation suite for SAR's engineering and operations teams. Built an ECR management system with Gantt chart timeline, automated overdue alerts, and developed systems for RCA tracking and asset task management.

Advanced Excel VBA Forms Automation Gantt Charts

Omnichannel Marketing Dashboard (Client Project)

An interactive Excel dashboard analyzing omnichannel digital marketing performance and paid advertising metrics specifically tailored for the travel and tourism industry.

Excel Marketing Analytics Paid Ads Dashboard Design

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

Featured Articles & Posts

My latest insights on data analytics, business intelligence, and automation.

Medium Article

Preview blocked by local browser settings.

Read on Medium

From Raw Data to Comprehensive Insights in One Line

LinkedIn Post

Preview blocked by local browser settings.

View on LinkedIn

Client Reviews

What my clients say about my work and dedication to delivering exceptional results.

⭐ Khamsat Client Reviews

Khamsat Platform 11 Reviews 5-Star Rated

A collection of 11 verified client reviews from the Khamsat freelancing platform, showcasing consistent 5-star feedback on Excel dashboards, data analysis, and reporting projects.