Projects
A sample of the projects I've been working on
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.
Freelance BI Solution · Ongoing
Power BI | Power Automate | DB
A full-scale freelance BI engagement with a major corporation — covering data design, dashboarding, and process automation. Sample & details dropping soon. 👀
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.
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.
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.
