Buy Now AED 170.99 + VAT

Monthly Subscription Starting at AED 99 + VAT

Process Data from Dirty to Clean
  • Level Foundation
  • Duration 24 hours
  • Course by Google
  • Offered by

About

This is the fourth course in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs. In this course, you'll continue to build your understanding of data analytics and the concepts and tools that data analysts use in their work. You'll learn how to check and clean your data using spreadsheets and SQL as well as how to verify and report your data cleaning results. Current Google data analysts will continue to instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources. Learners who complete this certificate program will be equipped to apply for introductory-level jobs as data analysts. No previous experience is necessary. By the end of this course, you will be able to do the following: - Learn how to check for data integrity. - Discover data cleaning techniques using spreadsheets. - Develop basic SQL queries for use on databases. - Apply basic SQL functions for cleaning and transforming data. - Gain an understanding of how to verify the results of cleaning data. - Explore the elements and importance of data cleaning reports.

Modules

Focus on integrity

    • 1 Videos
    • 2 Readings
    • 1 Plugin
Show info about module content

1 Videos

  • Introduction to data integrity

2 Readings

  • Course 4 overview: Set your expectations
  • Helpful resources and tips

Data integrity and analytics objectives

    • 2 Videos
    • 2 Readings
    • 1 Quiz
Show info about module content

2 Videos

  • Why data integrity is important
  • Balance objectives with data integrity

2 Readings

  • More about data integrity and compliance
  • Well-aligned objectives and data

1 Quiz

  • Test your knowledge on data integrity and analytics objectives

Overcome the challenges of insufficient data

    • 2 Videos
    • 2 Readings
    • 2 Quiz
Show info about module content

2 Videos

  • Deal with insufficient data
  • The importance of sample size

2 Readings

  • When you find an issue with your data
  • Calculate sample size

2 Quiz

  • Self-Reflection: Pre-cleaning activities
  • Test your knowledge on insufficient data

Test your data

    • 2 Videos
    • 2 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Test your knowledge on testing your data

2 Videos

  • Using statistical power
  • Determine the best sample size

2 Readings

  • When data isn't readily available
  • Sample size calculator

Consider the margin of error

    • 1 Videos
    • 1 Readings
    • 1 Quiz
Show info about module content

1 Videos

  • Evaluate data reliability

1 Readings

  • All about margin of error

1 Quiz

  • Test your knowledge on margin of error

Module 1 challenge

    • 1 Readings
    • 1 Quiz
Show info about module content

1 Readings

  • Glossary terms from module 1

1 Quiz

  • Module 1 challenge

Data cleaning is a must

    • 4 Videos
    • 1 Readings
    • 1 Plugin
    • 1 Assignment
Show info about module content

1 Assignment

  • Test your knowledge on data cleaning

4 Videos

  • Clean it up!
  • Why data cleaning is critical
  • Angie: I love cleaning data
  • Recognize and remedy dirty data

1 Readings

  • What is dirty data?

First steps toward clean data

    • 2 Videos
    • 1 Readings
    • 2 Quiz
Show info about module content

2 Videos

  • Data-cleaning tools and techniques
  • Clean data from multiple sources

1 Readings

  • Common data-cleaning pitfalls

2 Quiz

  • Hands-On Activity: Cleaning data with spreadsheets
  • Test your knowledge on the first steps toward clean data

Continue cleaning data in spreadsheets

    • 4 Videos
    • 7 Readings
    • 2 Quiz
Show info about module content

4 Videos

  • Data-cleaning features in spreadsheets
  • Optimize the data-cleaning process
  • Different data perspectives
  • Even more data-cleaning techniques

7 Readings

  • Step-by-Step guide: Data-cleaning features in spreadsheets
  • Step-by-Step: Optimize the data-cleaning process
  • Workflow automation
  • Step-by-Step: Different data perspectives
  • Step-by-Step: Even more data-cleaning techniques
  • Working with .csv files
  • Develop your approach to cleaning data

2 Quiz

  • Hands-On Activity: Clean data with spreadsheet functions
  • Test your knowledge on cleaning data in spreadsheets

Module 2 challenge

    • 1 Readings
    • 1 Quiz
Show info about module content

1 Readings

  • Glossary terms from module 2

1 Quiz

  • Module 2 challenge

