Data analyst ยท Cairo, Egypt

Hi, I'm Maram. I turn messy data into decisions people can act on.

I clean it, query it, visualise it, and then tell the story behind the numbers.

SQL Python Power BI Tableau Excel & Power Query DAX
Portrait of Maram Hamdey
Data Analystopen to junior roles
About me

Curious about the "why" behind every number.

I'm a detail-oriented data analyst who enjoys the whole journey: from a messy spreadsheet to a clear recommendation.

๐Ÿ”Ž

What I do

  • Explore and clean raw data
  • Write SQL to answer business questions
  • Build dashboards in Power BI and Tableau
๐Ÿงญ

How I work

  • Start from the business question
  • Check data quality before trusting a number
  • End with clear, prioritised recommendations
๐ŸŒฑ

What I'm looking for

  • A junior data analyst or BI role
  • A data-driven team to learn from
  • Real problems where my analysis can help
3internships
9case studies
2BI tools: Power BI & Tableau
130,000+rows cleaned & analysed
Skills

My toolkit

๐Ÿ“Š Visualisation

Power BITableau Excel chartsDashboard design

๐Ÿ—„๏ธ Databases & SQL

MySQLPostgreSQL AggregationsWindow functionsSubqueries

๐Ÿ Python

pandasmatplotlibseabornrequests / APIsSQLAlchemy

๐Ÿงฎ Spreadsheets & DAX

ExcelPower Query Google SheetsDAX

๐Ÿ” Analysis & reporting

Data cleaningExploratory analysis Insight extractionKPI reporting

๐Ÿ“ Statistics

Descriptive statisticsCentral tendencySpread & distribution

๐Ÿ’ฌ Soft skills

CommunicationPresentationAttention to detail
Experience

Where I've been learning by doing

Data Analysis Intern

DEPI
Digital Egypt Pioneers Initiative (DEPI)
  • Selected for DEPI, the national upskilling programme run by Egypt's Ministry of Communications and Information Technology.
  • Hands-on training in SQL, Power BI, Tableau and Excel.
  • Practising each tool on realistic datasets, from raw tables to finished dashboards.

Data Analysis Intern

DecodeLab
DecodeLab
  • Analysed 1,200 orders (2023โ€“2025) across 7 products and 5 referral sources.
  • Wrote the SQL, built the Power BI dashboard and produced a findings report.
  • Surfaced a falling revenue trend and a large share of returned and cancelled orders.

Read the DecodeLab case study โ†’

Data Analysis Intern

Rawaj HCM
Rawaj HCM
  • Ran a full end-to-end sales analysis on a retail dataset.
  • Built a 3-page interactive Power BI report: Overview, Insights and Proposals.
  • Found where costs, returns and discounts were hurting profit, and recommended what to do about it.

Read the NovaMart case study โ†’

Projects

Selected case studies

Filter by skill, then click a project to walk through the problem, my steps, the dashboard and what I found.

Education & learning

Where my foundations come from

๐ŸŽ“

MTI University

Bachelor's degree ยท Graduated June 2023

๐Ÿ“œ

Courses & certifications

  • Foundations: Data, Data, Everywhere ยท Google / Coursera
  • SQL Basics ยท Codecademy & W3Schools
  • Excel, Introduction to DAX, Power BI ยท 365DataScience
  • Communication & Presentation Skills for Analysts ยท 365DataScience
  • Descriptive Statistics ยท Khan Academy
Contact

Let's talk data

I'd love to hear about your team and what you're working on.

๐Ÿ“ Fifth Settlement, Cairo, Egypt