Project 2 - Supply and Demand Gap Analysis

AIM:

An HR dashboard is a Business Intelligence tool that allows Human Resource teams to track, analyse and report on HR KPIs.

INTRODUCTION:

HR dashboard allows HR professionals to tack and analyse metrics related to the performance of various initiatives and departments, helping with organization, reporting, decision-making and gathering valuable insights.

PROBLEM STATEMENT:

To significantly clarify the current situation by specifically identifying the problem and its severity, location and financial impact. To convince management to provide resources to solve the issue.

METHDOLOGY: 

1. Data Collection: Collecting data from Kaggle to create a HR analytics Dashboard using Power BI tool.

2. Data Cleaning: Performed Data cleaning using Transform data in power BI tool were fixing top row as headers. Added some calculative fields for designing KPIs 

3. Data Visualization: With the help of Power BI desktop tool. I had done a visualization using donut chart, pie chart, text box, bar chart, cards, matrix etc.

ANALYSIS (Data Sheets Pertaining to It): 

In observation found some points that are mentioned below for analysis

1. Attrition Rate by gender for different age groups

2. Education fields by attrition

3. Job satisfaction Rating

4. Number of employees by age group

5. Department Wise attrition

6. Total employees, Attrition count, Attrition Rate, Active employees, Age rate, education.

INSIGHTS: 

1. In conclusion, we can take a look at the final Report for further analysis.

2.We can see the KPIs according to education, age etc.

RECOMENDATIONS: 

1. We can collect large data sets for visualization

2. Can work on large data sets and analyse them with proper format and chart

CONCLUSION:

By Collecting and analysing data related to the people in an organization, HR analytics can help make data - driven decisions, measure the impact of HR initiatives and shape the future of work. These are just some of the key reasons why HR analytics is important.