Research directions in data wrangling: Visualizations and transformations for usable and credible data
- 2 September 2011
- journal article
- research article
- Published by SAGE Publications in Information Visualization
- Vol. 10 (4), 271-288
- https://doi.org/10.1177/1473871611415994
Abstract
In spite of advances in technologies for working with data, analysts still spend an inordinate amount of time diagnosing data quality issues and manipulating data into a usable form. This process of ‘data wrangling’ often constitutes the most tedious and time-consuming aspect of analysis. Though data cleaning and integration arelongstanding issues in the database community, relatively little research has explored how interactive visualization can advance the state of the art. In this article, we review the challenges and opportunities associated with addressing data quality issues. We argue that analysts might more effectively wrangle data through new interactive systems that integrate data verification, transformation, and visualization. We identify a number of outstanding research questions, including how appropriate visual encodings can facilitate apprehension of missing data, discrepant values, and uncertainty; how interactive visualizations might facilitate data transform specification; and how recorded provenance and social interaction might enable wider reuse, verification, and modification of data transformations.This publication has 30 references indexed in Scilit:
- Collective entity resolution in relational dataACM Transactions on Knowledge Discovery From Data, 2007
- A Survey of Outlier Detection MethodologiesArtificial Intelligence Review, 2004
- Point-based probabilistic surfaces to show surface uncertaintyIEEE Transactions on Visualization and Computer Graphics, 2004
- Taverna: a tool for the composition and enactment of bioinformatics workflowsBioinformatics, 2004
- Learning to match ontologies on the Semantic WebThe VLDB Journal, 2003
- A survey of approaches to automatic schema matchingThe VLDB Journal, 2001
- SchemaSQLACM Transactions on Database Systems, 2001
- AJAXACM SIGMOD Record, 2000
- Designing pixel-oriented visualization techniques: theory and applicationsIEEE Transactions on Visualization and Computer Graphics, 2000
- Online aggregationACM SIGMOD Record, 1997