Untidy Data: The Unreasonable Effectiveness of Tables

TL;DR

This paper reveals that tables and spreadsheets are vital for data workers' sensemaking, serving purposes beyond initial cleanup by enabling direct, flexible interaction with data throughout analysis.

Contribution

It highlights the importance of interactive tables in data analysis, emphasizing their role in ongoing sensemaking and proposing a broader design space for visual analytics tools.

Findings

Data tables are used throughout analysis, not just for cleanup.

Users reshape and augment data within tables for understanding.

Interactive tables support flexible, human-centered data exploration.

Abstract

Working with data in table form is usually considered a preparatory and tedious step in the sensemaking pipeline; a way of getting the data ready for more sophisticated visualization and analytical tools. But for many people, spreadsheets -- the quintessential table tool -- remain a critical part of their information ecosystem, allowing them to interact with their data in ways that are hidden or abstracted in more complex tools. This is particularly true for data workers: people who work with data as part of their job but do not identify as professional analysts or data scientists. We report on a qualitative study of how these workers interact with and reason about their data. Our findings show that data tables serve a broader purpose beyond data cleanup at the initial stage of a linear analytic flow: users want to see and "get their hands on" the underlying data throughout the analytics process, reshaping and augmenting it to support sensemaking. They reorganize, mark up, layer on levels of detail, and spawn alternatives within the context of the base data. These direct interactions and human-readable table representations form a rich and cognitively important part of building understanding of what the data mean and what they can do with it. We argue that interactive tables are an important visualization idiom in their own right; that the direct data interaction they afford offers a fertile design space for visual analytics; and that sense making can be enriched by more flexible human-data interaction than is currently supported in visual analytics tools.