Rutgers Classifieds>Rutgers Online Courses>Data Cleaning in Snowflake: Techniques to Clean Messy Data

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

87% of Google Cloud certified users feel more confident in their cloud skills. This program provides the skills you need to advance your career and provides training to support your preparation for... more
This course introduces administrative tasks that a system administrator can perform with Linux hosted on IBM Power servers. This includes virtualization concepts such as logical partitioning,... more
Fires impact people, property and the environment in all countries around the world. In some cases, the resulting losses are extraordinary, causing hundreds of deaths, widespread damage to property... more
About GANs\\n\\nGenerative Adversarial Networks (GANs) are powerful machine learning models capable of generating realistic image, video, and voice outputs.\\n\\nRooted in game theory, GANs have... more
This 1.5 hours project-based course is the first part of \"Manage Your Versions with Git\". In this course, you will learn about the ubiquitous Git version management system. Git is an industry... more

CONTINUE SEARCH

FOLLOW COLLEGE PARENT CENTRAL