Turning raw data into clear insights and compelling stories. Specializing in Power BI, SQL, Python, and Excel — from complex dashboards to deep analytical pipelines.
I'm a Data Analyst based in Egypt with a background in Business Administration and hands-on experience across Power BI, SQL, Python, and Advanced Excel. I specialize in transforming messy datasets into clean, actionable intelligence.
My work spans financial auditing, call center analytics, HR insights, and sales performance — each project built to answer real business questions with measurable impact.
I hold a BBA from Sadat Academy for Management Sciences and certifications from Deloitte, DEPI, Microsoft Egypt, and HackerRank. Currently open to full-time data analyst roles and freelance engagements.
Egypt · Open to Remote
BBA · Sadat Academy for Management Sciences · 2023
Available for full-time roles & freelance projects
Within 24 hours — always
Arabic (Native) · English (Professional)
Interactive dashboard analyzing 1.7M+ calls across 3 months. Tracks live KPIs with drill-through, custom tooltips, conditional icons, and a What-If Analysis engine with 3 dynamic parameters to simulate real-time scenarios.
Dynamic multi-region dashboard using advanced DAX measures to track sales performance across 5+ regions. Identifies trends and peak periods, delivering a 30% improvement in reporting efficiency and saving 10+ hours per week.
Interactive Power BI dashboard analyzing sales, gross profit, operating expenses, receivables, payables, and net profit across branches and cashboxes. Built with Power Query transformations, star-schema modeling, duplicate invoice handling, and safe DAX filter-context logic.
Full-featured Excel sales dashboard tracking 1M+ EGP in transactions. Built with Pivot Tables, Slicers, and VBA Macros for automation. Raw data cleaned via Power Query with custom columns for customer classification and delivery status.
End-to-end HR analytics dashboard in Tableau Public analyzing 1,480 employees across 39 fields. Tracks 16% attrition rate across job roles, gender, age groups, and marital status. Features KPI cards, scatter plot, attrition bar chart, and a treemap.
SQL Server
Relational database system for an airport built from scratch in SQL Server. Designed 6 normalized tables with computed ID columns, foreign key constraints, and full DML operations. Includes 8 business queries covering pilot-manager reporting, plane capacity, and flight scheduling.
Python · Pandas · Plotly
Exploratory data analysis on a multi-country sales dataset. Full data cleaning pipeline — dropped null Order IDs, renamed duplicate columns, parsed dates, cast data types. Built 5 interactive Plotly visualizations: distribution with mean/median overlay, city and country revenue bar charts, and top-10 customers ranking.
Python · Pandas · NumPy
Structured data analysis on a weather dataset answering 15 real-world business questions using Pandas. Covered data inspection, null checks, statistical metrics (mean visibility, pressure std dev, humidity variance). Applied boolean filtering and groupby aggregations.
SQL Server
Relational database system analyzing e-learning adaptivity patterns across 499 students. Built two normalized schemas (st & le), performed data cleaning including column renaming, type casting, and adding computed columns. Wrote 10 business queries covering JOINs, GROUP BY, HAVING, CTEs, CASE WHEN, and VIEWs to surface insights on internet usage, device preferences, class duration averages, and adaptivity levels by education tier.
Open to full-time data analyst roles, freelance projects, and collaborations. I respond within 24 hours.
aly.ashraf2020@gmail.com