Portfolio

Ahmed Hegazy

Data Analyst| Business Analyst | Healthcare Analyst

---

           

---

🔹 Data Analysis | Business Analytics | Visualization | Storytelling 🔹

I’m a Data Analyst with expertise in SQL, Python, and Business Intelligence tools, specializing in data analysis, business analytics, and marketing analytics. I leverage data-driven insights to support strategic decision-making, optimize operations, and improve business performance.

💡 Skilled in statistical analysis, regression modeling, and sales forecasting, I turn complex data into actionable insights through visualization and storytelling.

📊 Passionate about Data. Focused on Impact.

When I’m not analyzing data, you’ll find me pursuing my passions for 🏋️‍♂️ Bodybuilding, 🥊 Boxing, and 📚 Reading.

---

🛠 Skills & Expertise

🔹 Programming & Database Management

• SQL – MySQL, PostgreSQL, SQL Server
• Python – Data Manipulation & Analysis (Pandas, NumPy)
• R – Statistical Computing

📊 Data Visualization

• 🎨 Tableau – Dashboards & Analytics
• 📈 Power BI – Business Intelligence Reports
• 📊 Matplotlib, Seaborn – Python Data Visualization
• 📊 Google Analytics GA4
• 📊 Microsoft Excel – Pivot Tables, Power Query

📊 Statistical Analysis & Business Intelligence

• Hypothesis Testing

  Regression Analysis

  Forecasting

• Power Query

  Power Pivot

  DAX

  Data Modeling

🔹 Data Warehousing & ETL

• SQL Server 2022 – Columnstore Indexes
• ETL Automation & Cloud Analytics (Azure Synapse, Google BigQuery)

📢 Marketing Analytics

• Conversion Funnel Analysis

  KPI Measurement

  Performance Metrics

🤝 Soft Skills

• Analytical Thinking
• Problem Solving
• Storytelling & Communication

---

🎓 Education & Certifications

🎓 Nile Higher Institute – Bachelor of Management Information (2016–2019)
📜 Cumulative Grade: Very Good

🏅 Professional Certifications

🚀 Health Information Literacy for Data Analytics
📌 View Credential

🚀 Google Data Analytics Professional Certificate
📌 View Credential

📊 Microsoft & LinkedIn Career Essentials in Data Analysis
📌 View Credential

✅ Excel: Sales Forecasting (LinkedIn)
✅ Excel: Market Research Strategies (LinkedIn)
✅ Advanced Power BI: DAX Language, Formulas & Calculations
✅ Level Up: SQL (LinkedIn)
✅ Marketing Analytics: Decoding the Conversion Funnel
✅ Marketing Analytics: Setting & Measuring KPIs
✅ Marketing Analytics Foundations
✅ Learning Data Analytics Part 2: Extending Core Knowledge
✅ Learning Data Analytics: Foundations
✅ Business Analysis Foundations (IIBA)
✅ Business Process Modeling (IIBA)
✅ Statistics Foundations Using Data Sets
✅ Data Visualization: Storytelling
✅ Learning Data Analytics
✅ Excel BI: Power Pivot, DAX & Data Modeling
✅ Data-Driven Decision-Making for Business Professionals
✅ Data-Driven Decision-Making for the Real World
✅ Implementing a Data Warehouse with SQL Server 2022
✅ Introduction to Data Analytics (Coursera)
✅ Tableau Ultimate Course: Zero to Hero (YouTube)
✅ Data Analytics Bootcamp (YouTube)
✅ Introduction to SQL (Skillup)

---

📚Click below to view projects 👇

---

📦 SQL-Projects
├── 📁 Data
│   └── Raw and cleaned datasets
├── 📁 Scripts
│   ├── Queries.sql
│   ├── DataCleaning.sql
│   ├── ETL.sql
├── 📁 Reports
│   └── Insights and visualizations
└── README.md