Design mockups from real numbers: re-check every caption against the data before showing
While drafting three dashboard design options with real figures, several plausible captions turned out false when checked against the underlying numbers: "since 2024 more than half of deaths each year were miscoded" (true for 2024 and 2025, false for 2026), "better than most makers" for a maker that sits mid-table, and "people checked 29 of this device's flags" when the 29 hand-checked flags were across all devices. Pulling the per-year rows with one query first, and testing each sentence against them, caught all three before the user saw them. A unit chart (one square per report, split by a waterline: filed as death above, found in the text below) communicated a hidden-count finding far faster than bars or KPI cards, and "nearly 2 in 5" (29 of 77) read better than 37.7%.