AHMED ELMAGHAWRY
Loading the analysis workspace
Available for freelance & full-time roles

I read your data
before it becomes a decision.

Data Analyst working across Excel, SQL, Python and Power BI — cleaning messy datasets, finding the patterns hiding in them, and building dashboards people actually use to make calls.

Giza, Egypt — open to remote work
sales_overview.pbix
+18%
Revenue MoM
4.2k
Orders
92%
Data Quality
Retail
Online
Other
Ahmed Elmaghawry
Ahmed Elmaghawry
Data Analyst
About

Turning raw, messy datasets into decisions people can act on.

I'm a Data Analyst who works across the full lifecycle of a dataset — from the first messy CSV export to the final dashboard someone opens every Monday morning. Most of my time isn't spent making charts; it's spent cleaning data, fixing inconsistent formats, removing duplicates, and making sure the numbers can actually be trusted before anyone builds a decision on top of them.

Once the data is reliable, I look for the patterns that matter — trends over time, customer segments, peak periods, underperforming products — and translate them into a small number of clear insights instead of a wall of numbers. I build that into interactive Power BI dashboards and Excel reports that let non-technical stakeholders explore the data themselves.

My background in Computer Science shaped how I approach this: I query with SQL, script the heavier analysis in Python with Pandas and NumPy, and always keep one question in front of me — what decision does this number need to support?

Focus
Data cleaning → analysis → dashboards
Core Tools
Excel · SQL · Python · Power BI
Education
B.Sc. Computer Science, 2026
Based in
Giza, Egypt · Remote-friendly
Skills

What I actually do with data.

Grouped by how each skill gets used in a real project, not just listed as buzzwords.

Data Analysis

Getting from raw rows to a reliable answer.
Data Cleaning & Wrangling
Fixing duplicates, missing values and inconsistent formats before any analysis starts.
Exploratory Data Analysis
Profiling a dataset to understand distributions, outliers and relationships early.
Statistical & Trend Analysis
Reading seasonality, growth and change over time, not just point-in-time numbers.

Business Intelligence

Connecting numbers to business questions.
KPI Analysis
Defining and tracking the metrics that actually reflect performance.
Business Insights
Framing findings around what a manager can act on, not just what's interesting.
Dashboard Development
Building dashboards stakeholders can filter and explore on their own.

Data Visualization

Making the right chart for the right question.
Power BI Reports
Interactive reports with drill-downs, filters and data modeling behind them.
Excel Visualization
PivotTables and charts built for quick, self-serve reporting.
Python Charting
Matplotlib visuals for deeper exploratory work during analysis.

Programming & Querying

The languages that do the heavy lifting.
SQL
Writing queries to aggregate, join and validate data across tables.
Python (Pandas, NumPy)
Scripting cleaning and analysis steps that need to run repeatedly.

Tools

Where the work actually happens.
Excel — PivotTables, VLOOKUP
Fast, structured analysis for day-to-day reporting needs.
Power BI — Power Query, Modeling
Building the data model that a dashboard sits on top of.
MySQL / Microsoft Access
Storing and querying structured data at the source.

Approach

How I work, not just what I use.
Analytical Thinking
Breaking a vague business question into something measurable.
Attention to Detail
Catching the small data errors that quietly break an analysis.
Communication
Explaining findings in plain language, not just SQL and formulas.
Projects

Case studies, not just dashboards.

Each project below moved from a raw, unreliable dataset to a specific business question being answered.

01

E-Commerce Sales & Customer Analysis

End-to-end analysis of an e-commerce transactional dataset, from raw export to a Power BI report on revenue and customer behavior.

ExcelSQLPython (Pandas, NumPy)Power BI
Business Problem
The raw transactional export had duplicate orders, missing values and inconsistent formats — making revenue and customer numbers unreliable before any analysis could begin.
What I Analyzed
  • Cleaned and prepared the raw dataset to build a reliable analysis base.
  • Wrote SQL queries to aggregate revenue, order volume, and customer segments.
  • Identified top-performing products and categories.
Key Insights
[Add the specific revenue trend, top category, or customer segment finding once you confirm the final numbers you want to share publicly.]
Outcome
A Power BI report giving a clear, filterable view of revenue, order volume and top-performing products for faster decision-making.
02

Pizza Sales Performance Dashboard

Analysis of restaurant order data to uncover demand patterns across time, day and product size.

ExcelSQLPower BI
Business Problem
Order data needed to be validated and structured before the business could understand when demand peaks and which products actually sell.
What I Analyzed
  • Cleaned and structured order data using Excel PivotTables and VLOOKUP.
  • Used SQL to analyze order trends by time of day, day of week, and pizza category/size.
  • Designed a Power BI dashboard visualizing revenue, order volume and product mix.
Key Insights
Clear peak order windows and a consistent best-selling category/size mix emerged once the data was structured — [add the specific peak hours and top sellers you want to publish].
Outcome
A dashboard the business can use to plan staffing around peak hours and prioritize inventory for best-selling items.
03

Online Sales Performance Analysis

Statistical and exploratory analysis of online store sales data to identify trends, seasonality and outliers.

