Skip to content
View Hanan-Hany's full-sized avatar
4 followers · 7 following

Block or report Hanan-Hany

Block user

Prevent this user from interacting with your repositories and sending you notifications. Learn more about blocking users.

You must be logged in to block users.

Maximum 250 characters. Please don’t include any personal information such as legal names or email addresses. Markdown is supported. This note will only be visible to you.
Report abuse

Contact GitHub support about this user’s behavior. Learn more about reporting abuse.

Report abuse
Hanan-Hany/README.md
Typing SVG

Gmail LinkedIn GitHub Resume


Profile Views

◈ About Me

╔══════════════════════════════════════════════════════════════════╗
║  Role       →  Business Analyst · Data Analyst                   ║
║  Focus      →  Data Storytelling · BI Dashboards · Requirements  ║
║  Background →  Full-Stack .NET Development                       ║
║  Location   →  Egypt  🇪🇬  · Open to Remote                       ║
║  Motto      →  "Trust the process — and the data."               ║
╚══════════════════════════════════════════════════════════════════╝

🔄 Transitioning into Business & Data Analysis — bringing a rare edge: I understand how systems are built, not just described. My software engineering foundation means I can speak both the language of developers and stakeholders.

  • 📊 Passionate about data storytelling and translating numbers into narratives
  • 🧩 Strong skills in requirements gathering, process modelling, and gap analysis
  • ⚙️ Experienced in full-stack .NET development with clean architecture principles
  • 🌱 Currently deepening expertise in Power BI, Python for analytics, and BPMN

◈ Skills & Tech Stack

📊 Data & Analytics

SQL Server PostgreSQL Power BI Excel Python Pandas

📋 Business Analysis

Requirements Gathering User Stories Process Mapping Gap Analysis BPMN Use Cases Stakeholder Mgmt

💻 Development

C# ASP.NET Core Entity Framework JavaScript HTML5 CSS3 TailwindCSS

⚙️ Methods & Practices

Agile Clean Architecture Git OOP RBAC

◈ Featured Projects

### 📊 [Retail Store Sales & Products Analysis — Power BI Dashboard](https://github.com/Hanan-Hany/Retail-Store-Sales-and-Products-Analysis)

A comprehensive, interactive two-page Power BI report delivering end-to-end visibility into retail e-commerce performance — from sales trends to product-level insights.

Page 1 — Sales Dashboard:

  • 📈 KPI cards: Total Sales, Profit, Cost, Units Sold, AOV & Conversion Rate
  • 📅 Monthly trends, category performance by device, order priority distribution Page 2 — Product Dashboard:
  • 🏆 Top 10 product rankings & inventory aging analysis
  • 👥 Gender-based sales segmentation & multi-metric combo chart Technical Highlights:
  • 🧮 Centralised DAX Measures table for all KPI logic
  • 🔁 Cross-filtering across all visuals
  • 📆 Date Hierarchy enabling drill-down from year → month Key Findings:

Fashion led all categories in revenue · Web accounted for 89.1% of conversions · Medium & high priority orders represented 86% of all transactions

Power BI DAX Data Modelling

 ### 🌍 [Sales, Customer & Salesperson Performance Analysis — Power BI Dashboard]((https://github.com/Hanan-Hany/Sales-Customer-Salesperson-Performance-Analysis))

An enterprise-scale Power BI report built on 7 million sales transactions ($4.29bn total revenue) spanning 206 countries and 96 cities.

Page 1 — Executive Sales Overview:

  • 📊 Dynamic KPI cards & monthly/quarterly revenue trends
  • 🔠 ABC product classification (Top 70%) with TopN slicer for flexible ranking Page 2 — Customer & Salesperson Performance:
  • 🏅 Top 10 Employees bar chart & gender-based revenue donut chart
  • 🗺️ Azure Maps integration for geographic customer distribution Technical Highlights:
  • ⏱️ Dedicated Time Intelligence table: MTD, PM, PY, MoM%, YoY%
  • 📉 Rolling 90-Day Sales measure for trend smoothing Key Findings:

Bread–Calabrese Baguette ranked #1 at $18.7M · March generated $1.03bn (best month) · Q2 dominated at 69.76% of total sales · 100% customer repeat rate confirmed high loyalty

Power BI DAX Azure Maps Time Intelligence
---

◈ GitHub Stats

  



GitHub Streak

◈ Activity Graph

Hanan's GitHub Activity Graph

◈ Let's Connect

📬 Contact 🔗 Link
📧 Email hananhanyfathy@gmail.com
💼 LinkedIn linkedin.com/in/hanan-hany-fathy
🐙 GitHub github.com/Hanan-Hany
📄 Resume View PDF

🚀 Open to Business Analyst · Data Analyst · Product Analyst roles — Remote or Egypt-based


Popular repositories Loading

  1. ByteReader ByteReader Public

    ASP.NET Core MVC is a model view controller framework for building dynamic ecommerce web sites with clean separation of concerns

    C#

  2. Hanan-Hany Hanan-Hany Public

  3. Retail-Store-Sales-and-Products-Analysis Retail-Store-Sales-and-Products-Analysis Public

    Interactive Power BI dashboard analysing retail e-commerce performance across sales, products, and customer segments — featuring DAX measures, cross-filtering, and insights on revenue, conversion, …

  4. Sales-Customer-Salesperson-Performance-Analysis Sales-Customer-Salesperson-Performance-Analysis Public

    Interactive Power BI dashboard analysing 7M+ sales transactions across executive sales performance, customer behaviour, and salesperson effectiveness — featuring DAX measures, Time Intelligence, AB…