HR Analytics Dashboard | SQL & Power BI

This dashboard supports:

✔ Workforce Planning

✔ Promotion Strategy Optimization

✔ Retrenchment Risk Monitoring

✔ Diversity & Inclusion Tracking

✔ Employee Satisfaction Analysis

-- Page 1: Home

A snapshot of the organization at a glance:

Key KPIs:

Total Employees

Male vs Female Distribution

Visual Insights:

• Employees by Job Level

• Distance from office Analysis

• Active Workers

• Employees Due for Promotion

• Employees Not Due for Promotion

• Next Retrenchment

-- Page 2: Action

Here we move from overview to decision-making:

Analytical Views:

• Employees by Job Satisfaction

• Due for Retrenchment & Due for Promotion by Department

• Employees by Overtime

• Employees by Marital Status

Summary Table Includes:

• Total Employees

• Due for Retrenchment

• Due for Promotion

-- Page 3: Employee-Level Details

A focused operational view including:

✔ Total Employees

✔ Gender Distribution

✔ Detailed table of employees Due for Retrenchment

✔ Detailed table of employees Due for Promotion