SQL, data modeling, data quality, EDA, visualization · insight-1074
Show freshness and metric definitions on the dashboard itself
- Evidence type
- practitioner heuristic
- Difficulty
- easy
- Roles
- Data analyst, Data scientist
- Industries
- cross-industry
Summary: situation, action, reason, boundary
Situation
An executive dashboard shows "bookings today", the upstream load is two hours late, and viewers compare it to a figure from another team that defines a booking differently.
Action
Display the latest data timestamp and the freshness status next to each headline metric, link its definition (grain, filters, time zone, inclusion rules) and owner, and grey out or flag tiles that exceed their SLA. Source the timestamp from the same freshness check the pipeline uses.
Reason
A number without its as-of time and definition cannot be interpreted, and the information is cheap to carry.
Boundary
Operational and executive dashboards, scheduled report emails and self-service tools.
Symptom or risk
Viewers cannot tell a real drop from a stale table, and two numbers with the same label look like a contradiction, which wastes meetings and erodes trust.
Exceptions
Static historical reports with a fixed closing date.
Trade-offs
Extra visual elements compete with the headline value; keep them small.
Pitfalls
Showing the dashboard refresh time rather than the time of the newest data it contains.
Lessons and concepts
Claims and their sources
dbt source freshness checks whether data meets its SLA and is recommended to run at least twice as often as the tightest SLA.