Data Cleaning in Snowflake: Techniques to Clean Messy Data

Coursera Project Network

New York, United StatesTaught in EnglishOnlineOpen to international students

Why students choose this program

Taught in English
No application fee
Study online, from anywhere

About Data Cleaning in Snowflake: Techniques to Clean Messy Data

For Data Cleaning in Snowflake: Techniques to Clean Messy Data, applications close Anytime, while tuition is 49.

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.

About Coursera Project Network

The Coursera Project Network is a unique initiative within Coursera, a leading online learning platform founded in 2012. It is not a university, but rather a public, open-access platform that facilitates the creation and delivery of hands-on projects by experts and educators. The Coursera Project Network is distinguished by its focus on practical, project-based learning, enabling learners to apply their skills in real-world scenarios. This approach allows individuals to gain tangible, job-ready skills quickly and efficiently.

The Coursera Project Network offers a wide range of guided projects across various domains, including business, technology, data science, and more. These projects are designed to be completed in a short time frame, typically a few hours, providing learners with a quick and immersive learning experience. Through step-by-step instructions and hands-on practice, participants can build confidence in their abilities and directly apply what they learn to their personal or professional pursuits. The Coursera Project Network empowers learners to bridge the gap between theoretical knowledge and practical application, making it a valuable resource for skill development and career advancement.

Fees

Create a free account to view complete fee information

Create Free Account

Already have an account? Sign in

Tuition (international students): 49
Application Fee: 0 USD

Planning the visa? United States student visa: cost, requirements and processing time (from $535 all-in)

Entry Requirements

Create a free account to view entry requirements and apply to this program

Create Free Account

Already have an account? Sign in

All students from all countries are eligible to apply to this program.

Admissions Process

Create a free account to view the full admissions process

Create Free Account

Already have an account? Sign in

1
Step 1Choose programs
2
Step 2Apply online
3
Step 3Enroll

Preparing documents

You can start your application now and send the application documents during your application. Some documents you can send later if you don’t have them right away. See document and eligibility requirements

Required documents

• Curriculum Vitae

• English Language Certificate

• Personal Statement

• Your Highest Academic Transcript (in English)

• Your Photograph

• Your Graduation Certificate (in English)

• Your Passport Copy

Application process

• Applying Online is simple in just a few steps. Learn more about the application process

• The first steps are to choose the programs, pay the application fee and upload the application documents.

• Once submitted to Global Admissions, we will review your application within 2-3 days and proceed to the university or ask you for further clarification

• After it has been processed to the university you will receive your unique application ID from each university.

• The university may contact you directly for further questions.

• We will then follow up each week with the university for updates. As soon as there is any update we will let you know. If you have made other plans, decide to withdraw / change address at any time please let us know.

• After you have been accepted you will receive your admissions letter electronically and asked to pay the non-refundable deposit to the university.

• Once you have paid the deposit the university will issue you the admissions letter and visa form to your home country.