Data Cleaning in Snowflake: Techniques to Clean Messy Data
About this Course
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.Created by: Coursera Project Network
Related Online Courses
This course covers commonly used statistical inference methods for numerical and categorical data. You will learn how to set up and perform hypothesis tests, interpret p-values, and report the... more
In this short course, you learn what generative AI is and how it functions. You also discover how GenAI can be applied in different business scenarios as well as navigating the concerns around its... more
This series of courses is intended to provide learners with the tools to develop and operate a home-based childcare center. Stages of child development, best practices to stimulate learning,... more
In this lab, you will configure a highly available Memorystore cluster and review the architecture of such a deployment.Created by: Google Cloud more
Welcome to the India-US Relations: Geopolitics, Culture, and Business course! This course seeks to provide you with a comprehensive understanding of the intense ties between India and the US. The... more