Cleaning and Preparing Data

Learn basic techniques for how to organize and clean data in spreadsheets in preparation for distribution and analysis. Modal - A better way to learn technical skills.

When

October 28, 2022 - November 11, 2022

Registration closes October 27, 2022 at 12:00 PM Pacific

Subscription fee

$5,000

MORE THAN A COURSE

You get access to all of Modal's Courses for 1-year, starting on October 28, 2022.

Reimbursement

Submit a single FlexEd application for the 1-year subscription immediately after payment - no certificate of completion needed.
_{Additional courses are covered by the subscription fee.}

Who Is This For?

Non-data professionals interested in cleaning and preparing data they’ve collected for later analysis.

Any prerequisites?

Familiar with data fundamentals, such as the difference between structured and unstructured data.
Familiar with how to read a data plan.
Familiar with data collection processes.
Knowledge of common spreadsheet tools (ex. Excel) to edit, sort, filter, validate, and manipulate data

What will I be able to do after this Course?

Create clean, organized datasets in preparation for sharing and analysis.

NEED HELP DECIDING?

Book time with a learning expert.

A Typical Week

Monday

Self Study

Kick-off new topic with self-study & online learning

Coaches support learners hitting roadblocks
Manager check-in to bring learning into company context

Tuesday
Wednesday

Labs

Learning material leads into practice environment & labs

Coaches support learners hitting roadblocks
Pair programming to bring learning into company context
Community allows students to help each other

Thursday

Live Event

Interactive live session hosted by Coaches

Community allows students to help each other
Community Groups host expert AMAs & guided community discussions

Friday

Projects

Work on a weekly project

Community allows students to help each other
Group projects
Coaches support learners hitting roadblocks

Saturday
sunday

Work at your own pace

Expert coaching and actionable feedback from Coaches

The Learning Path

This course is part of Modal's Preparing Useful Data Learning Path. Take this course individually or enroll in all three courses and take on a Capstone project.

Course 1: Data Collection

Learn methods for collecting useful and usable data, such as identifying potential data sources that align with a research question, selecting the right data collection method, and curating data from existing sources.

Course 2: Representing Accurate Insights

Differentiate between different types of bias, identify misleading statistics, and develop your own defensible experiment that mitigates the effect of bias.

This Course: Cleaning and Preparing Data

Learn how to assess data organization requirements and use a variety of methods to organize your data.
Learn several techniques for cleaning your data and converting the results into useful formats based on stakeholder needs.