Ashraf HamdyData Analyst

SQL · Excel · Power BI · Python

I turn messy business data into clear dashboards.

Practical analysis, focused KPIs, and decision-ready stories for teams that need to see what is happening next.

View projects

Currently seeking a junior Data Analyst role or internship.

Selected work

Projects that turn analysis into action.

Each case study starts with a business question, moves through cleaning and analysis, and ends with a clearer decision.

  • 01 / RETAILCase study

    Retail Sales & Profitability Analysis

    Problem
    Revenue was increasing while overall profit margins declined.
    What I did
    Cleaned and consolidated sales and cost data, then compared margin against volume by product and category.
    Result
    Found that high-volume SKUs were not always the most profitable, while slower-moving, high-margin items created promotion opportunities.
    ExcelPower QueryMargin analysis
    Dashboard link pending
  • 02 / BIDashboard

    Sales Performance Dashboard

    Problem
    Management needed one view of sales by region, representative, and product.
    What I did
    Built a Power BI report with DAX measures, filters, drill-down, and product-level detail.
    Result
    Brings sales trends, regional performance, rep comparisons, product ranking, and rapid segmentation into one decision view.
    Power BIDAXDrill-down
    Dashboard link pending
  • 03 / HRAnalysis

    HR Attrition Analytics

    Problem
    A 15% overall attrition rate hid where people were actually leaving.
    What I did
    Segmented exits by department and tenure to identify concentration and early-tenure patterns.
    Result
    Customer Support showed significantly higher attrition than the company average; early-tenure employees represented a disproportionate share of exits. Workload-related patterns appeared important, and compensation alone did not explain departures.
    ExcelHR analyticsSegmentation
    Analysis link pending
  • 04 / EXCELSupporting project

    TechNest Gadget Store Dashboard

    Problem
    The business question and target outcome were not included in the supplied project material.
    What I did
    The portfolio audit identifies an Excel dashboard covering the Austin and Columbus stores; its screenshot and supporting case-study details are still to be added.
    Result
    Outcome metric pending — no result is claimed until the source data or dashboard is supplied.
    ExcelDashboardDetails pending
    Dashboard link pending

About

Analytical thinking, explained clearly.

I'm a data analyst in training (B.Sc. Computer & Communication Engineering, 2027) who turns messy business data into KPIs and dashboards people actually use. I work in Power BI, DAX, Excel, SQL and Python. Looking for a junior analyst role or internship.

I care about the question behind the chart: what changed, where it changed, and what a team can do next.

Toolkit

A practical stack for the full analytical path.

01

Analysis

Exploratory analysis, business performance, trends, segments, KPI development, and data-driven insights.

02

Visualization

Power BI dashboards, Excel reporting tools, interactive drill-down reports, and visual storytelling.

03

Preparation

Data cleaning and QC, transformation, Power Query, ETL, and SQL data preparation.

04

Tools

Power BIDAXExcelSQLPythonPandasNumPyMatplotlib

Resume

Ready for the next analytical question.

My resume PDF is not attached to the portfolio yet. I will add a working download as soon as the final file is supplied.

Resume PDF not supplied yet.

Contact

Have a business question? Get in touch.

If you are looking for a junior analyst or want to discuss a data problem, send a note. I aim to reply within 48 hours.

Emailashrafhamdi99991@gmail.com LinkedInlinkedin.com/in/ashraf-hamdy-797218290