Course 4: Process Data from Dirty to Clean: Overview

Google Data Analysis Professional Certification

• Foundation Course Module 1: Introduction of data analytics and analytical thinking
• Foundation Course Module 2 : The wonderful world of data
• Foundation Course Module 3 : Setup of data analytics toolbox
• Foundation Course Module 4: Becoming a fair and impactful data professional
• Foundation Course: Glossary
• Course 2: Ask questions to make data driven decisions, Module 1: Ask effective questions
• Course 2: Ask questions to make data driven decisions, Module 2: Make data-driven decisions
• Course 2: Ask questions to make data driven decisions, Module 3: Spreadsheet magic
• Course 2: Ask questions to make data driven decisions, Module 4: Always remember the stakeholder
• Course 3: Prepare Data For Exploration: Learning objectives and overviews
• Course 3: Prepare Data For Exploration, Module 1: Data types and structures
• Course 3: Prepare Data For Exploration, Module 2: Data responsibility
• Course 3: Prepare Data For Exploration, Module 3: Database Essentials
• Course 3: Prepare Data For Exploration, Module 4: Organise and Secure Data
• Course 4: Process Data from Dirty to Clean: Overview
• Course 4: Process Data from Dirty to Clean, Module 1: The importance of integrity
• Course 4: Process Data from Dirty to Clean, Module 2: Clean it up
• Course 4: Process Data from Dirty to Clean, Module 3: SQL
• Course 4: Process Data from Dirty to Clean, Module 4: Verify and Report Results
• Course 5: Analyse Data to Answer Questions, Module 1: Organise data for more effective analysis
• Course 5: Analyse Data to Answer Questions, Module 2: Format and adjust data
• Course 5: Analyse Data to Answer Questions, Module 3: Aggregate data for analysis
• Course 5: Analyse Data to Answer Questions,  Module 4: Perform Data Calculations
• Course 6: Share Data Through the Art of Visualisation, Course Overview plus Module 1: Visualise Data
• Course 6: Share Data Through the Art of Visualisation, Course Overview plus Module 2: Create Data Visualisation with Tableau

This course is the fourth in the Google Data Analytics Certificate program. It will teach you how to clean data using spreadsheets and SQL, as well as how to verify and report your data cleaning results. This is an important skill for data analysts, as it ensures that the data they are working with is accurate and reliable.

Here are some of the benefits of taking this course:

• You will learn how to clean data using spreadsheets and SQL.
• You will learn how to verify and report your data cleaning results.
• You will gain essential troubleshooting skills that will enable you to fix any errors.
• You will be able to ensure the accuracy and reliability of your data.
• You will be able to complete the Google Data Analytics Certificate program.

This course is the fourth in the Google Data Analytics Certificate program. It focuses on the essential skills needed to clean and prepare data for analysis.

Here’s a quick overview of what this course offers:

Module 1: The importance of integrity

• Understand the importance of data integrity for successful analysis.
• Learn methods and steps to check data for completeness and correctness.
• Explore how to handle missing data and avoid sampling bias.

Module 2: Clean data for more accurate insights

• Differentiate between clean and dirty data.
• Practice cleaning data in spreadsheets and other tools.
• Learn techniques for identifying and correcting errors.

Module 3: Data cleaning with SQL

• Use SQL queries and functions to clean and transform data in databases.
• Gain hands-on experience with data cleaning using SQL.

Module 4: Verify and report cleaning results

• Verify the accuracy of your data cleaning changes.
• Learn how to communicate data cleaning changes to others.
• Create effective data cleaning reports.

Module 5: Optional: Add data to your resume

• Learn how to build a professional resume that highlights your data analytics skills.
• Get tips on how to use your resume to land a job in data analytics.

Module 6: Course wrap-up

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

Key takeaways:

• By the end of this course, you will be able to:
  • Check for data integrity.
  • Apply data cleaning techniques using spreadsheets.
  • Develop basic SQL queries for use on databases.
  • Use basic SQL functions to clean and transform data.
  • Verify the results of cleaning data.
  • Write an effective data cleaning report.