Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Google

Process Data from Dirty to Clean

Google via Google Skills

Overview

Build a Learning Habit
Download Class Central's free printable study calendar
Download for Free
Learn how to to check and clean data using spreadsheets and SQL. Verify and report cleaning results, guided by Google data analysts who provide hands-on tasks with essential tools. No previous experience is necessary to build your understanding. This is the fourth course in the Google Data Analytics Certificate, a series designed to prepare you for an introductory-level data analyst role.

Syllabus

  • The importance of integrity
    • Introduction to data integrity
    • Course 4 overview
    • Why data integrity is important
    • More about data integrity and compliance
    • Balance objectives with data integrity
    • Well-aligned objectives and data
    • Practice Quiz: Test your knowledge on data integrity and analytics objectives
    • Deal with insufficient data
    • When you find an issue with your data
    • The importance of sample size
    • Calculate sample size
    • Practice Quiz: Self-Reflection: Pre-cleaning activities
    • Practice Quiz: Test your knowledge on insufficient data
    • Using statistical power
    • When data isn't readily available
    • Determine the best sample size
    • Sample size calculator
    • Practice Quiz: Test your knowledge on testing your data
    • Evaluate data reliability
    • All about margin of error
    • Practice Quiz: Test your knowledge on margin of error
    • Glossary terms from module 1
    • Graded Quiz: Module 1 challenge
  • Clean data for more accurate insights
    • Clean it up!
    • Why data cleaning is critical
    • Angie: I love cleaning data
    • What is dirty data?
    • Recognize and remedy dirty data
    • Practice Quiz: Test your knowledge on data cleaning
    • Data-cleaning tools and techniques
    • Clean data from multiple sources
    • Common data-cleaning pitfalls
    • Practice Quiz: Hands-On Activity: Cleaning data with spreadsheets
    • Practice Quiz: Test your knowledge on the first steps toward clean data
    • Step-by-Step guide: Data-cleaning features in spreadsheets
    • Data-cleaning features in spreadsheets
    • Step-by-Step: Optimize the data-cleaning process
    • Optimize the data-cleaning process
    • Workflow automation
    • Step-by-Step: Different data perspectives
    • Different data perspectives
    • Step-by-Step: Even more data-cleaning techniques
    • Even more data-cleaning techniques
    • Working with .csv files
    • Practice Quiz: Hands-On Activity: Clean data with spreadsheet functions
    • Develop your approach to cleaning data
    • Practice Quiz: Test your knowledge on cleaning data in spreadsheets
    • Glossary terms from module 2
    • Graded Quiz: Module 2 challenge
  • Data cleaning with SQL
    • Use SQL to clean data
    • Sally: For the love of SQL
    • Understand SQL capabilities
    • How a junior data analyst uses SQL
    • Spreadsheets versus SQL
    • SQL dialects and their uses
    • Review: Set up your BigQuery account
    • Review: Get started with BigQuery
    • Practice Quiz: Hands-On Activity: Processing time with SQL
    • Optional: Upload the customer dataset to BigQuery
    • Widely used SQL queries
    • Evan: Having fun with SQL
    • Clean string variables using SQL
    • Practice Quiz: Hands-On Activity: Clean data using SQL
    • Practice Quiz: Test your knowledge on SQL queries
    • Optional: Upload the store transactions dataset to BigQuery
    • Advanced data-cleaning functions, part 1
    • Advanced data-cleaning functions, part 2
    • Practice Quiz: Self-Reflection: Challenges with SQL
    • Glossary terms from module 3
    • Graded Quiz: Module 3 challenge
  • Verify and report on cleaning results
    • Verify and report results
    • Confirm data-cleaning meets business expectations
    • Step-by-Step: Verification of data cleaning
    • Verification of data cleaning
    • Data-cleaning verification checklist
    • Practice Quiz: Test your knowledge on manual data cleaning
    • Capture cleaning changes
    • Embrace changelogs
    • Practice Quiz: Self-Reflection: Creating a changelog
    • Why documentation is important
    • Feedback and cleaning
    • Advanced functions for speedy data cleaning
    • Practice Quiz: Test your knowledge on documenting the cleaning process
    • Glossary terms from module 4
    • Graded Quiz: Module 4 challenge
  • Add data to your resume
    • Make your resume unique
    • Joseph: Black and African American inclusion in the data industry
    • The importance of diversity on a data analytics team
    • Add technical skills to your resume
    • Where does your interest lie?
  • Course wrap-up
    • Course 4 glossary
    • Congratulations! Course wrap-up
    • Coming up next ...
    • Course 4 resources and citations

Reviews

Start your review of Process Data from Dirty to Clean

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.