Google

Process Data from Dirty to Clean

This course is part of Google Data Analytics Professional Certificate

Taught in English

Google Career Certificates

Top Instructor

605,851 already enrolled

Included with Coursera Plus

Course

Gain insight into a topic and learn the fundamentals

4.8

(14,478 reviews)

|

98%

Beginner level

Recommended experience

26 hours (approximately)
Flexible schedule
Learn at your own pace

What you'll learn

  • Define different types of data integrity and identify risks to data integrity.

  • Apply basic SQL functions to clean string variables in a database.

  • Develop basic SQL queries for use on databases.

  • Describe the process of verifying data cleaning results.

Details to know

Shareable certificate

Add to your LinkedIn profile

Assessments

24 quizzes

Course

Gain insight into a topic and learn the fundamentals

4.8

(14,478 reviews)

|

98%

Beginner level

Recommended experience

26 hours (approximately)
Flexible schedule
Learn at your own pace

See how employees at top companies are mastering in-demand skills

Placeholder

Build your Data Analysis expertise

This course is part of the Google Data Analytics Professional Certificate
When you enroll in this course, you'll also be enrolled in this Professional Certificate.
  • Learn new concepts from industry experts
  • Gain a foundational understanding of a subject or tool
  • Develop job-relevant skills with hands-on projects
  • Earn a shareable career certificate from Google
Placeholder
Placeholder

Earn a career certificate

Add this credential to your LinkedIn profile, resume, or CV

Share it on social media and in your performance review

Placeholder

There are 6 modules in this course

Data integrity is critical to successful analysis. In this part of the course, you’ll explore methods and steps that analysts take to check their data for integrity. This includes knowing what to do when you don’t have enough data. You’ll also learn about random samples and understand how to avoid sampling bias. All of these methods will also help you ensure your analysis is successful.

What's included

8 videos9 readings6 quizzes1 discussion prompt1 plugin

Every data analyst wants to analyze clean data. In this part of the course, you’ll learn the difference between clean and dirty data. Then, you’ll practice cleaning data in spreadsheets and other tools.

What's included

10 videos9 readings6 quizzes1 plugin

Knowing a variety of ways to clean data can make a data analyst’s job much easier. In this part of the course, you’ll use SQL to clean data from databases. In particular, you’ll explore how SQL queries and functions can be used to clean and transform your data before an analysis.

What's included

9 videos7 readings5 quizzes1 discussion prompt1 plugin

When you clean data, you make changes to the original dataset. It’s important to verify the changes you make are accurate and to let your teammates know about the changes. In this part of the course, you’ll learn to verify that data is clean and report your data cleaning results. With verified clean data, you’re ready to begin analyzing!

What's included

6 videos5 readings4 quizzes

Creating an effective resume will help you in your data analytics career. In this part of the course, you’ll learn all about the job application process. Your focus will be on building a resume that highlights your strengths and relevant experience.

What's included

8 videos4 readings3 quizzes1 discussion prompt

Review the course glossary and prepare for the next course in the Google Data Analytics Certificate program.

What's included

1 video2 readings

Instructor

Instructor ratings
4.9 (4,647 ratings)
Google Career Certificates

Top Instructor

Google
323 Courses9,023,200 learners

Offered by

Google

Recommended if you're interested in Data Analysis

Why people choose Coursera for their career

Felipe M.
Learner since 2018
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Learner reviews

Showing 3 of 14478

4.8

14,478 reviews

  • 5 stars

    85.17%

  • 4 stars

    12.15%

  • 3 stars

    1.84%

  • 2 stars

    0.42%

  • 1 star

    0.39%

RH
5

Reviewed on Oct 27, 2023

HB
5

Reviewed on Jan 1, 2022

RK
4

Reviewed on Nov 5, 2022

New to Data Analysis? Start here.

Placeholder

Open new doors with Coursera Plus

Unlimited access to 7,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Frequently asked questions