HOME

HOME

HOME

ABOUT ME

ABOUT ME

ABOUT ME

PROJECTS

PROJECTS

PROJECTS

CONTACT

CONTACT

CONTACT

Atlas Labs

July 9, 2024
HRIS Analytics

Overview

This project aimed to create a comprehensive HRIS analytics report using Power BI for Atlas Labs. The primary objectives were to monitor key HR metrics and understand factors influencing employee attrition.

Key Insight

  1. Employee Demographics and Diversity

    • The majority of the age group: 20-29 years old.

    • Gender distribution: 2.7% more women than men.

    • 8.5% of employees identify as non-binary.

    • Diversity insights revealed salary discrepancies among ethnic groups, with mixed or multiple ethnic groups having lower average salaries.


  2. Attrition Analysis

    • Current employee count: over 1,200.

    • Attrition rate: 16%.

    • Identified factors impacting attrition include work-life balance, job satisfaction, and training opportunities.


  3. Departmental Insights:

    • Largest department: Technology.

    • Analysis of hiring trends showed significant growth in specific departments over time.


Data

Data Set

  • The project utilized fictitious datasets modeled in a snowflake schema, including:

  • Fact Table: Performance Ratings with 11 columns detailing yearly reviews.

    Dimension Tables: Employee, Education Level, Rating Level, Satisfied Level, and Date.

  • Case Study from Datacamp


Process

  1. Data Modeling

    • Used the Kimball Model approach to build a robust data model.

    • Created relationships between fact and dimension tables


  1. DAX Functions

    • Calculated key metrics such as WorkLifeBalance and NextReviewDate using DAX.


  1. Visualizations

    • Developed custom visuals to represent demographics, attrition rates, and departmental metrics.

    • Emphasized user-friendly design for easy interpretation by HR and leadership teams.

Data Set

  • The project utilized fictitious datasets modeled in a snowflake schema, including:

  • Fact Table: Performance Ratings with 11 columns detailing yearly reviews.

    Dimension Tables: Employee, Education Level, Rating Level, Satisfied Level, and Date.

  • Case Study from Datacamp


Process

  1. Data Modeling

    • Used the Kimball Model approach to build a robust data model.

    • Created relationships between fact and dimension tables


  2. DAX Functions

    • Calculated key metrics such as WorkLifeBalance and NextReviewDate using DAX.

    1. WorkLifeBalance =

    2. CALCULATE(

    3. MAX(FactPerformanceRating[WorkLifeBalance]),

    4.        USERELATIONSHIP(FactPerformanceRating[WorkLifeBalance], DimSatisfiedLevel[SatisfactionID])

Outcome

The final Power BI report provided Atlas Labs with actionable insights into their workforce, enabling better decision-making and strategic planning in HR. The report highlighted key areas for improvement, particularly in diversity and inclusion, and offered a comprehensive view of employee performance and satisfaction metrics.



The final Power BI report provided Atlas Labs with actionable insights into their workforce, enabling better decision-making and strategic planning in HR. The report highlighted key areas for improvement, particularly in diversity and inclusion, and offered a comprehensive view of employee performance and satisfaction metrics.

Conclusion

Recommendations

Recommendations

This HRIS analytics project demonstrates the power of data-driven decision-making in human resources. By leveraging Power BI, Atlas Labs can now monitor their HR metrics effectively and address the factors influencing employee retention and satisfaction.

Reports

Reports

Reports