Manage Data

Good data management includes developing effective processes for consistently collecting and recording data, storing data securely, backing up data, cleaning data, and modifying data so it can be transferred between different types of software for analysis.

Good data management is inextricably linked to data quality assurance –the processes and procedures that are used to ensure data quality. Using data of unknown or low quality may result in making the wrong decisions about policies and programmes.  Data quality assurance (DQA) should be built into each step in the data cycle − data collection, aggregation and reporting, analysis and use, and dissemination and feedback.

Even when data have been collected using well-defined procedures and standardised tools, they need to be checked for any inaccurate or missing data. This “data cleaning” involves finding and dealing with any errors that occur during writing, reading, storage, transmission, or processing of computerised data.

Ensuring data quality also extends to presenting the data appropriately in the evaluation report so that the findings are clear and conclusions can be substantiated. Often, this involves making the data accessible so that they can be verified by others and/or used for additional purposes such as for synthesising results across different evaluations.

Commonly referred to aspects of data quality are: 

  • Validity: The degree to which the data measure what they are intended to measure.
  • Reliability: Data are collected consistently; definitions and methodologies are the same when doing repeated measurements over time.
  • Completeness: Data are complete (i.e., no missing data or data elements).
  • Precision: Data have sufficient detail.
  • Integrity: Data are protected from deliberate bias or manipulation for political or personal reasons
  • Availability: Data are accessible so they can be validated and used for other purposes.
  • Timeliness: Data are up-to-date current and available on time.

Options

  • Consistent Data Collection and Recording: processes to ensure data are collected consistently across different sites and different data collectors.
  • Data Backup: onsite and offsite, automatic and manual processes to guard against the risk of data being lost or corrupted.
  • Data Cleaning: detecting and removing (or correcting) errors and inconsistencies in a data set or database due to the corruption or inaccurate entry of the data. 
  • Effective Data Transfer: processes to move data between systems, including between software packages, to avoid the need to rekey data.
  • Secure Data Storage: processes to protect electronic and hard copy data in all forms, including questionnaires, interview tapes and electronic files from being accessed without authority or damaged.
  • Archive Data for Future Use: systems to store de-identified data so that they can be accessed for verification purposes or for further analysis and research in the future.

Resources

Comments

Anonymous's picture
Raj

This article is very helpful for knowing Data quality assurance (DQA), it’s covered a lot things including Validity, Reliability, Precision, Integrity, Availability and Timeliness. It is really very informative post .Thanks for sharing.

AnalytiXDS

Add new comment

Login Login and comment as BetterEvaluation member or simply fill out the fields below.