Make Your Data Sparkle: Strategies for Data Preparation and Cleaning

Scheduled Dates
Course Details
Course Type: 
Topic Area: 
Target Audience: 
Participants who have basic or intermediate level experience with data collection and analysis will gain the most benefit from this course.
Course Description

Before we can analyze, visualize and present our data, it must be checked for quality, accuracy, and format. Frequently, the dataset needs to be modified, or "cleaned" in various ways to eliminate errors and prepare it for use. This workshop will introduce participants to common issues with removing or correcting "dirty" data, datatype formatting, quality considerations and other aspects of preparing data for use. Several free or low-cost tools will be presented to demonstrate how these issues can be resolved effectvely and efficiently.

Learning objectives for this session include

Learners will be able to:

  1. Identify common sources of data "dirt" and other issues that need to be addressed in preparing data for analysis
  2. Understand data cleaning and preparation in the context of the data life cycle
  3. Learn about several data cleaning tools and how they are used
  4. Complete a basic data cleaning exercise

No prerequisites.

Homework Expectations

To receive CE credit, participants will complete a hands-on data prep assignment, involving the use of a free data cleaning tool.

It is designed for individual participation; each individual must register.

Session Information
Session Duration: 
This course consists of one 2-hour session.
Contact Hours: 
Elaine Lasda -