Lesson 1 - Understanding Data
In this lesson you’ll learn the differences between structured, unstructured, and semistructured data. You’ll also be introduced to the most common data types: string, number, date/time, boolean, and special characters.
Lesson 2 - Data Issues
In this lesson you’ll learn how clean dirty data and prepare it for analysis. You’ll learn how identify and correct for common data issues like missing data, duplicate data, special characters, and outliers.
Lesson 3 - Data Formatting
In this lesson you’ll learn the impact of the format of the data can have on your analysis. You’ll learn how to use common formatting techniques such as transposing, aggregation, and cross tabulation.
Lesson 4 - Data Blending
In this lesson you’ll learn how to combine data from multiple sources into a single dataset. You’ll learn how to use common blending techniques such as joins, unions, fuzzy matching, and spatial blending.