HR Analytics Dashboard - Power BI

👥 HR Analytics Dashboard

Power BI - Workforce Intelligence
🎓 Ghaziabad Mohan Nagar
👨‍💼 Designed by: HR Prateek Sharma
👨‍💼
Total Employees
1,247
↑ 5.2% from last month
🎯
Attrition Rate
12.8%
↑ 2.1% increase
📊
Avg Satisfaction
4.2/5
↑ 0.3 improvement
💰
Avg Salary
₹8.5L
↑ 8.5% annual growth

Department-wise Distribution

Technology
425
Sales
348
Marketing
274
HR
200

Age Group Distribution

20-30 years
468
31-40 years
562
41-50 years
174
50+ years
43

📈 Hiring Metrics

New Hires (This Month) 47
Open Positions 23
Time to Hire (Avg) 28 days
Offer Acceptance Rate 87%

⏰ Attendance Overview

Avg Attendance Rate 94.2%
Leaves This Month 234
Late Arrivals 156
Work From Home 412

🎓 Training & Development

Training Hours (Total) 2,450
Certified Employees 678
Ongoing Programs 15
Avg Training/Employee 18 hrs

Employee Performance Snapshot

Employee ID Name Department Tenure Performance Rating Status
#E1001 Rajesh Kumar Technology 4.5 years ⭐⭐⭐⭐⭐ 4.8 High Performer
#E1002 Priya Sharma Sales 2.3 years ⭐⭐⭐⭐ 4.2 High Performer
#E1003 Amit Verma Marketing 3.1 years ⭐⭐⭐ 3.5 Satisfactory
#E1004 Neha Gupta HR 5.2 years ⭐⭐⭐⭐⭐ 4.9 High Performer
#E1005 Suresh Patel Technology 1.8 years ⭐⭐ 2.8 Needs Improvement
#E1006 Anjali Singh Sales 3.7 years ⭐⭐⭐⭐ 4.5 High Performer

Attrition by Department

Technology
15.2%
Sales
18.9%
Marketing
11.3%
HR
7.5%

Gender Diversity

Male
811 (65%)
Female
436 (35%)

Comments

Post a Comment

Popular posts from this blog

  HR Analytics - Day 2 Notes 📊 HR Analytics - Day 2 Ghaziabad, Mohan Nagar 🔄 Different Phases of HR Phase 1: Job Posting Internal Hiring: Recruiting from within the organization External Hiring: Recruiting from outside the organization External Hiring Process: Recruitment Example Scenario: 1000 resumes received for 2 job positions Step 1: Short Listing - ATS (Applicant Tracking System) From 1000 resumes → ATS shortlists → 100 candidates ⚠️ Critical Point: Selection of wrong candidates = Loss of time KPI Metri...
Read more
  HR Analytics - Day 1 Notes 📊 HR Analytics - Day 1 Ghaziabad, Mohan Nagar 💱 Currency Conversion Reference $1 Million = ₹8,000 Cr $5 Million = ₹40,000 Cr $50 Million = ₹40 Lakh Crore 📚 Key Terminology BPO Business Process Outsourcing GPU Graphics Processing Unit KRA Key Responsibility Area KPI Key Performance Indicator - Quality of work, helps che...
Read more
  Day 3 - HR Analytics Notes 📊 Day 3: HR Analytics & Business Intelligence Ghaziabad, Mohan Nagar Drafted by: HR Prateek Sharma 📈 Key Metrics Attrition Rate (A.R): Total Employees Left / Total Employees × 100 Example: 45/1500 × 100 = 3% Yearly Increment of Employee = 10% 🔍 Four Types of Analytics 1. Descriptive Analytics Like describing the problem to a doctor Name, Age, Gender, Address Last college name Kinship Rule: Blood relations allowed in companies (preference-based) Considerations: Discrimination, same comp...
Read more