Skip to content

joyceleehy/Employee-Performance-Dashboard-PowerBI

Repository files navigation

Employee Performance Dashboard | Power BI

Project Overview

This Employee Performance Dashboard was created using Power BI Desktop to analyze workforce demographics, employee productivity, performance ratings, satisfaction, engagement, career growth, and workforce cost.

The dashboard includes two report pages: a demographics overview page and a performance analysis page. Together, they provide HR teams with insights into employee distribution, productivity levels, engagement patterns, salary bands, workforce cost, and performance categories.

Dashboard Preview

Demographics Overview

HR Performance Dashboard Demographics

Performance Overview

HR Performance Dashboard Performance

Key Highlights

  • Total employees analyzed: 6,041
  • Active employees: 6,009
  • Turnover rate: 0.53%
  • Annual workforce cost: 204.40M
  • Average salary: 27.25K
  • Average productivity score: 74 / 100
  • Average performance rating: 3.91 / 5
  • Average satisfaction score: 7.45 / 10
  • Average engagement index: 7.43 / 10

Dashboard Insights

  • Most employees are full-time, representing the largest employment type group.
  • The workforce has a strong concentration in the 26-35 and 36-45 age groups.
  • Male employees represent a larger share of the workforce compared to female employees.
  • Employee headcount increased significantly over recent years, especially around 2019 to 2021.
  • Most employees fall into good performance and satisfied employee categories.
  • Poor career growth appears as the largest career growth category, which may require HR attention.
  • Entry and associate job levels contribute the highest total monthly bonus amounts.
  • Performance and productivity can be analyzed by age group, department, education level, job level, gender, status, and state.

Business Impact

This dashboard helps HR and management teams:

  • Monitor workforce size, active employees, and turnover rate
  • Understand employee demographics and workforce distribution
  • Analyze productivity, performance, satisfaction, and engagement levels
  • Identify potential career growth and retention concerns
  • Support workforce planning, compensation review, and talent development decisions

Recommendations

  • Review career growth opportunities, especially for employees categorized under poor or fair career growth.
  • Monitor satisfaction and engagement scores regularly to identify early employee experience risks.
  • Analyze productivity and performance by department and job level to identify improvement areas.
  • Review bonus distribution by job level to support compensation fairness and workforce planning.
  • Use demographic filters to compare employee trends across age group, gender, state, education level, and job level.

Suggested Actions

  • Create targeted career development programs for employees with limited growth opportunities.
  • Conduct employee engagement surveys to understand satisfaction and motivation drivers.
  • Review productivity trends by employee segment and identify training needs.
  • Track performance KPIs monthly to support HR leadership reporting.
  • Use the dashboard to guide workforce planning and employee development discussions.

Tools Used

  • Power BI Desktop
  • Data Visualization
  • HR Analytics
  • Employee Performance Analysis
  • Workforce Analytics
  • Business Intelligence
  • Dashboard Design

Files Included

  • HR_Performance_Dashboard_Demographics.png - Demographics dashboard preview
  • HR_Performance_Dashboard_Performance.png - Performance dashboard preview

Note

The Power BI .pbix file is not included because the dataset privacy status has not been fully confirmed.

About This Project

This project was created as part of my data analytics portfolio to demonstrate skills in Power BI dashboard design, HR analytics, employee performance analysis, workforce reporting, KPI visualization, and business intelligence storytelling.

About

Power BI dashboard analyzing employee performance, productivity, engagement, workforce demographics, and HR operational insights.

Topics

Resources

Stars

Watchers

Forks

Releases

Packages

Contributors