SQL for sparkling clean data

    • 4 Videos
    • 4 Readings
    • 1 Quiz
Show info about module content

4 Videos

  • Use SQL to clean data
  • Sally: For the love of SQL
  • Understand SQL capabilities
  • Spreadsheets versus SQL

4 Readings

  • How a junior data analyst uses SQL
  • SQL dialects and their uses
  • Review: Set up your BigQuery account
  • Review: Get started with BigQuery

1 Quiz

  • Hands-On Activity: Processing time with SQL

Learn basic SQL queries

    • 3 Videos
    • 1 Readings
    • 1 Quiz
    • 1 Assignment
Show info about module content

1 Assignment

  • Test your knowledge on SQL queries

3 Videos

  • Widely used SQL queries
  • Evan: Having fun with SQL
  • Clean string variables using SQL

1 Readings

  • Optional: Upload the customer dataset to BigQuery

1 Quiz

  • Hands-On Activity: Clean data using SQL

Transforming data

    • 2 Videos
    • 1 Readings
    • 1 Quiz
    • 1 Plugin
Show info about module content

2 Videos

  • Advanced data-cleaning functions, part 1
  • Advanced data-cleaning functions, part 2

1 Readings

  • Optional: Upload the store transactions dataset to BigQuery

1 Quiz

  • Self-Reflection: Challenges with SQL

Module 3 challenge

    • 1 Readings
    • 1 Quiz
Show info about module content

1 Readings

  • Glossary terms from module 3

1 Quiz

  • Module 3 challenge

Manually cleaning data

    • 3 Videos
    • 2 Readings
    • 1 Quiz
Show info about module content

3 Videos

  • Verify and report results
  • Confirm data-cleaning meets business expectations
  • Verification of data cleaning

2 Readings

  • Step-by-Step: Verification of data cleaning
  • Data-cleaning verification checklist

1 Quiz

  • Test your knowledge on manual data cleaning

Document the cleaning process

    • 3 Videos
    • 2 Readings
    • 2 Quiz
Show info about module content

3 Videos

  • Capture cleaning changes
  • Why documentation is important
  • Feedback and cleaning

2 Readings

  • Embrace changelogs
  • Advanced functions for speedy data cleaning

2 Quiz

  • Self-Reflection: Creating a changelog
  • Test your knowledge on documenting the cleaning process

Module 4 challenge

    • 1 Readings
    • 1 Quiz
Show info about module content

1 Readings

  • Glossary terms from module 4

1 Quiz

  • Module 4 challenge

The data analyst hiring process

    • 3 Videos
    • 1 Quiz
Show info about module content

3 Videos

  • About the data-analyst hiring process
  • The data analyst job-application
  • Build a resume

1 Quiz

  • Hands-On Activity: Get started with your resume

Key elements of a data professional's resume

    • 2 Videos
    • 2 Readings
    • 1 Quiz
Show info about module content

2 Videos

  • Make your resume unique
  • Joseph: Black and African American inclusion in the data industry

2 Readings

  • The importance of diversity on a data analytics team
  • CareerCon resources on YouTube

1 Quiz

  • Hands-On Activity: Add job-ready skills to your resume

Highlight your skills and experience

    • 2 Videos
    • 2 Readings
    • 1 Quiz
Show info about module content

2 Videos

  • Translate past work experience
  • Kate: My career path as a data analyst

2 Readings

  • Add technical skills to your resume
  • Add professional skills to your resume

1 Quiz

  • Hands-On Activity: Continue refining your resume

Explore areas of interest

    • 1 Videos
Show info about module content

1 Videos

  • Where does your interest lie?

Course wrap-up

    • 1 Videos
    • 3 Readings
Show info about module content

1 Videos

  • Congratulations! Course wrap-up

3 Readings

  • Reflect and connect with peers
  • Course 4 glossary
  • Coming up next ...

Auto Summary

"Process Data from Dirty to Clean" is a foundational course in the Google Data Analytics Certificate, offered by Coursera. It focuses on equipping learners with essential data cleaning skills using spreadsheets and SQL, guided by current Google data analysts. The course spans 1440 minutes and is designed for beginners, with no prior experience required. Subscribers at the Starter level can access this engaging and practical course, ideal for those aiming for entry-level data analyst positions.

Google Career Certificates
Instructor

Google Career Certificates