The first decision
Start with what the team needs to decide
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.
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.
“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.
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.
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.
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.
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.
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.
Put a team name or shared mailbox alongside the refresh information. When a number looks wrong, colleagues should know where to ask.
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.
CEO, ChristianSteven Software