Project 2 - Supply and Demand Gap Analysis

Supply and Demand Gap Analysis

Aim :

HR Report is an analytical method used to display human resources-related status, insights, and metrics with the primary purpose of improving workforce performance, recruiting procedures and other relevant HR processes with the help of HR dashboards Human Resources (HR) analytics is and integrated approach to improvise the decision-making capability to achieve organizational goals.

Introduction :

The main motive of Human Resources analytics is to identify skilled individuals strive significantly for who return the investment for the organization by considering several factors which a better understanding of helps predictive analysis. HR report is an analytical method used to display human resources related status, insights, metrics, and other relevant HR processes with the help of dashboards.

Problem Statement :

Methodology :

The six stages of HR data collection and analysis.

1. Perform the HR function
2. Desire to make a difference
3. Organize how to collect the data
4. Understand the data
5. Take action
6. Analyze and compare

Database :

HR data visualization using Microsoft Power BI Tool. Analyze the large amount database using MS Excel.

Pre-Processing :

Firstly, collect the data and import in Power BI tool using excel folder and load the data.

POWER QUERY :

Ø Convert data types- text, numbers, dates

Ø Remove columns, rows and blank data.

Ø Aggregate and summarize the data.

Data Interpretation :

After cleaning the data, add the data into power bi with the help of close & apply option. In data interpretation we found some important information.

Data Visualization :

In visualization we make different type of charts and graphs with the help of Power BI. We can also calculate the sum of salary in different departments.

Analysis :

Ø From the above visualization I find some points :

Ø The data is available for the employess of different department.

Ø Count of total salary depend on their work.

Ø Employess martial status. Most of the employees are single.

Ø Also analyze the employee satisfaction with their work.

Insights :

The employee metrics dashboard combines several factors that influence the employee’s performance. You can use Power BI to create multiple dashboards focused on individual’s factors to derive and insights.

Recommendations :

Ø Develop an effective training program

Ø Provide more regular feedback from employees

Conclusions :

HR analytics strategic decision-making that can derive business solutions by improving productivity. In this research , the model shows the real-time human resource processes and then using this data to make informed decisions to make informed decisions to manage employee and reach business goals.