Attendance and leave dashboard builder
Absence, leave, lateness and timesheet hours in one view. Replace the sample with your figures or a CSV, then download the slide.
New here? — takes 2 minutes.
Leave and absence dashboard
Days lost
Holiday liability
Untaken days
Absence against holiday taken
Absence by reason
Absence rate by department
Holiday taken against entitlement
Edit widget
Your data
4 Attendance Dashboard templates
Every template opens as a finished dashboard. Pick the closest one, then change anything.
Metrics and how to calculate them
The KPIs these templates are built on, with the formula behind each one.
- Absence rate
- Working days lost to absence ÷ total scheduled working days × 100.
- Attendance rate
- Days (or sessions) attended ÷ days scheduled × 100.
- Bradford factor
- S² × D, where S is the number of absence spells and D the total days absent in 12 months.
- Holiday liability
- Accrued but untaken leave days × average daily pay cost, as at the reporting date.
- Chronic absence
- Students or employees missing 10% or more of scheduled days ÷ all enrolled × 100.
- Overtime share
- Overtime hours ÷ total hours worked × 100.
- Timesheet compliance
- Timesheets submitted by the deadline ÷ timesheets due × 100.
How to make your Attendance Dashboard
Pick a template, put your numbers in, download — about two minutes. Nothing to install; the PDF and every other format come with a SlideTeam plan.
- 1
Pick your dashboard
Click Pick Your Dashboard. This dashboard has 4 ready-made layouts, such as Leave and absence and Daily attendance and punctuality. Each opens finished, with example figures.
- 2
Change the numbers
Point at any widget (tap it on a phone) and choose Edit to type or paste its numbers and labels — a column copied from Excel pastes straight in. Click the dashboard's title to rename it.
- 3
Use your own data
Upload CSV or Excel takes a CSV, .xlsx or .xls file and shows exactly what it read: pick the sheet, the label column and how repeated rows are combined (sum, average, count), then Build a new dashboard or Fill this template with your columns. Not sure of the layout? Download the sample CSV and replace the numbers.
- 4
Download PDF, PowerPoint, Excel and more
Download (right end of the toolbar) lists every format: a PDF (free), PowerPoint with native charts you can still edit (right-click › Edit data), a report pack (summary slide plus one slide per chart) as PowerPoint or PDF, Excel (opens on a Dashboard sheet with live charts) and a CSV for Power BI, Tableau or Google Sheets.
- 5
More options: add widgets, brand it, share
More options (top right) shows the rest: Add widget puts in a chart, KPI tile, table, funnel or a Text / commentary box; the arrows on a widget move it and ✕ removes it; click the subtitle to edit it. Customise sets the currency, template language, slide size, brand colour and logo. Sheets / Slides shows how to open your file in Google Sheets or Slides; Share copies a link to this exact dashboard.
Common questions
What is the difference between an attendance and an absenteeism dashboard?
Attendance shows who was present and on time; absenteeism focuses on unplanned absence, its causes and repeat patterns, often using the Bradford factor. The Daily attendance template covers both.
How should a leave dashboard be designed?
Lead with absence rate and days lost, add holiday liability so finance sees the cost of untaken leave, then break absence down by reason and department. That is the layout of the Leave and absence template.
Can I use this for student attendance?
Yes. The Student attendance template tracks daily rate, chronic absence by grade and a follow-up list that uses student IDs rather than names.
How do I load data from a time and attendance system?
Export a daily or weekly summary to CSV and upload it; each numeric column becomes a chart series.
Goes well with this — from our other free tools
The figures in the example dashboards are illustrative and exist so each page shows a finished dashboard rather than an empty grid. Replace them with yours before sharing anything.

SlideTeam