Data Cleaning in Snowflake: Techniques to Clean Messy Data
in 2006, the British mathematician Clive Humby coined the phrase "Data is the new Oil". This analogy has been proven correct as data powers entire industries nowadays but if left unrefined, is effectively worthless. This 2.5 hours-long guided project is designed for business analysts & data engineers eager to learn how to Clean Messy Data in Snowflake Data Platform. By the end of the project, you will -Be able to identify common data quality issues then use SQL String functions to remove unwanted characters and split rows into multiple columns.
Buy Now Free
- Level Intermediate
- Duration 3 hours
- Course by Coursera Project Network
-
Offered by
About
in 2006, the British mathematician Clive Humby coined the phrase "Data is the new Oil". This analogy has been proven correct as data powers entire industries nowadays but if left unrefined, is effectively worthless. This 2.5 hours-long guided project is designed for business analysts & data engineers eager to learn how to Clean Messy Data in Snowflake Data Platform. By the end of the project, you will -Be able to identify common 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 then answer business questions using SQL statements. To achieve these objectives, we will work on a real example from the field, you will play the role of a Data Analyst in the marketing department, who has been tasked with answering a business question, but the customer data they have received presents several data quality challenges. Note: To be successful in this project you need to have Snowflake beginner knowledge such as Creating a trial account, Databases, Tables, and Virtual Warehouses. If you are not familiar with Snowflake and want to learn the basics, start with my previous Guided Project: Snowflake for Beginners: Make your First Snowsight Dashboard which will give you basic knowledge about Snowflake and will teach you how to create your trial account.Modules
Your Learning Journey
-
2
Readings
-
1
Plugin
-
1
Lab
-
1
Assignment
1
Assignment
- Assess Your Knowledge
1
Labs
- Data Cleaning in Snowflake: Techniques to Clean Messy Data
2
Readings
- Project Overview
- Create your Snowflake Free Trial Account
Auto Summary
Unlock the power of data with "Data Cleaning in Snowflake: Techniques to Clean Messy Data." This 2.5-hour guided project is perfect for business analysts and data engineers eager to refine their skills. Led by an expert instructor, you'll tackle real-world data quality issues using SQL functions within the Snowflake Data Platform. Ideal for those with basic Snowflake knowledge, this intermediate course is available for free on Coursera. Transform messy data into valuable insights and elevate your data analytics capabilities today!
Mohamed Touiti