NHS QUESTIONS

How Can You Keep an NHS Dashboard Up to Date Without Rebuilding the Spreadsheet?

Keep the dashboard and refresh the data it reads. Start with a report or export your team already trusts, agree when it should arrive, and show readers what time the figures cover.

If several colleagues need that same view, IntelliFront BI can display it in a shared dashboard while the source team keeps producing the data.

  
Keep the dashboard

Find the work you repeat every morning

Imagine the estates team at an NHS hospital. Before the morning handover, the coordinator exports the open maintenance jobs, pastes them into a workbook and checks whether the chart still covers the whole list. Someone then sends the workbook to the supervisors. Tomorrow the same people will do it again.

The chart still helps the supervisors see where the open jobs are. The work to remove is the daily copying, chart checking and distribution. Start by keeping one view of open jobs by site, then make it read a consistent set of source records.

Keep the useful part

Open yesterday’s workbook with someone who uses it. Ask which figure helps them during handover and which tabs they rarely open. Move the part people rely on first.

  
Choose the source

Give the figures one place to come from

To keep an NHS dashboard up to date, start with what the source system already produces. If it can deliver an approved export, agree where the file will arrive, which sheet holds the data and which columns the dashboard needs. At the estates handover, that might mean a single list with job reference, site and status. Confirm whether a blank list means there are no open jobs or the export failed.

If one maintained workbook already serves the team, a refreshable Excel connection may be enough. Power Query can bring updated data into an existing workbook, and supported Excel connections can be set to refresh when the file opens. That still depends on the source being available. Microsoft’s guide to refreshing data in Excel.

Agree who does what

Name who produces the export and who checks the dashboard. If the file is late, each person knows which part of the handover they can put right.

  
Set the timing

Refresh after the export arrives

Suppose the export covers open jobs as of 7:15 am, the file is usually ready by 7:30 am and the supervisors meet at 8:30 am. Have the dashboard pick up the new data after the export is ready. When the two steps are on separate schedules, allow time for ordinary delays and check which file was actually used.

IntelliFront BI can read an Excel file through a dataset. In this example each new export is a full list of open jobs, so use the option to overwrite existing cached data. If you keep appending full lists instead, a job that is still open could be counted twice. Check the dataset refresh against the export the team expects. IntelliFront BI dataset setup guide.

Use a label people can act on

“Open jobs as of Monday, 7:15 am” tells a supervisor what the view covers. Use the time the source certifies. If you only know when an export arrived, say that instead.

  
Handle a late file

Agree what to do when today’s figures are missing

On Tuesday the source export runs late. The last good file is still Monday’s. If you choose to keep Monday’s figures available, label them clearly and point the team to its agreed fallback. If Monday’s figures can’t support Tuesday’s decisions, ask people to use the source system until the new figures are ready.

Test the late-file case before anyone depends on the view. Use a copy of the workflow and ask the coordinator to walk you through what they would tell the supervisors. You can learn a lot from whether they hesitate at the first screen.

Checks to run before the first handover
  • Open a known export and reconcile the open-job count for one site against the source.
  • Test an export that arrives late and confirm which dated figures appear.
  • Test a confirmed zero-job export, a missing file and a file with a required column missing. Make sure only the first case is shown as zero open jobs.
  • Check the view as an intended reader and confirm who will investigate a missed update.

Keep the distinction visible

An empty list can be good news. A missing file means you don’t yet know the answer. Give the two cases different labels.

  
Your next step

Try it with one report you already trust

At the next handover, the supervisors open the same view and can tell which export it reflects. The coordinator can spend that time checking exceptions instead of rebuilding the chart. Begin with one daily export, one count you can verify and one colleague who will use it.

If you’re evaluating IntelliFront BI, use the guide to plan how the view will use the latest approved export. The NHS pharmacy reporting evaluation covers what to discuss with IT about refresh arrangements and who will maintain them.

Download the IntelliFront BI Internal Evaluation Guide

Contributors:

Christian Ofori-Boateng

Christian Ofori-Boateng

CEO, ChristianSteven Software