Objective

Create an interactive HR analytics dashboard.

Data

  • Employee ID
  • Employee Name
  • Department
  • Designation
  • Salary
  • Attendance %
  • Performance Score
  • Joining Date
  • Gender
  • Location

KPIs

Total Employees

=COUNTA(Employee_Data[Employee ID])

Average Salary

=AVERAGE(Employee_Data[Salary])

Average Attendance

=AVERAGE(Employee_Data[Attendance %])

Average Performance

=AVERAGE(Employee_Data[Performance Score])

Dashboard Visuals

  • Employees by Department
  • Salary by Department
  • Attendance Analysis
  • Performance Analysis
  • Employee Joining Trend
  • Location-wise Employees

Add Slicers for:

  • Department
  • Designation
  • Location
  • Gender
PreviousNext