Analytical Dashboard for Human Resources Management in Garbel

Project Details

Project Summary

The Employee Turnover Analytics Dashboard is an interactive solution developed in Power BI for Garbel, a fictional pharmaceutical company, designed to empower the HR department. Using data obtained from Kaggle, the dashboard provides an in-depth analysis of employee turnover metrics and a comprehensive analysis of the HR department's performance.

The main goal is to identify the root causes of turnover, spot trends, and develop actionable strategies to reduce turnover, improve retention, and foster employee satisfaction.

Main Objectives

1. Diagnose Causes of Turnover: Analyze employee data to identify the main factors driving turnover, such as job satisfaction, income levels, and workload, as well as pinpoint high-risk roles and departments.
2. Strategic Decision Support: Provide actionable insights to help HR teams develop data-driven strategies to reduce turnover and improve employee satisfaction.
3. Comprehensive HR Analysis: Offer a holistic view of key metrics such as employee demographics, satisfaction levels, revenue distribution, and performance by department, enabling detailed analysis and comparisons.
4. Scalability and Adaptability: Demonstrate a replicable and modular dashboard design that can be adapted to the needs of other organizations or industries.

Data Model

The dashboard is powered by a well-structured data model, designed for scalability and ease of analysis. Key datasets include:

• Employee Demographics: Data on gender, age, education and field of study.
• Work Metrics: Information on roles, departments, performance evaluations, and income levels.
• Satisfaction Data: Work, environmental and relational satisfaction scores.
• Turnover Metrics: History of turnover rates and contributing factors.

The data model leverages DAX measures and relationships in Power BI to deliver interactive capabilities and comprehensive analytics.

Technologies and Tools Used

• Power BI: The main tool for designing the interactive dashboard and creating custom measures for advanced analytics.
• Kaggle Dataset: Real HR data used to simulate a business environment.
• Python: For preprocessing, cleansing, and data validation.
• Excel: For initial manipulation and integration of datasets.

Business Impact

This dashboard demonstrates how HR analytics can revolutionize decision-making and improve organizational performance. Its key impacts include:

1. Retention Improvement
   • Identifying the factors that drive turnover allows HR teams to take proactive steps to retain key talent.
   • For example, high turnover in roles such as Sales Reps can be addressed through adjustments in workload or compensation.
2. Increased Satisfaction
   • Detailed insights into job satisfaction, environmental, and performance allow HR teams to implement targeted strategies to improve morale and engagement.
   • Departments with high levels of satisfaction, such as Research and Development, can serve as a reference for other areas.
3. Strategic Resource Allocation
   • The dashboard identifies the departments and roles with the highest turnover, facilitating the efficient allocation of resources to address critical issues.
   • It also highlights successful roles or departments, providing a model for replicating best practices across the organization.
4. Scalability and Adaptability
   • This dashboard can be easily customized for other companies or industries, demonstrating its potential as a modular and replicable solution for HR analytics.

Conclusion