Ayman Elmarsfawy

01 / About

Who I Am

DataAnalyst

I'm Ayman Elmarsfawy, an MIS graduate specializing in data analytics. Over the past year, I've built end-to-end analytics projects — from SQL data extraction to Power BI dashboards — including a graduation project analyzing customer retention for a Brazilian e-commerce marketplace with 99K orders.

My workflow spans the full data pipeline: cleaning messy datasets in Python, writing SQL queries to extract insights, modeling data with Star Schema in Power BI, and communicating findings through executive dashboards and DAX measures.

I'm certified in Microsoft Power BI (PL-300) and Azure Data Fundamentals (DP-900), and I'm actively looking for a Junior Data Analyst role — on-site in Cairo or remote for Gulf-based companies.

Let's Work Together

0 Tools in My Toolkit

0 In-Depth Projects

● Open to Work

∞ Curiosity

02 / Education

Academic Background

Graduated · 2025

Bachelor of Business — Management Information Systems

Thebes Academy · Cairo, Egypt

MIS Data Analysis Information Systems Business Intelligence

03 / Skills

My Toolkit

Core Analysis

Excel

Pivot tables, advanced formulas, data modeling, and dashboards for business reporting.

Pivot Tables Formulas Reporting

SQL

Writing complex queries, joins, and aggregations to extract insights from large databases.

Queries Reporting Data Extraction

Python

Data cleaning and analysis using Pandas, Matplotlib, and Seaborn to process, explore, and visualize datasets.

Data Cleaning Analysis Automation

Visualization

Power BI

Interactive dashboards and business intelligence reports using DAX and Power Query.

Dashboards KPIs BI Reports

Supporting Tools

Power Query

Transforming and cleaning raw data with automated ETL pipelines inside Excel and Power BI.

ETL Data Transformation Automation

Google Sheets

Collaborative spreadsheets, formulas, and data analysis in the cloud.

Collaboration Analysis Tracking

Git & GitHub

Tracking project changes, managing versions, and collaborating on code using Git and GitHub.

Version Control Collaboration Tracking

Exposure / Learning

Tableau

Familiar with core visualization concepts and chart building. Actively expanding skills.

Familiar Learning

Looker Studio

Familiar with building basic reports and connecting data sources. Actively expanding skills.

Familiar Learning

04 / What I Offer

How I Can Help

Dashboard Building

Interactive dashboards that let teams track KPIs, monitor trends, and make faster decisions — all in one place.

Power BI Tableau Looker Studio

Data Cleaning & Analysis

Turning messy, raw data into clean, structured datasets ready for analysis — uncovering patterns that matter.

Python SQL Excel

Automated Reporting

Replacing slow, manual monthly reports with automated pipelines — saving hours of repetitive work every week.

Power Query Python Excel

Data Storytelling

Presenting data as a clear, visual narrative that non-technical stakeholders can understand and act on immediately.

Tableau Power BI Google Sheets

05 / Certifications

Credentials

Official Microsoft Certifications

Official Certification

PL-300

Power BI Data Analyst Associate

Microsoft · 2026

Verify Credential →

Official Certification

DP-900

Azure Data Fundamentals

Microsoft · 2026

Verify Credential →

Professional Training

🎓

Data Analysis & Business Intelligence Diploma

Tech Mind · 2026

Modules: Advanced Excel · SQL · Python · Power BI | 120 hours

06 / Projects

My Work

5 in-depth end-to-end projects

★ FEATURED PROJECT · Graduation Project

Olist Customer Retention Dashboard Preview

Graduation Project Python Power BI

Olist E-Commerce — Retention Crisis Analysis

End-to-end graduation project — Python pipeline (EDA, cleaning, validation) across 9 datasets (~99K orders, R$15.8M revenue), connected to a 4-page Power BI dashboard with 22+ DAX measures uncovering a critical 3.07% customer retention crisis.

99KOrders Analyzed

3.07%Retention Rate

R$14.6MLost Revenue Found

Power BI DAX Power Query

Global Sales Performance Dashboard

Interactive 6-page Power BI suite analyzing 4 years of global sales data across regions, product categories, and customer segments with custom sidebar navigation.

6Dashboard Pages

4Years of Data

5KPIs Tracked

Power BI DAX Retail Analytics

Carrefour Sales Dashboard

Executive-style Power BI dashboard analyzing Carrefour retail sales across cities, brands, and order channels with custom DAX measures and interactive drill-downs.

4KPIs Tracked

MultiCity Coverage

2Channels

SQL Server Power BI End-to-End

Domino's Pizza Sales Dashboard

End-to-end analytics pipeline — 22 SQL Server views answering 20+ business questions on revenue and operations, connected to a 3-page Power BI dashboard with a custom Domino's theme.

22SQL Views

20+Business Questions

4Core KPIs

Star Schema DAX Time Intelligence

Global Superstore BI Dashboard

4-page executive Power BI dashboard built on a Star Schema (Orders, Products, CRM, Locations) with Time Intelligence DAX measures for YoY Growth and Prior Year comparisons across 2011–2014.

4Dashboard Pages

StarSchema Model

YoYTime Intelligence