Abdelrahman Mohamed — Data Analyst

About Me

Data Analyst &
BI Specialist

I'm Abdelrahman Mohamed, a data analyst specializing in transforming complex raw data into clear, actionable insights. I help businesses make smarter data-driven decisions by building professional dashboards and performing in-depth analysis.

With expertise in SQL, Power BI, Excel, and Python, I bridge the gap between messy datasets and the business intelligence leaders need to act with confidence.

100K+

Records Analyzed

BI Projects Delivered

Tools Mastered

56%

Profit Margin Uncovered

Expertise

Core Skills

📊

Power BI

Interactive dashboards, DAX measures, KPI visualizations, and drill-through reports

🗄️

SQL

Complex queries, joins, aggregations, and large-scale data extraction from relational databases

📗

Excel (Advanced)

Power Query, Pivot Tables, advanced formulas, and automated reporting workflows

🐍

Python (Pandas)

Data cleaning, transformation, EDA, and visualization using Pandas, Seaborn, and Matplotlib

🧹

Data Cleaning

Standardizing messy datasets, handling nulls, outliers, and building transformation pipelines

📈

Dashboard Design

Business-ready visual storytelling with focus on clarity, interactivity, and executive readability

Work

Selected Projects

Project 01

Social Media Performance Dashboard

Built a multi-platform analytics dashboard tracking Facebook, LinkedIn, Instagram, and X (Twitter) performance. Covered impressions, reach, likes, engagement rates, and audience growth trends — enabling marketing teams to compare platform ROI side-by-side.

Power BI Excel Data Visualization

Instagram led engagement at 2.38%; X dominated with 737K impressions out of 2.34M total

2.34M

Total Impressions
Tracked

Project 02

Contoso Retail — Sales Analysis

Analyzed 100K+ customer records across 6 relational database tables for a multinational retail company using SQL Server, Python, and Power BI. Delivered a comprehensive BI pipeline revealing $219M+ in total sales — and crucially identified that the sales decline was driven by heavy discounting, not by a drop in order volume.

SQL Server Python Power BI

Root-cause analysis pinpointed excessive discounting as the revenue driver — not order decline

$219M

Total Sales
Analyzed

Project 03

S&P 500 Financial Dashboard

Designed an interactive financial dashboard covering 505 companies across 11 market sectors. Tracked total market cap, Median P/E ratio (19.45), average dividend yield (1.90), 52-week highs/lows, and market cap by company. Included valuation category segmentation: Core, Growth, and Extreme Growth.

Power BI DAX Financial Analysis

Sector breakdown with interactive drill-through — Apple leading in market cap across all sectors

505

Companies
Analyzed

Project 04

E-Commerce Sales Dashboard 2023–2024

Interactive sales dashboard analyzing e-commerce performance across 8 Arab countries (Egypt, Saudi Arabia, UAE, Morocco, Kuwait, Jordan, Tunisia, Iraq). Tracked total revenue, profit, return rates, customer ratings, and new vs. returning customer behavior — with monthly trend analysis across the full year.

Power BI E-Commerce Sales Analysis

Egypt led with $1.87M (29.44%) of total revenue; profit margin held steady at 49.75%

6.34M

Total Revenue
Analyzed

Abdelrahman
Mohamed

Data Analyst &
BI Specialist

Core Skills