Code Monkey home page Code Monkey logo

employee-distribution's Introduction

Employee-Distribution

Power Bi Postgres Microsoft Excel Canva

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.

Screenshot 2023-07-19 154829

Key Questions Explored

  1. Gender Breakdown: Gender distribution of employees within the company.
  2. Race/Ethnicity Breakdown: Racial and ethnic composition of the workforce.
  3. Age Distribution: Insights into the age distribution of employees.
  4. Headquarters vs. Remote Locations: Understanding the number of employees working at headquarters versus remote locations.
  5. Average Employment Length for Terminated Employees: Finding out the average tenure of terminated employees.
  6. Gender Distribution across Departments and Job Titles: Seeing how gender distribution varies across different departments and job titles.
  7. Distribution of Job Titles: Exploring the distribution of job titles across the company.
  8. Highest Turnover Rate by Department: Identifing the department with the highest turnover rate.
  9. Distribution of Employees across Locations (by State): Learning about the geographic distribution of employees across different states.
  10. Employee Count Changes over Time: Tracking changes in the company's employee count over the years based on hiring and termination dates.
  11. Tenure Distribution by Department: Examining the tenure distribution for each department.

Summary of Findings

Here are some key findings derived from the HR data analysis:

  • 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.

Limitations

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.

Getting Started

To get started with the HR Data Dashboard and explore the rich visualizations and findings, you can follow these steps:

  1. Clone this repository to your local machine.
  2. Ensure you have the necessary tools installed, such as PostgreSQL and Power BI, to analyze and visualize the data effectively.
  3. Load the provided dataset into your MySQL database.
  4. Open the Power BI file (.pbix) to interact with the pre-built visualizations and answer the key HR questions.

I hope you find this HR Data Dashboard insightful and valuable for your organization's HR planning and decision-making processes. Should you have any questions or feedback, feel free to reach out. Happy analyzing!

Author

Contact me!

If you have any questions, suggestions, or just want to say hello, you can reach out to us at Tushar Aggarwal. We would love to hear from you!

employee-distribution's People

Contributors

tushar2704 avatar

Recommend Projects

  • React photo React

    A declarative, efficient, and flexible JavaScript library for building user interfaces.

  • Vue.js photo Vue.js

    🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.

  • Typescript photo Typescript

    TypeScript is a superset of JavaScript that compiles to clean JavaScript output.

  • TensorFlow photo TensorFlow

    An Open Source Machine Learning Framework for Everyone

  • Django photo Django

    The Web framework for perfectionists with deadlines.

  • D3 photo D3

    Bring data to life with SVG, Canvas and HTML. 📊📈🎉

Recommend Topics

  • javascript

    JavaScript (JS) is a lightweight interpreted programming language with first-class functions.

  • web

    Some thing interesting about web. New door for the world.

  • server

    A server is a program made to process requests and deliver data to clients.

  • Machine learning

    Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.

  • Game

    Some thing interesting about game, make everyone happy.

Recommend Org

  • Facebook photo Facebook

    We are working to build community through open source technology. NB: members must have two-factor auth.

  • Microsoft photo Microsoft

    Open source projects and samples from Microsoft.

  • Google photo Google

    Google ❤️ Open Source for everyone.

  • D3 photo D3

    Data-Driven Documents codes.