Skip to content

A dashboard that provides a dynamic slice-and-dice overview of an organization's workforce, including departments, absences, and educational credentials.

Notifications You must be signed in to change notification settings

NiveditaSureshK/HR-Analysis-DB-MSExcel

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

11 Commits
 
 
 
 

Repository files navigation

HR-Analysis-DB-Excel

Problem Statement

The above HR dashboard aggregates and visualizes data from several departments within the organization to provide a comprehensive summary of critical HR KPIs, allowing for improved decision-making.

HR dashboards allow teams to get a bird’s-view of their people operations while also delving deeper into how specific data points correlate. As a result, HR dashboards make it easier for HR professionals to recognize patterns and build proactive people strategies around them, as well as swiftly discover insights that will improve recruiting, optimize workplace management, and boost employee performance.

Dataset Used

  • The dataset is in CSV format, and it is cleaned and processed for analysis with the help of Microsoft Excel's built-in feature Power Query.

Analyses derived from the dataset

  • Criterion for promotion of employees with a Bachelor's degree and Doctorate degree.
  • Requirements for salary hikes for personnel in the Tech support and Sales and Marketing divisions.

image

  • Gender breakdown of total number of employees working in the firm.

image

  • A clustered bar chart of the five departments in the organization with the most employees.

image

  • A gender-based examination of the total number of employees by their educational credentials.

image

  • Doughnut chart illustrating the marital status of the entire workforce of the organization.

image

  • Salary distribution of full-time and part-time employees.

image

  • Active and inactive employees

image

  • 2-D column chart that transitions between total workers by business unit and salary compensation to those business units.

  • The number of employees by job profile is highlighted in 3 cards at the bottom, as is a tabular view of job classifications by educational qualifications.

Active filters needed to interact with the data and the dashboard

Department and gender

image

Tools Used

Microsoft Excel

  • Utilized Power Query to extract and transform raw unstructured data into structured data in tabular form.
  • Generated Pivot tables to compile key HR data and reports.
  • Developed a series of useful Excel macros for automating the display and concealment of job categorization cards with tabular information.
  • Automated manual filter removal using macros and VBA.
  • Excel formulae such as IF, COUNTA, and IF AND functions were used to perform transition chart analysis and employee promotional analysis, respectively.

Overview

image

image

overview1

overview2

About

A dashboard that provides a dynamic slice-and-dice overview of an organization's workforce, including departments, absences, and educational credentials.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published