Make Your Data Sparkle: Strategies for Data Preparation and Cleaning

Scheduled Dates
Course Description
Topic Area: 
Course Type: 

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: 

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
Target Audience: 
Participants who have basic or intermediate level experience with data collection and analysis will gain the most benefit from this course.

No prerequisites.

Homework Expectations and Completion Requirements: 

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 Duration: 
This course consists of one 2-hour session.
Elaine Lasda -
Continuing Education Credit
Contact Hours: 
Amigos Member Early Bird Fee: 
Amigos Member Fee: 
Non-member Early Bird Fee: 
Non-member Fee: