This repository contains an HR Analytics project focused on analyzing and visualizing key HR metrics, such as employee performance, retention rates, turnover, and recruitment effectiveness. The project uses MySQL to manage and query employee data, and Power BI for creating interactive dashboards that provide insights for HR decision-making.

The dataset includes the following key columns:

Employee Information:

Job Details:

MySQL: For managing company employee data and running exploratory data analysis queries.

Power BI: For creating visualizations and dashboards for Human Resource insights.

Download and install MySQL Workbench

Run the script employee_analysis.sql to create and populate the database with employee and recruitment data

Use the provided queries in scripts/ to analyze HR metrics such as:

Download and install Power BI Desktop (free version)

Open the .pbix file (hr_dashboard.pbix) in Power BI Desktop

Interact with the dashboard to explore HR metrics including:

The dataset includes key HR metrics such as:

Employee demographics

Performance ratings

Salary information

Recruitment data

Key metrics visualized include:

Employee Retention: Analyzing the percentage of employees staying in the company over a period

Turnover Rate: Tracking the rate at which employees leave the organization

The average employment tenure for terminated employees is 8 years

Department of Marketing and Accounting has the highest turnover rate at 65%

Active employees total 17,000 out of 22,000 with the most employees in department of Ebgineering

Screenshots

The dataset is used solely for the purpose of demonstrating data analysis and visualization techniques

For more advanced users, additional scripts and custom calculations are included in the project folder for deeper analysis

This project is licensed under the MIT License.