Junior Data Analyst · Obour, Egypt

Mohab
Ahmed
Higazy

Transforming raw data into meaningful insights. Experienced with end-to-end data pipelines — from messy Data to interactive dashboards that drive decisions.

View Projects ↓ Download CV Get In Touch
$629M Sales Analyzed
12 Projects Built
4 Tools Mastered
01

Experience

Data Analyst Intern
Dec 2025 – Jan 2026
Semicolon Codes · Cairo, Remote
02

Projects

📊
MB1 Company Sales Analysis
Excel · Power Query . Pivot Tables · Power Pivot · DAX
Built a star schema data model across 5 interrelated tables. Engineered DAX measures for Revenue, Net Sales, and Profit scoped to delivered orders only.
$629.6M net sales · $86.6M profit · 64% from Electronics
View on GitHub
🗄️
Store Database – SQL Analysis
Microsoft SQL Server
Designed and implemented a normalized relational database with 4 tables. Wrote complex queries using JOINs, GROUP BY, and aggregations to analyze customer data and revenue.
4 tables · Full normalization · Revenue analytics
View on GitHub
📈
AdventureWorks Analytics
Power BI · Power Query · DAX
Modeled multi-table sales data in Power BI. Identified peak sales months (Jan, May, Jun, Dec), flagged 10 low-profit products, and delivered geospatial insights by region.
Time series · Geospatial maps · Profitability charts
View on GitHub
🐍
ShopNile — End-to-End Pipeline
Python · Pandas · Streamlit · Plotly
Full data pipeline from raw messy data to a live interactive dashboard. Covered 4 datasets — 500 customers, 120 products, 3,000 orders, 3,050 payments. Deployed publicly on Streamlit Cloud.
🚀 Live on Streamlit Cloud · End-to-end delivery
View on GitHub
03

Skills

Tools & Platforms
Excel Power BI SQL Microsoft SQL Server MySQL PostgreSQL Python Tableau IBM Cognos Analytics Looker Studio Machine Learning
Excel & Power BI Skills
Excel Functions Microsoft Power Query M Formula Language Power Pivot DAX Pivot Tables
SQL Skills
Relational Databases Database Design Data Modeling Data Schemas Joins Set Operations Window Functions Subqueries CTEs
Python Libraries
Pandas NumPy Matplotlib Seaborn Plotly Streamlit Scikit-learn Regex (re)
Data Skills
Data Cleaning Data Transformation Data Modeling Data Visualization Exploratory Analysis Report Design KPI Dashboards
04

Certifications

DataCamp
Excel Fundamentals
Dec 2025
DataCamp
Data Analysis with Excel Power Tools
Jan 2026
DataCamp
Data Analyst in Power BI
Apr 2026
DataCamp
Data Analyst in SQL
In Progress
Coursera · IBM
IBM Data Analyst Professional Certificate
In Progress
05

Contact

Let's work
together.

I'm open to internships, junior analyst roles, and freelance data projects. If you have a dataset that needs turning into insights — let's talk.

✉️
mohab.ahmed.ntss@gmail.com
📞
+20 103 307 9606
💼
linkedin.com/in/mohabhigazy