NHS QUESTIONS

How Do You Build a Dashboard for an NHS Team?

Start with one decision your team needs to make, then use figures you can check against an agreed source. If a shared report already gives people what they need, use it before building a new dashboard.

When colleagues need to open the same view regularly, IntelliFront BI gives them a place to find the dashboards and measures they use.

  
The first decision

Start with what the team needs to decide

Imagine a community physiotherapy team looking back at last week’s clinics. The service lead sees two cancelled sessions in a spreadsheet. The bookings coordinator needs to know whether anyone affected is still waiting for a new appointment. The session total tells the lead what happened last week. The appointment list tells the coordinator who still needs a new date.

That gives you a useful brief for the first screen. Show how many sessions went ahead, then show how many affected appointments still need a new date. Ask the service lead and coordinator to walk through a real meeting or handover before you choose a chart. You’ll hear which figures they use and which questions they still have to answer elsewhere.

Write down the question

“After last week’s cancellations, which clinic should we follow up first?” gives you a clearer brief than “Show us clinic performance.” Ask the person who’ll open the dashboard to put it in their own words.

  
Choose the measures

Agree what each number counts

A dashboard for an NHS team can make cancelled sessions easier to follow up. In this example, 10 of 12 scheduled sessions went ahead. The service cancelled the other two. Six appointments from those cancelled sessions still need a new date as of Monday at 8:00 am. Count sessions and appointments separately. A cancelled session can affect several appointments, and one appointment can be rearranged after the week ends.

Give each figure a name that explains what it counts. “Sessions held last week” belongs next to “Appointments still to rearrange as of Monday, 8:00 am.” Agree which clinic sites and cancellation reasons to include. Check both figures against the clinic schedule and booking report for the same scope.

Give each visual a job

Put the outstanding appointment count where the coordinator can find it. Use a table by clinic to show where to start. A trend can wait until the team needs to compare several weeks.

  
Build the first view

Use a dashboard when the team needs one

A shared worksheet or a view in the booking system may already be enough for a short weekly meeting. Keep it if people can find it, agree what the figures mean and see when they were last checked.

If staff keep asking for different site totals or sending copies of the same figures, a shared dashboard can give them one place to go. In IntelliFront BI, build the view from an approved dataset and use a headline measure or a grid to match the task. If people need to open several dashboards and key measures together, you can bring them into an IntelliFront BI Canvas. IntelliFront BI dashboard guide. IntelliFront BI Canvas guide.

For this team, the shared view can show counts by clinic. The bookings coordinator can use the approved booking system to find and rearrange individual appointments.

Start where you can check the figures

Bring one week of agreed figures to the first review. If the view and the booking report disagree, resolve that before adding more clinics or measures.

  
Check the dashboard

Try it with the people who’ll use it

Give a colleague the link and ask which clinic they’d follow up first. Can they tell which week the session figures cover? Can they explain when the outstanding count was taken? If either answer takes a conversation with the author, change the label and ask them to try it again.

Check the dashboard with a member of each intended audience. Make sure they can open the right view and that any linked reports have the access you expect. Give someone responsibility for checking the figures and explaining changes after launch.

Checks to run before you share the dashboard
  • Reconcile the session count and the outstanding appointment count separately against the agreed sources.
  • Try a clinic with no outstanding appointments and a clinic with missing data. Give each a label colleagues can tell apart.
  • Test the same period and site filters that readers will use.
  • If you display a data timestamp, check that it means what the label says. A source cutoff and the time someone opened the view are different.
  • Open the view and follow its links with the access of an intended reader.

Make the owner easy to find

Put a team name or shared mailbox alongside the refresh information. When a number looks wrong, colleagues should know where to ask.

  
Keep it useful

Let the first dashboard earn its place

At the next review, the service lead can see how many sessions went ahead. The coordinator can see where appointments still need a new date and go straight to the booking system. Those two jobs are enough for the first dashboard.

Bring one question from a meeting you already run and one source report you can check. If you’re evaluating IntelliFront BI, use the guide to plan the first dashboard. The NHS hospital pharmacy dashboards show how colleagues can have views for the work they do.

Download the IntelliFront BI Internal Evaluation Guide

Contributors:

Christian Ofori-Boateng

Christian Ofori-Boateng

CEO, ChristianSteven Software