Skip to Main Content
UTA Libraries logo

Data Analysis and Visualization Series

Workshop series on statistics, data management, and visualization processes, including GIS and DH tools.

Data Cleaning Workshop

This workshop focuses on the concepts and best practices behind cleaning research data. The workshop establishes a clear definition for data cleaning before then examining the importance of cleaning research data, the best practices to follow throughout the process, as well as the characteristics of properly cleaned data. In the latter half of this presentation, attendees can follow along with a live demonstration of data cleaning methods using two different tools, Microsoft Excel and OpenRefine.

Below, you can find the PowerPoint slides for this workshop, as well as associated date files for the interactive data cleaning portion. An instructional video for the Excel data cleaning portion is also provided below. To view a recording of the full workshop presentation please go here.