In this guide 6 sections
Managers stop opening a dashboard that answers questions they never ask, shows numbers they distrust or buries the figure they want on page nine. Silence is the fourth cause. Rescue it with one decision per role, a rebuild around that decision and an alert for the figure that matters, then see who opens it after thirty days.
It answers the wrong questions
Dashboards are often specified by whoever asked for them, usually from a list of everything the system can report; the result is a wall of charts that nobody needed. Nobody opens it. The sales head wanted to know which dealers are slipping, but the page shows only total turnover by month, which hides every dealer.
Sit with each manager for twenty minutes. Ask what they check first each morning, which report they still keep in Excel and what decision they made last week, then ask to see the file. Their answers are the real requirements.
If a manager keeps a spreadsheet next to the dashboard, the dashboard is missing something, usually a cut of the data or a figure adjusted by hand. Find out what. Add it.
The numbers are not trusted
One mismatch is enough. If the dashboard showed a debtor balance that differs from the one in the accounts package, the manager stops believing every other card. Trust is lost in a minute. It returns slowly.
Run a reconciliation for the five headline figures, compare each against its source and write the difference down before anyone touches the display. Fix the cause, not the display. Do not patch the card. Common causes are cancelled documents counted twice, filters that quietly drop a branch, credit notes posted to the wrong month and refreshes that stopped overnight.
Then show your working. A last refreshed stamp and a short definition under each figure answer most doubts before they are raised, and they take little time to add.
- Five headline figures checked against the source
- A written definition for each measure
- Refresh time visible on every page
- A named person who answers questions about a figure
Too many pages, too far to click
A manager with ten minutes before a meeting will not click through nine tabs; if the answer is not on the first screen, the habit never forms. Count the clicks between opening the link and seeing the figure the person came for, then aim for none by moving that figure onto the first screen.
Rebuild the front page for one role. A plant manager needs yesterday’s output against plan, rejects and open machine breakdowns; an accounts head needs overdue receivables by age band and cash received today. Everything else goes behind a drill through.
Check how people reach it. A link buried in a shared folder loses to a message in WhatsApp or email, because people open whatever sits in front of them. Put the link where they already look.
Nothing tells them when something moves
Visiting a dashboard is a chore. A dashboard that speaks up when stock cover falls below a limit, or when a dealer’s orders drop for three weeks running, earns its place.
Pick three or four conditions per role and set alerts for them; send a short message with the figure and a link to the right page. The manager sets the thresholds. The builder never guesses them.
A weekly email with the five numbers that mattered and a link to each page keeps the dashboard in view without asking anyone to remember it.
Rescue it starting from one decision per role
List the roles that should use it. For each, write one decision they make every week and the figure that informs it; that list is the whole scope of the rescue. Anything not on it can wait.
Rebuild one role at a time, starting with the most senior willing user, then show the draft in one sitting and change it live while they watch. Return a week later. Their continued use is your test. Nothing else counts.
Hold a session for each role on reading the page and where a figure comes from; book a review after thirty days to see who is opening it.
Dashboard rescue interview sheet
One row per role. Columns record the person, the weekly decision, the first morning figure, the spreadsheet kept on the side, the alert wanted and the date of the thirty day review. A footer block lists the five headline figures, each with its source system, its reconciliation status and a last checked date.
Open a blank worksheet to printQuestions owners ask
How do I find out who is actually using the dashboard?
Power BI, Metabase and Looker Studio all keep usage records that show who opened which page and when, so you can check what people claim. Pull the last ninety days. Match it to the intended users.
Should I scrap the dashboard and start again?
Rarely. The data connections and the cleaned tables are usually sound; rebuild the front pages for each role and keep the model underneath.
What if managers say they prefer Excel?
Ask what Excel gives them that the dashboard does not; it is often a particular cut of the data or a figure they can adjust. Add that to the dashboard.
How many measures should one page carry?
As few as one decision needs. Four to six figures with one trend chart is a sensible start for a plant manager or an accounts head, with detail behind a drill through page.