HR DASHBOARD

Designed and developed a fully interactive HR Analytics Dashboard using Microsoft Excel, covering 1,000 employees across 5 Egyptian branches.

Key features:

KPI cards showing Average Salary ($9,326), Average Experience (20 years), and Total Headcount (1,000)

Employee distribution analysis across Cairo, Giza, Alexandria, Sharqia & Ismailia

Hiring trend line chart spanning 1993–2015

Salary breakdown by position (Manager / Employee / Supervisor), department, branch, and pay type

Gender-based analysis for both headcount and total salaries

Dynamic slicers for real-time filtering across all visuals

Clean purple-themed UI with consistent design language

Tools used: Microsoft Excel (Pivot Tables, Pivot Charts, Slicers, K PI Cards)