Profile
Management Information Systems graduate with a passion for turning raw data into clear, actionable stories. Detail-oriented, curious, and driven to help organizations make smarter decisions. Currently seeking a junior Data Analyst role.
Education
Bachelor of Business — Management Information Systems
Thebes Academy · Cairo, Egypt
Graduated · 2025
Projects
- Built an end-to-end pipeline in Python (EDA, cleaning, PK/FK validation) across 9 datasets (~99K orders, R$15.8M revenue) for a Brazilian e-commerce marketplace (2017–2018).
- Designed a 4-page Power BI dashboard with 22+ DAX measures including Retention Rate %, Lost Revenue Potential, and Delivery Experience on a validated Star Schema model.
- Uncovered a critical 3.07% retention rate representing R$14.6M in lost revenue — tracing root causes to avg 10.6-day delivery delays and delivering 4 targeted recommendations.
- Authored 22 SQL Server views using CTEs, subqueries, and date functions to answer 20+ business questions on revenue, order patterns, and product performance.
- Connected views to a 3-page Power BI dashboard (Executive Summary + Operations) featuring KPI cards, trend lines, and category breakdowns with a custom Domino's theme.
- Surfaced 4 core KPIs and insights on best/worst-selling products, peak demand hours, and monthly trends — enabling data-driven staffing and inventory decisions.
- Designed a 4-page executive Power BI dashboard on a Star Schema model (Orders, Products, CRM, Locations) delivering a 360° view of sales, profit, and customer performance across 2011–2014.
- Implemented advanced DAX Time Intelligence measures (Prior Year, YoY Growth) and dynamic conditional formatting with scatter plots, treemaps, and interactive slicers.
- Surfaced Total Sales, Net Profit, Profit Margin %, and YoY Growth — pinpointing high-revenue vs negative-margin products to guide pricing and promotion decisions.