Preparing and cleaning data is an essential step in the analysis pipeline. This step ensures input data is organized and error-free, allowing for a more streamlined, accurate analysis.
In this course, students learn to prepare for analysis by cleaning and transforming datasets. Students will learn how to handle outliers, identify and reconcile errors and validate data. In addition, students will explore data aggregation, filters, dedupes and joins. Students will advance their skills in Excel, R, and SQL.