i-nth logo

Authors

Patrick O'Beirne

Abstract

The quality of the data in spreadsheets is less discussed than the structural integrity of the formulas. Yet it is an area of great interest to the owners and users of the spreadsheet.

This paper provides an overview of Information Quality (IQ) and Data Quality (DQ) with specific reference to how data is sourced, structured, and presented in spreadsheets.

Sample

Root causes of poor data quality
Root causes of poor data quality

This is a cause-and-effect diagram illustrating the many contributory causes to poor data quality.

The five types of causes are:

  • Policy.
  • Methods.
  • Technology.
  • Training.
  • People.

Publication

2008, EuSpRIG

Full article

Information and data quality in spreadsheets