Checklist

Define what complete means

96% of what?

About 1 min read

Before you use it

Use when
  • A dashboard says customer data is 96% complete.

Keep this limit in mind

  • A high completion score does not establish that populated values are correct.

An idea to explore.

Try this idea.

Inspect the example, try the idea in your situation, then check your next move.

Keep reading

Checklist

  • Write the required population, fields and completion rule.
  • Show counts beside the percentage, with exclusions and the assessment date.

Why it matters

Name the records and fields required for the task, then define what counts as complete. Show the count that passed and the total checked: the numerator and denominator. State any exclusions before calculating the percentage.

An example

In this example, 180 of 200 invoiced customers have a required billing address: 90%. Another 300 prospects do not need one. Including them as missing addresses would produce 36% and answer a different question.

Check your result

Another analyst can reproduce the metric from the definition and counts.

Save and practise this idea

My learning

Read. Recall. Repeat.

Save this idea and return to it on any device.

Use email
Keep exploring

Connected ideas

You are readingDefine what complete means

Evidence and sources
Supports

Data quality assessment should use explicit rules tied to critical data and its intended use, choose metrics suited to each check, and communicate results with their strengths and limitations.

Claim limit: Official practical guidance, not experimental evidence for the effectiveness of this checklist. Showing the numerator, denominator and exclusions is the card’s practical adaptation, not a quoted mandatory standard. Source reading history: selected_passages; 2026-10-11; Data quality action planning steps 1–3 and 8; previously selected metadata and quality communication guidance. Official page was opened on 2026-10-10 and identified sections inspected. This verifies a narrow reference basis, not the effectiveness or completeness of independently drafted practice steps. On 2026-10-11 action-planning steps 1–3 and 8 were read again for card 9721; this is selected-passage screening, not independent review. On 2026-10-11 the Completeness communication section, action-planning step 7 and root-cause data-journey section were read again for the missingness correction; source screening only. Agent release review: PostgreSQL 18 table expressions, NULL comparisons and aggregates, the UK Government Data Quality Framework and Microsoft Power Query profiling documentation were checked at the cited sections. The original examples and scope limits remain attached.

The Government Data Quality Framework: guidance · Data quality action planning, steps 1–3 and 8: critical fields, quality rules, metrics and reporting

Supports

Completeness covers both the presence of expected records and the population of essential values within records; populated values may still be inaccurate.

Claim limit: A framework definition, not a universal field list or proof that the adapted checks diagnose a particular migration failure. Required records and values depend on the task. Source reading history: selected_passages; 2026-10-11; Six dimensions and user needs; Completeness definition and distinction from accuracy. Official page was opened on 2026-10-10 and identified sections inspected. This verifies a narrow reference basis, not the effectiveness or completeness of independently drafted practice steps. On 2026-10-11 the Completeness definition and its distinction from accuracy were read again for cards 9721/9725; this is selected-passage screening, not independent review. Agent release review: PostgreSQL 18 table expressions, NULL comparisons and aggregates, the UK Government Data Quality Framework and Microsoft Power Query profiling documentation were checked at the cited sections. The original examples and scope limits remain attached.

The Government Data Quality Framework · Data quality dimensions: Completeness, definition and distinction from accuracy

All sources (2)
Edition and review

Version 0.1.0 · Published

Edition checked · 2026-11-12

Read this idea as JSON · Release details