CRM Sales Opportunities 

HR Dashboard Overview and Performance Analysis

Problem Definition:

The HR Dashboard provides insights into various aspects of the company's workforce, including salary distribution, employee count by department, performance ratings, and detailed employee information. The key problem areas identified from the dashboard are:

1. Gender Imbalance: Notable disparity in gender representation, especially low male representation.

2. Employee Engagement and Retention: High number of inactive and resigned employees, indicating potential issues with retention and engagement.

3. Salary Structure: High average salary raises questions about salary distribution across different roles and departments.

Objectives to Achieve:

1. Enhance Gender Diversity: Address the gender imbalance by implementing targeted recruitment and retention strategies.

2. Improve Employee Engagement and Retention: Identify reasons behind high inactivity and resignation rates and develop strategies to improve employee satisfaction and retention.

3. Optimize Salary Structure: Conduct a detailed analysis of salary distribution to ensure fair and equitable compensation across roles and departments.

Research Questions:

1. Gender Diversity: What are the factors contributing to the low male representation, and what strategies can be implemented to improve gender diversity?

2. Employee Engagement and Retention: What are the primary reasons for employee inactivity and resignations, and how can the company improve engagement and retention rates?

3. Salary Distribution: How is the current salary distribution across different roles and departments, and what adjustments can be made to ensure fairness and equity?

Analysis:

1. Gross Salary & Employees:

   • Total Gross Salary: $100.23 million.

   • Total Employee Count: 1,000 employees.

   • Average Salary: $100.23k.

2. Employee Distribution:

   • Active Employees: 257.

   • Inactive Employees: 260.

   • On Leave: 252.

   • Resigned: 231.

   • Gender Distribution:

     • Females: 446 (44.6%).

     • Males: 109 (10.9%).

     • Other Genders: 5 (0.5%).

3. Departments & Performance:

   • Employees are categorized into various departments such as accounting, engineering, services, support, etc.

   • The dashboard highlights top-performing employees, indicating a robust performance evaluation system.

4. Employee of the Month:

   • Clarissa Lean is recognized as the Employee of the Month with a perfect rating of 5.00 (Outstanding).

5. Salary by Performance:

   • Performance Categories: Employees are categorized into 'Outstanding,' 'Good,' 'Improvement Needed,' and 'Poor.'

   • Performance-Based Pay Structure: This categorization implies that salary adjustments may be influenced by performance ratings.

6. Employee Count by Department:

   • Departmental Trends: The dashboard shows the active employee count by department over different years, highlighting trends in staffing, growth, or reduction within departments.

7. Employee Overview:

   • Detailed Employee Information: Includes details such as employee ID, name, position, manager, department, salary, and performance rating status, offering a detailed view of individual performance and contributions.

Interpretation:

• Diversity and Inclusion: The presence of employees identifying as other genders indicates some level of gender diversity. However, the low male representation suggests a need for targeted gender diversity strategies.

• Employee Engagement: The high number of inactive and resigned employees highlights potential engagement and retention issues. Further investigation into the causes of inactivity and resignations is necessary.

• Salary Analysis: The high average salary indicates significant investment in the workforce. A deeper analysis into salary distribution across different roles and departments is required to ensure fairness.

• Performance Recognition: The dashboard’s emphasis on performance ratings and the Employee of the Month program suggests a strong culture of performance recognition, which can boost morale and productivity.

Conclusion:

The HR dashboard serves as a strategic tool for HR management, enabling data-driven decisions regarding salary adjustments, promotions, and workforce planning. It highlights key metrics related to salary, employee status, gender distribution, departmental allocation, and performance recognition.