This repository contains my project work in Microsoft Excel.
About HR Management
Human resource management is the process of employing people, training them, compensating them, developing policies relating to the workplace, and developing strategies to retain employees.
Objective
A Company wants to design a HR Management dashboard to analyze the total emloyees,salaries based on various regions. The company wants to full time and pat time employee's record and their participation.
Dataset Description
We will be using HR-Managemebt-Dashboard.xlsx Dataset attached.
Within this file you will find the following fields:
Analysis Tasks
Create a chart to analyze total active employees in company.
Prepare a table of termination reason, named it as ‘Termination Reason’.
Prepare a table of Ethich Group,named as 'Active by Ethich Group'.
Prepare a table of Average monthly tenure.
Prepare the table of .active by regions employee.
Prepare a chart for bad hires.
Create slicers for connecting the different charts.
Create a dashboard.
Prerequisites : Basic Knowledge of Pivot Tables,Basic VBA,Charts and formatting in Excel
HR Dashboard : I have utilized following items in building sales dashboard which analyzes data by different aspects.
Pivot Tables
Different Chart
Slicers