Project 2 - Supply and Demand Gap Analysis

Aim:

The study aims to increase the ability to identify employee churn using POWER BI with the help of real-time data insights in dashboards for HR management.

Introduction:

HR report is an analytical method used to display human resources-related stats, 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 Resource (HR) analytics is an integrated approach to improvise the decision making capability to achieve organizational goals. High-end predictive modeling is used in HR analytics where the organization faces the scenarios to forecast the consequences of the organization or enterprise policies.

Problem statement:

• It is time for promotion for anyone who hasn't received one in the last 10 years or more.
• Let's assess which employees should be let go if the company needs to reduce its workforce for various reasons.

Methodology:

The seven stages of HR data collection and analysis. 1, Perform the HR function. 2, Desire to make a difference. 3, Organize how you collect HR data. 4, Understand the data. 5, Take action. 6, Analyze and compare. 7, Earn recognition. descriptive, diagnostic, predictive, and prescriptive. Descriptive
analytics. Descriptive (also known as observation and reporting) is the most basic level of analytics. Diagnostic analytics. Predictive analytics.Prescriptive analytics.

Tool Design:
Dashboard designed and developed based on Hr baseline data, view are Overall, geographically, age, expertise wise, and joiner and leaver, etc.

Database:
HR data Visualization using Microsoft Power BI . Analyze a large number of datasets using Ms. Excel.

Pre-Processing:
The First Step collected HR data The Dataset For This Power BI Project, We ‟ll use the dataset "https://drive.google.com/file/d/1h4bvZlHJUFAYJ5CbleAmLr6muAX1Q7rm/view"

We also use the following Power BI functionality:
 Import Function
 Power Query
 DAX
 Visualization charts

 Import Data
Data imported from the folder excel File and loaded into Power BI

 Power Query:
Power Query is the data connectivity and data preparation technology that enables end users to seamlessly import and reshape data from within a wide range of Microsoft products, including Excel, Power BI, Analysis Services, Data verse, and more.

 Convert data types – text, numbers, dates
 Remove columns, rows, and blanks.
 Add calculated columns
 Aggregate or summarize data.
 Find & replace text.
 Unpivot data to use for pivot tables

 Time intelligence, Aggregation, Text Filter and Math function

 DAX:
DAX stands for Data Analysis Expressions.DAX is a collection of functions, operators, and constants that can be used in a formula, or expression, to calculate and return one or more values. Stated more simply, DAX helps you create new information from data already in our model.
Used Dax for data calculation;

 Visualization charts
Visualizations (known as visuals for short) display insights that have been discovered in the data. A Power BI report might have a single page with one visual or it might have pages full of visuals. In the Power BI service, visuals can be pinned from reports to dashboards.
Used visualizations:
Bar chart, pie chart, donut chart, column chart
Icons and shapes
Images
Cards
Filters and Slicers

Analysis:

Insights:

The HR dashboard combines several factors that influence the employees’ performance, which directly impacts the business performance in the competitive market.

• Performance Grid
• Male and Female employees and percentage
• Total Employees due for promotion
• Total Employees not due for promotion
• Total employees in service years
• Total employees on service and retrench
• Total employees by Job levels
• Total employees by Distance status

Recommendations:

1. Tracking employment contract status, Developing strategies, and making decisions that will improve the work environment and engagement levels
2. Having data-backed evidence means that organizations can focus on making the necessary improvements and plan for future initiatives

Conclusions:

Provide quick insights on People data like Demography, People data, hiring, and Improves talent acquisition. HR analytics is an essential part of data management and its implementation can yield positive returns for any organization. HR analytics is an essential part of data management and its implementation can yield positive returns for any organization.