Human Resources Dashboard
About This Project
The HR Analytics Dashboard project is a business intelligence solution developed using Power BI, designed specifically for the HR department. It provides a comprehensive view of HR data including headcount analysis, attrition rates, employee demographics, diversity and inclusion metrics, performance ratings, and employee engagement and satisfaction. HR professionals can gain a holistic view of the workforce through visually appealing and interactive dashboards.
Project Description
The dataset revolves around a fictitious company and the core data set contains names, DOBs, age, gender, marital status, date of hire, reasons for termination, department, whether they are active or terminated, position title, pay rate, manager name, and performance score.
The objective was to provide and comprehensive view of HR data that empowers the HR department to gain valuable insights, make data-driven decisions and improve overall organizational performance.
ETL and Data Modelling
The data was extracted from an Excel CSV, transformed and loaded into Power BI for analysis complimented with a table specific for the DAX measurements utilized.
In the data normalization process, the single table was structured into smaller tables with logical relationships enhancing data consistency and efficiency.
File Types: CSV || Data Structure: Single Table || # of Records: 311 || # of Fields: 36
Source: Kaggle License: CC-BY-NC-ND