💬 "Talk is cheap. Show me the code." — Linus Torvalds
💬 "There are only two hard things in Computer Science: cache invalidation and naming things." — Phil Karlton
💬 "Measuring programming progress by lines of code is like measuring aircraft building progress by weight." — Bill Gates
✈️
- 🎓 CS student @ Al-Azhar University · 📈 DEPI ,ITI and ALX Data Analysis graduate.
- 🏗️ I build end-to-end data pipelines: generated 1M synthetic healthcare records, engineered a
- Medallion architecture (Staging → Bronze → Silver → Gold) on SQL Server, and served it through a Power BI semantic model.
- 🎯 Focus: Analytics Engineering — modeling, ETL/ELT, and the layer between raw data and real decisions.
Raw CSV / API Dashboards
│ ▲
▼ │
[ Staging ] ──► [ Bronze ] ──► [ Silver ] ──► [ Gold ] ──► [ BI ]
land raw typed cleaned star DAX +
fast history conformed schema measures
| Layer | Tools |
|---|---|
| 🥉 Ingestion | Python, pyodbc, PyArrow, chunked loads |
| 🥈 Transformation | T-SQL stored procedures, data cleaning |
| 🥇 Modeling | Star schema, dims & facts, gold views |
| 📊 Serving | Power BI, DAX, TMDL semantic models |
| ✅ Quality | Statistical validation checks in Python |
🗄️ SQL — all flavors
🐍 Python & Data Stack
🔁 ETL / ELT & Data Engineering
📊 BI & Visualization
⚙️ General
- Medallion Architecture & SQL Server ETL/ELT
- Power BI (DAX, Data Modelling, TMDL)
- Python for data pipelines & validation
- Why the dashboard broke 5 minutes before the meeting 🙃
🕵️ Tricky one:
COUNT(*)= 1,000,000 butCOUNT(email)= 999,412. Where did 588 rows go? 🤔👀 Answer
Nowhere —COUNT(column)skipsNULLs. The rows are fine, the data quality isn't. 😉
📧 hasnaaahmed745@gmail.com · 🔗 LinkedIn · 💻 GitHub
⭐ Stars are the only KPI I can't build a dashboard for.