I will prepare Daily Attendance and Absenteeism Dashboard

(3)
prepare Daily Attendance and Absenteeism Dashboard
prepare Daily Attendance and Absenteeism Dashboard

About This Gig

An Excel Spreadsheet that enables to track attendance for approximately 50 employees of your company.

Able to add employee name to one place and it automatically populates on every month tab in workbook instead of having to add it manually.

  • Color coded key for different types of leave such as sick, vacation, no call, personal and other.
  • You can have multiple features such as Date wise viewTeam wise/Individual view.
  • Data entry for vacations taken by employees.
  • Additional advantages that you get from the dashboard--
  • Absent rate of employees (in any year or latest 3 month period).
  • Vacation patterns for individual employees (or teams).
  • On which dates most employees are absent?
  • Who is taking most (or least) vacation days?

Order Details

EXCLUSIVE

Spreadsheet that enables to track attendance for approximately 50 employees.

  • Model Validation/Testing
  • Model Documentation
  • 1 Graph/Chart
  • Data Source Connectivity
2 days delivery