Skip to content

Weekly report dashboard builder

Week-on-week KPIs, what got done, what is planned and what is blocked. Update the numbers each Friday and download the slide.

New here? — takes 2 minutes.

Weekly KPI report

Week-on-week performance — Week 38

Orders

3,284
+4.1% WoW

Revenue

$486k
+3.6% WoW

Conversion rate

3.2%
+0.1 pts

Support backlog

142
−18

Revenue by week ($k)

This yearLast year
360
400
440
480
520
486437
W31W32W33W34W35W36W37W38

Orders by channel, week 38

3.3kOrders
Web1.8k 56%
App912 28%
Marketplace364 11%
Phone168 5%

KPIs this week vs last

KPIWeek 38Week 37ChangeTargetStatus
Orders, good3,2843,155+4.1%3,200On target
Average order value, warning$148$149−0.7%$150Watch
Conversion rate, good3.2%3.1%+0.1 pts3.0%On target
Returns rate, critical6.8%6.1%+0.7 pts≤ 6%Off target
First response time, good3.4 h4.1 h−0.7 h4 hOn target

4 Weekly Report 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.

Week-on-week change
(This week − last week) ÷ last week × 100.
On-time rate
Tasks finished by their due date ÷ tasks due this week × 100.
Velocity
Story points completed in a sprint; average the last three sprints to plan the next one.
Commitment reliability
Points completed ÷ points committed at sprint start × 100.
Carry-over
Points committed but not completed, moved to the next sprint.
Backlog
Open items at week end; the change shows whether the team is keeping up with intake.

How to make your Weekly Report 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. 1

    Pick your dashboard

    Click Pick Your Dashboard. This dashboard has 4 ready-made layouts, such as Weekly KPI report and Weekly status report. Each opens finished, with example figures.

  2. 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. 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. 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. 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 goes in a weekly status report?

Three lists — done this week, planned next week, blockers with the decision needed — and a few KPIs with week-on-week change. The weekly status report template is laid out that way.

Which KPIs suit a weekly report?

Ones that move within a week: orders, revenue, conversion, backlog, tickets, on-time rate. Leave slow-moving measures such as churn or engagement for the monthly report.

Is there a weekly report template for PPT?

Yes. Each template downloads as an editable PowerPoint slide with native charts and tables.

What about a biweekly report?

Use the biweekly sprint report template for two-week sprints, or relabel the weekly KPI report's periods to fortnights.

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.