HR & Payroll Analytics Dashboard

An end-to-end human resources and payroll analytics dashboard built using Power BI, designed to bridge the gap between operational workforce management and financial control. This dashboard empowers executive management and HR leaders to make data-driven decisions through interactive visual insights.Key Analytical Pillars & Features:Workforce Dynamics & Turnover: Track active vs. departed employees, monitor overall turnover rates, and analyze distribution across branches (Cairo, Mansoura, Giza, Alexandria) and work models (Full-Time, Hybrid, Remote). Financial & Payroll Integration: Detailed breakdown of total payroll costs, net salaries, and deductions, categorized into cost tiers (High, Medium, Low Cost) to optimize budget planning. Performance & Promotion Readiness: Evaluate KPI scores and employee performance ratings to support succession planning and identify promotion-eligible talent. Training & Development ROI: Monitor course completion statuses and analyze the correlation between course costs and employee enrollment rates (Cost Per Seat vs. Enrollment).Leave Management: Track and categorize total leave requests (Annual, Casual, Sick) to monitor operational attendance and productivity. Tech Stack & Methodology:Power BI Desktop: UI/UX dashboard design and interactive visualizations. DAX: Advanced measures, time intelligence, and dynamic financial/performance calculations. Power Query & Data Modeling: Optimized Star Schema architecture to ensure high query performance and data integrity.