Skip to content

Dashboard templates

Healthcare · HR

Clinic or clinic chain with doctors, nurses and receptionists at each facility plus a head office. Visits, service revenue and wait times, plus average headcount, terminations, payroll cost, overtime, recruiting and visits per employee.

Free plan with no time limit · No card required · Sample workspace ready in minutes

For HR managers at clinics and clinic chains with doctors, nurses and front desk staff at each location. The "Headcount and visits" dashboard shows visits per employee, payroll cost per visit and payroll cost as a share of service revenue. The "Headcount and attrition" and "Payroll cost and recruiting" dashboards track attrition, absence, overtime and time to hire. Needs location, doctor, visit, service fee and employee data.

Use this template to

  • Rebalance staff across locations by visits per employee.
  • Know what share of visit revenue goes to payroll when planning salaries.
  • Track which location works the most overtime in peak season.

5 ready-made dashboards

Headcount and visits

Visits against average headcount, payroll cost over service revenue and per visit, and overtime by facility.

  • Visits per employee
  • Payroll cost to service revenue
  • Payroll cost per visit
  • Average headcount
  • Monthly visits per employee
  • Monthly payroll cost over revenue
  • Overtime hours by facility

Headcount and attrition

Average headcount, new hires, leavers and attrition rate by department.

  • Average headcount
  • New hires
  • Terminations
  • Turnover rate
  • Headcount movement by department
  • Attrition rate by department
  • Monthly leavers by department

Payroll cost and recruiting

Payroll, overtime, absence costs and recruiting effectiveness.

  • Payroll cost
  • Overtime hours
  • Absence rate
  • Offer acceptance rate
  • Monthly payroll cost by department
  • Weekly overtime hours by department
  • Recruiting by department

Clinic overview

Visits, patients, service revenue and insurance-covered share by facility and specialty.

  • Visits
  • Unique patients
  • Service revenue
  • Revenue per visit
  • Weekly visits by facility
  • Monthly visits by specialty
  • Results by facility
  • Revenue by service group
  • Insurance-covered share by patient type

Appointment operations

No-show rate, cancellations, wait time and doctor productivity by facility, specialty and doctor.

  • Appointments
  • No-show rate
  • Average wait time (minutes)
  • Visits per doctor day
  • No-show rate by facility
  • Average wait time by facility
  • Weekly wait time by facility
  • Productivity by doctor
  • Follow-up visit share by specialty

Ask Si as soon as the build finishes

  • “How did payroll cost per visit change compared with last month?”
  • “What is driving payroll cost to service revenue this quarter?”
  • “Show visits per employee by month for the last six months.”
  • “Where is absence days highest this month, and why?”

33 defined metrics

Versioned definitions, shared by dashboards, Si, reports and MCP.

MetricDefinitionUnit
Payroll cost per visitPayroll cost (salary, allowances, overtime, employer-paid insurance) divided by the number of completed visits in the period.= Payroll cost / VisitsCurrency
Payroll cost to service revenuePayroll cost (salary, allowances, overtime, employer-paid insurance) divided by clinic service revenue across all facilities.= Payroll cost / Service revenueRatio (%)
Visits per employeeCompleted visits in the period divided by average headcount (permanent staff) for the period.= Visits / Average headcountNumber
Absence daysNumber of scheduled working days on which employees were absent (annual leave, sick leave, unpaid leave, other).Count
Absence rateAbsence days divided by scheduled working days.= Absence days / hr_scheduled_daysRatio (%)
ApplicantsNumber of candidates who applied in the period (by application date).Count
Average headcountAverage number of active employees per day in the period.= hr_headcount_days / hr_snapshot_daysNumber
Average monthly cost per employeePayroll cost divided by the number of payslips (one employee-month each).= Payroll cost / hr_payslipsCurrency
New hiresNumber of employees with a start date in the period.Count
Offer acceptance rateOffers accepted divided by offers sent in the period.= hr_offers_accepted / Job offers sentRatio (%)
Job offers sentNumber of candidates sent a job offer in the period (by offer date).Count
Overtime hoursTotal overtime hours recorded in timesheets.Number
Payroll costTotal employer cost of personnel: base salary, allowances, overtime pay and employer-paid insurance. Payroll is recorded monthly, on the first day of the month.Currency
TerminationsNumber of employees whose last working day falls in the period, both voluntary and involuntary.Count
Average time to hire (days)Average number of days from application to offer date for hired candidates, by offer date.= hr_hire_days_total / hr_offers_acceptedNumber
Turnover rateTerminations in the period divided by average headcount for the period.= Terminations / Average headcountRatio (%)
Voluntary terminationsNumber of employees who resigned, with their last working day in the period.Count
Voluntary turnover rateVoluntary terminations in the period divided by average headcount for the period.= Voluntary terminations / Average headcountRatio (%)
AppointmentsTotal appointments by appointment date, in every status (completed, no-show, cancelled).Count
Average wait time (minutes)Average minutes from check-in to the start of the consultation, over completed visits that have both timestamps.= hc_wait_minutes_total / hc_wait_measured_visitsNumber
Cancellation rateCancelled appointments divided by total appointments.= hc_cancellations / AppointmentsRatio (%)
Insurance-paid amountTotal amount covered by insurance (public health insurance and private insurance) in the service charges of completed visits.Currency
Insurance shareInsurance-paid amount divided by service revenue.= Insurance-paid amount / Service revenueRatio (%)
New patientsDistinct patients with a completed visit of type new (not a follow-up) in the period.Count
No-show rateNo-shows divided by (completed visits + no-shows). Appointments cancelled in advance are excluded.= No-shows / (Visits + No-shows)Ratio (%)
No-showsAppointments with the standard status no_show (the patient did not attend).Count
Patient-paid amountTotal service charges minus the insurance-paid amount, for completed visits.Currency
Follow-up visit shareFollow-up visits divided by completed visits.= hc_return_visits / VisitsRatio (%)
Service revenueTotal service charges of completed visits (insurance portion plus patient portion), by visit date.Currency
Revenue per visitService revenue divided by completed visits.= Service revenue / VisitsCurrency
Unique patientsDistinct patients with at least one completed visit in the period.Count
VisitsAppointments with the standard status completed, by visit date.Count
Visits per doctor dayCompleted visits divided by doctor days (days on which a doctor had at least one completed visit).= Visits / hc_doctor_daysNumber

Data you need

Required

clinic, doctor, visit, visit_charge, hr_employee

Add if you have it (unlocks more metrics)

patient, service, hr_payroll, hr_attendance, hr_candidate

Three steps to this dashboard

  1. 1

    Connect your data

    Upload an Excel file or connect a source with: clinic, doctor, visit, visit_charge, hr_employee.

  2. 2

    Approve Si's proposal

    Si proposes how to read your tables and map them to the industry's standard model; you fix anything highlighted and approve.

  3. 3

    Dashboards and Q&A

    The build gives you 5 dashboards and 33 metrics; ask Si anytime.

Data sources for this template

Connectors with a setup guide that feed the entities this template needs. Excel always works.

Related templates

Build Healthcare · HR with your own data

Free plan with no time limit · No card required · Sample workspace ready in minutes