Python (Pandas, Matplotlib)SQLPower BI
Business Problem
Sales data was spread across multiple tables with no consolidated view of seasonality, outliers or true sales drivers.
What I Analyzed
  • Performed exploratory and statistical analysis in Python to identify sales trends, seasonality and outliers.
  • Queried and joined multiple SQL tables (orders, products, customers) into a consolidated dataset.
  • Visualized key metrics in Matplotlib during exploration, then built a final Power BI report.
Key Insights
[Add the specific seasonal pattern or outlier finding you'd like featured here once confirmed.]
Outcome
Findings translated into recommendations aimed at improving sales and customer retention.
Live Demo

A Power BI–style dashboard you can actually filter.

Sample retail dataset — change the year range or toggle a group below and every card, chart and KPI recalculates live.

Groups
Better data. Smarter decisions.

Business Performance Overview

Sample dataset · Interactive demo
Total Sales
Target
Profitability
Total Cost
Total Profit

Total Sales

by Year

Total Sales

by Category

Sum of Cost

by Group

Sales vs Target

Progress
Services

How I can help your team or business.

Practical, scoped work — you'll always know exactly what you're getting.

Data Cleaning

I take messy, duplicated or inconsistent raw data and turn it into a dataset you can actually trust and build on.

You get: a clean, validated dataset ready for analysis.

Excel Analysis

PivotTables, formulas and structured reporting for teams that need fast, reliable answers without a full BI setup.

You get: an Excel workbook with clear, reusable reports.

Power BI Dashboards

Interactive dashboards built on a proper data model, so you can filter, drill down and explore your own numbers.

You get: a live, interactive Power BI dashboard.

SQL Analysis

Writing and optimizing queries to pull the exact answers you need out of your database — no more manual spreadsheet exports.

You get: documented queries and the results you asked for.

Python Data Analysis

For deeper or repeatable analysis — exploratory work, statistical checks and automated cleaning scripts using Pandas and NumPy.

You get: a reproducible analysis script and findings summary.

KPI Reporting

Defining the metrics that actually reflect your business, then building the reporting that tracks them consistently.

You get: a KPI framework and a recurring report format.
Workflow

How I handle a data analysis project.

The same six steps, every time — it's what keeps the results reliable.

01

Understand

Getting clear on the actual business question before opening a single spreadsheet.

02

Clean

Removing duplicates, fixing formats and handling missing values so the data can be trusted.

03

Explore

Profiling the dataset to understand its shape, distributions and early red flags.

04

Analyze

Running the SQL queries and Python analysis needed to actually answer the question.

05

Visualize

Building the dashboard or report so the findings are easy to explore, not just read once.

06

Deliver

Walking through the insights and making sure the people using the dashboard know how to read it.

Tools

The stack behind the analysis.

XLS
Excel
PBI
Power BI
SQL
SQL / MySQL
PY
Python
PD
Pandas
NP
NumPy
MPL
Matplotlib
TBL
Tableau
Under the Hood

What the analysis actually looks like.

Illustrative snippets in the style of my real workflow — cleaning in Python, aggregating in SQL, reporting in Excel.

clean_sales.py
import pandas as pd df = pd.read_csv("orders_raw.csv") df = df.drop_duplicates() df["order_date"] = pd.to_datetime(df["order_date"]) df["revenue"] = df["revenue"].fillna(0) # group by month, sum revenue monthly = df.groupby(df["order_date"].dt.to_period("M"))["revenue"].sum() print(monthly.tail())
Output
order_daterevenue
2024-08184,320
2024-09201,760
2024-10179,940
2024-11228,510
top_categories.sql
SELECT c.category_name, SUM(o.quantity * o.unit_price) AS total_sales, COUNT(DISTINCT o.order_id) AS orders FROM orders o JOIN products p ON p.product_id = o.product_id JOIN categories c ON c.category_id = p.category_id WHERE o.order_date BETWEEN '2024-01-01' AND '2024-12-31' GROUP BY c.category_name ORDER BY total_sales DESC LIMIT 5;
Output
category_nametotal_sales
Beverages96,410
Snacks81,225
Dairy67,940
kpi_report.xlsx
fx=SUMIFS(Sales[Revenue],Sales[Category],"Beverages")
ABC
1CategoryRevenueGrowth
2Beverages96,410+12%
3Snacks81,225+6%
4Dairy67,940-3%
PivotTable summary, built for a weekly report
Resume

Want the full breakdown of my experience?

My CV covers my technical skills, certifications and project details in full. Download the PDF directly, or email me if you'd prefer I send it over.

Download CV Email Me
Credibility

Where the skills come from.

[+]
Hands-on projects covering e-commerce, retail and online sales data
4
Core tools used end-to-end: Excel, SQL, Python, Power BI
3
Certifications in data analysis, IT fundamentals and web development
B.Sc.
Computer Science — Capital University, 2026
Data Analysis Program
AMIT Learning
ICDL Certificate
MCIT
Full Stack Web Development
Russian Cultural Center
Contact

Have a dataset that needs a second look?

Whether it's a one-off analysis, a recurring dashboard, or a full-time role — I reply within a day. Reach me directly, no forms in between.