Data Cleaning in Snowflake: Techniques to Clean Messy Data
Completed by CAMNIEN FORDN'DY FRANCK TIEKOURA
January 9, 2025
2 hours (approximately)
CAMNIEN FORDN'DY FRANCK TIEKOURA's account is verified. Coursera certifies their successful completion of Data Cleaning in Snowflake: Techniques to Clean Messy Data
What you will learn
Use Snowflake UI to identify data quality issues then use SQL String functions to remove unwanted characters and split rows into multiple columns.
Extract dates from Text fields then use SQL date functions for comparisons and calculations.
Identify and correct missing and duplicated data and answer business questions using aggregation statements.
Skills you will gain
- Category: Big Data
- Category: Data Cleansing
- Category: Data Analysis
- Category: Data Wrangling
- Category: Data Manipulation
- Category: Data Transformation
- Category: SQL
- Category: Data Validation
- Category: Data Quality
