"" Using Data to Improve Care for Children EKG
Home >

Determine the Current and Desired Quality Levels

After gaining a functional understanding of the data objectives and identifying the key necessities, the next step is to define the level of data quality. This should be done for the data in its current state as well as how you would like it to be.

Picture of twins - got duplicates??Measurable quality elements:

The following are examples of standards you could set for your data. This is where you get to be the boss; you get to define your standards of cleanliness for your project. Quality can be defined in terms of:


  • Data values present are one of a predetermined value for the specific field
  • Numeric values are within a predetermined specified range
  • Date values fall within a predetermined time period
  • Data outliers are non-existent or have identified and corrected/explained
  • Derived data fields have been performed correctly
  • Calculated data fields have been calculated correctly




  • Symbolic data values are consistent throughout the given dataset
  • Data values are consistent across related datasets




  • There are no missing values were completeness is required
  • The number of records present is the appropriate amount of data
  • All necessary fields are present
  • Primary keys are present, unique and in good format
  • All foreign key fields are present and in good format




  • Duplicate records are not present
  • Redundant fields are not present
  • Duplicate records across distinct datasets are not present




  • All rules have been identified and are accurate
  • Data has been tested and follows data rules
  • All field data is formatted correctly for the representative data type




  • Metadata is available
  • Data is easy to interpret
  • Data is representative of intended objectives

Next StepDiscover the Scope of the Problem >>





rev. 04-Aug-2022




Resource Library

Link 1
(Description of link)


Disclaimer | Website Feedback | U of U
© NEDARC 2010

This website is supported by the Health Resources and Services Administration (HRSA) of the U.S. Department of Health and Human Services (HHS) as part of the Emergency Medical Services for Children Data Center award totaling $3,200,000 with 0% financed with non-governmental sources. The contents are those of the author(s) and do not necessarily represent the official views of, nor an endorsement, by HRSA, HHS, or the U.S. Government. For more information, please visit HRSA.gov.

(In accordance with the Americans with Disabilities Act, the information in this site is
available in alternate formats upon request.)