π Employee Performance Dashboard This repository showcases a professional HR Analytics Dashboard to track Employee performance created using Power BI, focusing on evaluating and visualizing employee performance metrics for effective workforce management.
π Dashboard Overview: The dashboard provides deep insights into key performance indicators such as:
π₯ Total Employees, Average Rating, Productivity Score, and Goal Achievement
π Performance by Department & Job Role
π Learning Score & Training Completion Rate
π§ 360Β° Feedback and Appraisal Comments
π¨ Risk Monitoring through Disciplinary Actions, Probation, and Warnings
π KPI Achievement and Absenteeism Rate by Department
β Training Recommendation Breakdown for skill development
π Performance Plans to manage underperformance
π Data Source: The dataset was created in Microsoft Excel, simulating realistic employee records including job roles, departments, performance ratings, learning scores, absenteeism, feedback, and training data. This data was cleaned, structured, and imported into Power BI for interactive visualization.
π― Objective: To help HR teams and leadership make data-driven decisions by identifying strengths, risks, and improvement areas across departments β ultimately improving productivity and employee engagement.
βοΈ Tools Used:
- Power BI
- Excel
- HR Analytics Metrics
β Key Questions Such as -
- What is the overall performance rating of employees in the organization?
- How productive are employees across different departments and job roles?
- Which departments have the highest or lowest goal achievement rates?
- What is the average productivity score company-wide?
- How does performance vary between job roles?
- What are the training completion rates across departments?
- Which departments are most engaged in learning activities?
- What kind of feedback do employees receive in appraisals?
- How many employees are currently on Performance Improvement Plans (PIPs)?
- What is the department-wise distribution of disciplinary actions and risk factors?
- Which departments have the highest absenteeism rates?
- How does KPI achievement vary across departments?
- What skills or training programs are most frequently recommended?
- Are there any departments that require immediate HR attention due to underperformance?
- How can the organization improve employee engagement and development through data?
π§© Business Problem- Organizations often struggle to monitor employee performance effectively due to scattered data, lack of real-time insights, and poor visibility into individual and departmental productivity. Without a centralized system to track KPIs like performance ratings, goal achievements, learning engagement, absenteeism, and disciplinary actions, HR teams face challenges in: -Identifying underperforming employees in time -Recognizing top talent for rewards or promotions -Aligning training programs with performance gaps -Understanding department-wise productivity and risks -Making data-driven decisions to improve retention and development This lack of structured performance data leads to low employee engagement, reduced productivity, and inefficient HR interventions.
β Solution- The Employee Performance Dashboard provides a centralized, interactive, and data-driven view of workforce performance. It enables leadership and HR to make informed decisions based on real-time metrics, helping them:
- Recognize patterns in employee behavior and output
- Take timely action on risks like absenteeism or disciplinary issues
- Align performance with training needs
- Improve overall organizational productivity and morale
Screenshot/Demo- Screenshot- https://github.com/Shamika25/Emp-Performance-Dashboard/blob/main/Final%20Emp%20Performance%20Dashboard.png