Skip to content

Jayanth-Pujar/HR-Analytics

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

3 Commits
 
 
 
 
 
 

Repository files navigation

🚀 HR Attrition Analytics Dashboard 📊

Dashboard

Explore the comprehensive HR Attrition Analytics Dashboard designed for deep insights into employee dynamics.

🛠️ Tools Utilized

  1. Power BI 💼
  2. Excel 📈
  3. Statistical Analysis 📉

🔍 The Four Components:

  1. Demographic Overview: Delve into essential employee statistics—age groups, gender, distance from home, and marital status. Gain insights into workforce diversity and commuting patterns.

  2. Turnover Analysis I: Explore detailed insights into employee attrition, including departures by department, affected job roles, business travel impact, and total years in the current role. Craft effective workforce management and retention strategies.

  3. Turnover Analysis II: Consolidated employee data, featuring attrition by job level, overtime performance ratings, monthly income, and attrition increase levels. Informing critical HR strategies and decision-making.

  4. Employee Wellness Insights: A detailed analysis of attrition by job level, overtime performance ratings, monthly income, and attrition increase levels. Offering essential insights for strategic HR decision-making.

🛠️ Tasks Accomplished:

  1. Data Cleaning Procedures:

    • Removal of redundant columns.
    • Column renaming for clarity.
    • Elimination of duplicates.
    • Individual column refinement.
    • Handling NaN values.
    • Implementing additional transformations.
  2. Data Visualization Highlights:

    • Creation of a correlation map for numeric variables.
    • Visualizations for Overtime, Marital Status, Job Role, Gender, Education Field, Department, and more.
    • Exploration of the relationship between Overtime and Age, Total Working Years, Education Level, Number of Companies Worked, and Distance from Home.

📜 Dashboard Overview:

  • The first page serves as an overview of the four analytical components. Subsequent pages offer detailed insights into demographics, Turnover Analysis I, Turnover Analysis II, and Employee Wellness. Navigate through the pages for a comprehensive understanding.

    Dashboard Image

  • The Second page serves as an deep information of key employee details like age, gender, distance from home, and marital status. Understand workforce diversity and commuting habits for valuable insights.

    image

  • The Third Page Review combined employee information, including Dive into a thorough understanding of employee attrition, examining departures by department, impacted job roles, business travel influence, and total years in the current role. Use this information to create effective workforce management and retention strategies.

    image

  • An in-depth examination of attrition based on job level, overtime performance ratings, monthly income, and attrition increase levels. Providing vital insights for making strategic HR decisions.

    image

  • This Last Page gives information about the employees involvement in job and the satisfaction based on the environment.

    image

DashBoard Videos:

Page 1:

PAge1.mp4

Page 2:

https://github.com/Jayanth-Pujar/HR-Analytics/assets/148257677/0fe1aa8d-5765- 41be-8c2a-9dda06feaa2d

Page 3:

Page.3.mp4

Page 4:

Page.4.mp4

Page 5:

Page.5.mp4

🔗 My Other Projects Links:

  1. :dependabot: https://github.com/Jayanth-Pujar/Sales-Data-Analysis.git

About

A report that summarizes employee details

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published