Employee Distribution Dashboard

Project Overview

Employee Distribution Dashboard

Summary of Findings

Business Impact

Next Steps

Welcome to the Employee-Distribution! This repository contains valuable insights and visualizations derived from an extensive HR dataset spanning from 2000 to 2020, with over 22,000 rows. The data was meticulously cleaned and analyzed using PostgreSQL, and the results are beautifully visualized with Power BI. This comprehensive dashboard aims to answer crucial HR-related questions and shed light on various aspects of the organization's workforce.

Gender Diversity: The company has more male employees than female employees.

Race/Ethnicity: White employees constitute the majority, while Native Hawaiian and American Indian employees are the least represented.

Age Diversity: Employees' ages range from 20 to 57, with the majority falling within the 25-34 age group.

Work Locations: A considerable number of employees work at the headquarters compared to remote locations.

Termination Tenure: The average length of employment for terminated employees is around 7 years.

Gender Balance in Departments: While gender distribution across departments is fairly balanced, male employees slightly outnumber female employees in most departments.

High Turnover Departments: The Marketing department experiences the highest turnover rate, followed by Training. Research and Development, Support, and Legal departments have the lowest turnover rates.

Employee Geographic Distribution: A significant number of employees hail from the state of Ohio.

Employee Count Trends: Over the years, the company's employee count has been on the rise.

Tenure Variation by Department: The average tenure for each department is approximately 8 years, with Legal and Auditing having the highest, and Services, Sales, and Marketing having the lowest.

The Employee Distribution Dashboard is a strategic tool that enables organizations to make informed decisions, optimize their workforce, and achieve better resource allocation. Its impacts extend across workforce planning, cost optimization, talent management, employee engagement, and diversity and inclusion efforts. In today's dynamic business environment, having such a dashboard is a critical asset for ensuring the alignment of your workforce with your strategic goals.

While this dashboard offers valuable insights, it's essential to be aware of its limitations:

Some records with negative ages were excluded during querying (967 records). Ages used were 18 years and above.

Some term dates were too far into the future and were not included in the analysis (1599 records). Only term dates up to the current date were considered.

Source : Employee Distribution Dashboard by Tushar Aggarwal