Process Data from Dirty to Clean

Instructor: Google Career Certificates

Beginner Level • Approx. 20 hours • Flexible Schedule

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.

Skills You'll Gain

SQL
Data Transformation
Spreadsheet Software
Data Validation
Data analysis
Sampling (Statistics)
Data Manipulation
Sample Size Determination
Data Cleansing
Data Quality
Data Integrity

Shareable Certificate

Earn a shareable certificate to add to your LinkedIn profile

Outcomes

  • 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

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.

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.

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.

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!

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.

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