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.
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.
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.