Knowledgebase

Building Reliable Dashboards Print

  • dataengineering, data, clientarea, performance, guide, howto, solution, zillionkinghost
  • 0

Reports people can trust.

WHAT MAKES A DASHBOARD FAIL

Numbers that disagree with other sources Stale data with no indication Slow loading Too much shown at once No clear purpose

WHAT TO ESTABLISH FIRST

What decision the dashboard supports, and who makes it.

WHY

A dashboard supporting no decision is built, admired, and abandoned.

WHAT TO SHOW

The few numbers that matter, and what they should be compared against.

WHY COMPARISON MATTERS

A number alone tells nobody whether it is good.

WHAT TO ALWAYS DISPLAY

When the data was last updated.

WHAT TO ADD

Definitions, reachable from the dashboard itself.

WHY

The first question about any figure is what it includes.

WHAT TO BUILD ON

Modelled tables, not raw data or ad hoc queries.

WHAT TO AVOID

Logic embedded in the dashboard Filters that silently exclude data Many dashboards covering the same ground

WHAT TO REVIEW

Usage, and retire what nobody opens.

WHY

Unused dashboards still cost money to refresh and confuse people who find them.

WHAT TO TEST AFTER EVERY MODEL CHANGE

That the dashboard still shows the same figures.


Was this answer helpful?
Back

Are you happy with your experience? Leave us a review on Trustpilot.


Trustpilot