Ahmed Elhofy

Data Analyst

Data Analyst with hands-on experience turning complex datasets into clear, actionable insights , skilled in Python, SQL, Power BI, and Tableau to help businesses make data-driven decisions.

SQL
// 01 โ€” about

My process, from data to decisions

Data Analyst with a Bachelor's in Business Information Systems from Tanta University. What I like most about this field is taking a messy spreadsheet and turning it into something people can actually act on.

I've worked with datasets running into the tens of thousands of rows, built dashboards that management actually opens every week, and put together reports that helped decision-makers see what the numbers were really saying. My main tools are Python, SQL, Power BI, and Tableau.

Right now I'm pushing further into Machine Learning and Data Engineering trying to build a skill set that covers the full picture, not just the analysis side. I also write on Medium about what I'm learning along the way, mostly so I remember it better myself.

Python
SQL
Power BI
Tableau
Pandas
NumPy
Plotly
Excel
Web Scraping
Data Warehousing
Data Mining
DAX
// 02 โ€” projects

Selected work

HR Analysis
HR Attrition Analysis Dashboard

Analyzed HR data for 1,470 employees to uncover attrition drivers across compensation, engagement, and overtime patterns. Built an interactive Power BI dashboard with an Attrition Risk Score and Budget Optimizer, projecting $13.9M in annual retention-related costs.

DAXPower BIData ModelingAttrition Risk
EDA
Retail Analysis
Retail Sales Data Warehouse & BI Dashboard

End-to-end data warehouse and BI project , built a Medallion-architecture pipeline (Bronze/Silver/Gold) in SQL Server and Python to clean, model, and transform 51K+ retail transactions into a star schema, then surfaced profitability, discount, and customer insights through an 6-page Power BI dashboard.

PythonPower BIData ModelingSQL ServerETL PipelinesData Cleaning
Automation / Web Scraping
LinkedIn Company Scraper

A tool that searches LinkedIn for a company, confirms the right match, and scrapes its public profile โ€” industry, size, headquarters, founding year, and more โ€” into a running, deduplicated Excel dataset. Session-authenticated and headless by default, with a modular codebase separating the UI, scraping logic, and cookie/session validation.

PythonSeleniumPandasWeb Scraping
// 03 โ€” experience

Experience & Education

2025
Reporting Officer
EDEX 2025 โ€” Egypt Defence Exhibition ยท Cairo Airport
Prepared analytical reports tracking delegate arrivals, departures, nationalities, and VIP attendance trends to support real-time decision-making during a high-profile international event.
2021 โ€” 2024
B.Sc. in Business Information Systems
Tanta University โ€” Faculty of Commerce
Focused on information systems, data analysis, and business intelligence. Built a strong foundation in database design, analytical thinking, and data-driven decision making.
// 04 โ€” contact

Let's work together

The fastest way to reach me is WhatsApp โ€” I usually reply within a day. You can also find my projects on GitHub and my data writing on Medium.