✦ For everyone, free.

Practical knowledge for real and everyday life

Home

Measurement Data Quality

Measurement Data Quality ensures reliable insights by assessing accuracy, consistency, and relevance of data used in agile project management decisions.

Measurement Data Quality is the degree to which collected work data accurately, consistently, and completely reflects what actually happened, and the ongoing set of checks a team applies to detect and correct deficiencies in that data before it is used to calculate metrics or build forecasts. Where Measurement Data Collection concerns the process of gathering raw data in the first place, data quality concerns evaluating and maintaining the trustworthiness of that data once it exists, recognizing that a collection process can be diligently followed and still produce data with quality problems that undermine everything built on top of it.


Why Data Quality Deserves Separate Attention From Collection

Collection Discipline Does Not Guarantee Accuracy

Even a team that consistently follows its defined collection process can produce data containing errors, such as a task moved to the wrong workflow stage by mistake or a timestamp recorded against the wrong item, meaning quality problems can exist independently of whether the collection process itself was followed correctly.

Quality Issues Are Often Invisible Until Specifically Checked

A dataset with quality problems typically looks unremarkable at a glance, since nothing about a calculated metric signals that some of its underlying inputs were flawed, which is why quality requires active, deliberate verification rather than being assumed from the mere existence of a functioning collection process.


Core Dimensions of Data Quality

Accuracy

Accuracy concerns whether recorded values genuinely correspond to what actually happened, such as whether a completion timestamp truly reflects when work finished rather than when someone happened to update the record, and inaccuracy can arise from simple human error even within an otherwise well-designed collection system.

Completeness

Completeness concerns whether all relevant events have been recorded, without significant gaps, and connects directly to the completeness ratio introduced in Measurement Data Collection as a way of quantifying how much of the true underlying activity the dataset actually captures.

Consistency

Consistency concerns whether data is recorded the same way across different team members, different points in time, and different types of work, since inconsistent application of definitions, discussed as a collection concern, manifests specifically as a quality problem when it comes time to analyze the resulting data as a single unified set.

Timeliness

Timeliness concerns whether data is recorded close to when the actual event occurred rather than being entered well after the fact, since delayed entry increases the risk of inaccuracy due to imprecise recollection, even when the eventual record is nominally complete.


Detecting Quality Problems

Outlier and Anomaly Review

Periodically scanning the dataset for values that fall far outside the normal range, such as an implausibly short or long duration for a task, surfaces likely data quality problems that would otherwise silently distort calculated metrics.

Cross-Checking Against Independent Sources

Where a second, independent record of the same underlying activity exists, such as a separate communication log referencing when work actually began, comparing it against the primary dataset can reveal discrepancies that a single-source review would miss.

Spot-Checking Against Direct Recollection

Occasionally confirming a small sample of recorded entries against the direct memory of the team members involved, while imperfect given memory's own limitations, can catch systematic recording errors that would otherwise go unnoticed in aggregate data.


Responding to Identified Quality Problems

Correcting Individual Records Where Possible

When a specific inaccuracy is identified and the correct value can be reasonably reconstructed, the record is corrected directly, with the correction itself noted so that later review understands why the value differs from what was originally captured.

Adjusting Collection Practices to Prevent Recurrence

A quality problem traced to a systemic cause, such as an ambiguous workflow stage definition, is addressed by improving the underlying collection practice described in Measurement Data Collection, rather than merely correcting the individual affected records without addressing the source of the error.

Flagging Unreliable Periods Rather Than Discarding Silently

Where a stretch of data is judged too unreliable to correct with confidence, the team explicitly marks that period as low-confidence in any analysis that uses it, rather than silently excluding or silently including it without acknowledgment, preserving transparency about the limitations of the resulting metrics.


A Data Quality Review Cycle

Data Collected Checked Against Quality Dimensions Issues Corrected Trusted Metrics

Estimating Overall Data Quality

Where a summary indicator is useful, teams can combine the completeness ratio with an estimated accuracy rate, drawn from spot-checking, into a rough composite quality score.

Quality Score = Completeness × Estimated Accuracy Rate

A quality score that has declined relative to prior periods signals that metrics and forecasts built on the current data should be treated with increased caution until the underlying issues are identified and addressed.


Common Pitfalls

Assuming Automated Collection Implies High Quality

Data captured automatically by a tool can still suffer from quality problems, such as a team member mis-transitioning an item's status, and automation should reduce certain types of error without being treated as a guarantee against quality issues generally.

Correcting Data Without Investigating the Underlying Cause

Fixing individual inaccurate records while never examining why the inaccuracy occurred in the first place allows the same class of error to recur indefinitely, since the systemic cause remains unaddressed.

Losing Trust in Metrics Entirely After a Single Quality Issue

Discovering one data quality problem can tempt a team to distrust all of its metrics broadly, when a more proportionate response is to assess the scope of the specific issue and address it directly, preserving the overall value of a measurement practice that remains sound apart from the identified flaw.