Information and Data Quality in Spreadsheets

TL;DR

This paper reviews the importance of information and data quality in spreadsheets, emphasizing data sourcing, structuring, and presentation, which are crucial for spreadsheet reliability and user trust.

Contribution

It offers a comprehensive overview of information and data quality issues specific to spreadsheets, highlighting areas often overlooked compared to formula integrity.

Findings

Data sourcing impacts overall quality

Structured data enhances usability

Presentation affects user interpretation

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.