Projects

HR Attrition Analytics · End-to-End Case Study

Power BI (PBIP · TMDL) · DAX · SQL · Python · Excel

End-to-end case study on 1,470 employees — star-schema model, 31 DAX measures, a live what-if simulator, an interactive web dashboard, and a costed retention plan.

Enterprise Data Quality Platform · Production

SQL Server · 828 automated checks · DAMA-DMBOK · Evidence drill-down

828 automated SQL checks over 726 tables / 256M rows, scoring 8 DAMA-aligned dimensions with row-level evidence drill-down and daily digests to leadership.

IT Asset & Supply Management · Production

React · Node.js · PostgreSQL · QR deep-links · PDF automation

1,174 real assets migrated from a legacy system, a printable QR sticker per device linking to its full history, and custody receipts auto-emailed to Finance as PDFs.

Industrial Training-Quality Audit · National

Power BI · DAX · Power Query · Star Schema

A national training-quality field-audit for the Federation of Egyptian Industries (Dual Education) — 240+ industrial facilities and ~5,000 students across 166 schools and 17 governorates. And it's only phase one of a platform built to scale nationwide.

PepsiCo Pulse BI · Live

JavaScript · Chart.js · NLP model · EN/AR

A single-file EMEA BI portal: five interactive dashboards, live slicers, and a bilingual (EN/AR) NLP assistant that filters everything from a sentence.

Transactions & Supply Chain Analytics · Production

Power BI · Node.js · SQL Server · DAX · Express.js

Two production systems — a Node.js donor-intelligence platform and a Power BI supply-chain dashboard — on an indexed SQL Server backend that cut query time from minutes to seconds.

HR Analytics & Workforce Intelligence

Power BI | SAP | DWH | DAX | HR KPIs

End-to-end HR analytics solution for a retail chain with 470+ branches. Covers HC/FTE tracking, resignation analysis, insurance claims, workforce planning vs. actual with DOD performance evaluation. Data for demonstration only.

E-commerce Logistics Performance Analysis

Power Query | KPIs | Recommendations based on Insights

Vodafone EG Technical Assessment - A Case Study that simulates real-life data for e-commerce logistics operations. working with Orders, Deliveries, and Products.

ITI Examination & Business Intelligence System

ERD | Mapping | SQL | SSIS | DWH | SSRS | Power BI

A revolutionary end-to-end solution designed to transform how ITI manages its academic operations. not just building a database - we're crafting a complete ecosystem that handles everything from student registration to advanced business intelligence.

US Airlines Delay Analysis

Power BI | Modeling | SQL

Comprehensive analysis of flight delays, uncovering patterns, identifying root causes, and highlighting KPIs related to airline and airport efficiency.

Egyptian Mobile Store Sales Analysis

Excel | DAX

An end-to-end sales analytics solution analyzing 160M+ EGP across 12+ branches. Developed 15+ DAX measures and uncovered key business insights.

Superstore Sales & Customer Analytics

Tableau

KPIs, trends, and product/customer insights with drill-down capabilities.

Tableau Details

Sales & Customers Analytics

Power BI | Modeling | DAX

Comprehensive sales analytics, featuring DirectQuery implementation, Data Modeling, advanced DAX measures, and interactive visualizations.

PowerBI project (Sales Company)

Power BI | DAX

Dynamic dashboards with clean data transformation for real-time insights.

Egyptian Grocery Market Basket Analysis

Python | Pandas | Apriori algorithm

Association rules with support, confidence, lift metrics. Network graph for top 20 rules.

Smart Upper-Exoskeleton for Patients with Paralysis

Computer Vision | Speech Recognition | Team Leader

YOLOv7 detection, Mask RCNN segmentation, and Whisper OpenAI voice recognition.

Sales & Customers Dashboard

Excel | DAX

Sales efficiency analytics with performance, segmentation, and profitability insights.

Diabetes Prediction (Web App Based on ML)

Data Preprocessing | Machine Learning | Model Deployment

Preprocessed data and trained a Random Forest model (85% accuracy). Deployed the model using Flask for real-time predictions.

Signature Restoration

Image Preprocessing | Matlab