Overview

The Atlas Labs HR Analytics Dashboard is a powerful tool designed to visualize and analyze employee data, including demographics, performance tracking, and attrition rates. The dashboard is built using Power BI Desktop to empower HR teams with actionable insights.

Dataset Structure

Fact Table

• Contains performance review data, including:

• PerformanceID: Unique identifier for performance reviews.

• EmployeeID: Links to employee details.

• ReviewDate: Tracks review dates.

• EnvironmentSatisfaction: Employee satisfaction ratings regarding their environment.

• Serves as the central table for performance analysis.

Dimension Tables

• Employee: Stores employee-specific details such as demographics and job information.

• EducationLevel: Categorizes employee education qualifications.

• RatingLevel: Defines performance or satisfaction rating levels.

• SatisfiedLevel: Describes satisfaction levels for different aspects of work.

• Date: Provides a calendar-based reference for filtering and trend analysis.

Schema Used

Snowflake Schema: The dashboard implements a Snowflake Schema for efficient data storage and organization. The fact table is normalized, and multiple dimension tables are used for scalability and simplified querying.

Features

• 👥 Employee Demographics: Visual representation of employee age, gender, marital status, and ethnicity.

• 📈 Performance Tracker: Track employee performance metrics over time, including job satisfaction and manager ratings.

• 📉 Attrition Analysis: Detailed analysis of employee attrition rates by department, job role, and other factors.

• 📊 Hiring Trends: Insights into hiring trends across different departments.

Data Insights

👨‍💻 Total Employees: 1470

👩‍💼 Active Employees: 1233

❌ Inactive Employees: 237

📉 Attrition Rate: 16.1%

🗓️ Age Range: Youngest employee is 18 years old, oldest is 51 years old.

Demographics Breakdown

⚖️ Gender Distribution:Female: 42.45%
Male: 37.35%
Non-Binary: 20.2%

💍 Marital Status:Married
Single
Divorced

🌍 Ethnicity and Average Salary:White: Average Salary $115.3K
Black or African American: Average Salary $101.7K
Asian or Asian American: Average Salary $106.1K

Key Insights Uncovered

🎯 Age Distribution: The majority of employees at Atlas Labs are between 20-29 years old.

🔢 Gender Ratio: Atlas Labs employs 2.7% more women than men.

🌈 Non-Binary Representation: Employees who identify as non-binary make up 8.5% of the total workforce.

💰 Average Salary by Ethnicity: White employees have the highest average salary, while those identifying as mixed or multiple ethnic groups have one of the lowest average salaries.