/HR_Dashboard_Excel

HR Dashboard using Excel

HR_Dashboard_Excel

Built a HR Dashboard in Excel by following a YouTube tutorial Link

Problem statement

The HR manager wants a dashboard, where he can get all details about the employees in one place some major metrics needed are listed below,

  • Total number of employee
  • Full time and part-time employees ratio
  • Salary details
  • Gender ratio details
  • Hiring trend
  • Leave balance
  • Department details

Dashboard Snapshot

Excel file

Skills Learnt

  • Adding dynamic titles
  • Pivot tables
  • Using Dax to create measure along with pivot
  • Adding symbols based on the values for visual representation
  • Designing dashboard in Excel
  • Slicers formatting