Process Data from Dirty to Clean

本课程是 Google Data Analytics 专业证书的一部分

位教师：Google Career Certificates

访问权限由 New York State Department of Labor 提供

908,562 人已注册

6个模块

深入了解一个主题并学习基础知识。

18,782 条评论

初级等级

推荐体验

灵活的计划

2 周在 10 小时一周

自行安排学习进度

98%

大多数学生喜欢此课程

6个模块

深入了解一个主题并学习基础知识。

18,782 条评论

初级等级

推荐体验

灵活的计划

2 周在 10 小时一周

自行安排学习进度

98%

大多数学生喜欢此课程

您将学到什么

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.

您将获得的技能

要了解的详细信息

可分享的证书

添加到您的领英档案

作业

21 项作业

授课语言：英语（English）

了解顶级公司的员工如何掌握热门技能

了解关于 Coursera for Business 的更多信息

Petrobras, TATA, Danone, Capgemini, P&G 和 L'Oreal 的徽标

积累 Data Analysis 领域的专业知识

本课程是 Google Data Analytics 专业证书专项课程的一部分

在注册此课程时，您还会同时注册此专业证书。

向行业专家学习新概念
获得对主题或工具的基础理解
通过实践项目培养工作相关技能
通过 Google 获得可共享的职业证书

该课程共有6个模块

This is the fourth course in the Google Data Analytics Certificate. 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, learners will: - 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

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.

涵盖的内容

8个视频10篇阅读材料6个作业

8个视频总计33分钟

Introduction to data integrity 4分钟
Why data integrity is important 3分钟
Balance objectives with data integrity 3分钟
Deal with insufficient data 4分钟
The importance of sample size 3分钟
Using statistical power 5分钟
Determine the best sample size 5分钟
Evaluate data reliability 6分钟

10篇阅读材料总计68分钟

Course 4 overview 8分钟
Helpful resources and tips 4分钟
More about data integrity and compliance 8分钟
Well-aligned objectives and data 8分钟
When you find an issue with your data 4分钟
Calculate sample size 8分钟
When data isn't readily available 8分钟
Sample size calculator 8分钟
All about margin of error 8分钟
Glossary terms from module 1 4分钟

6个作业总计92分钟

Test your knowledge on data integrity and analytics objectives 8分钟
Self-Reflection: Pre-cleaning activities 20分钟
Test your knowledge on insufficient data 8分钟
Test your knowledge on testing your data 8分钟
Test your knowledge on margin of error 8分钟
Module 1 challenge 40分钟

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.

涵盖的内容

10个视频10篇阅读材料6个作业1个插件

10个视频总计66分钟

Clean it up! 3分钟
Why data cleaning is critical 6分钟
Angie: I love cleaning data 1分钟
Recognize and remedy dirty data 5分钟
Data-cleaning tools and techniques 6分钟
Clean data from multiple sources 6分钟
Data-cleaning features in spreadsheets 8分钟
Optimize the data-cleaning process 14分钟
Different data perspectives 10分钟
Even more data-cleaning techniques 7分钟

10篇阅读材料总计72分钟

What is dirty data? 8分钟
Common data-cleaning pitfalls 8分钟
Step-by-Step guide: Data-cleaning features in spreadsheets 8分钟
Step-by-Step: Optimize the data-cleaning process 8分钟
Workflow automation 8分钟
Step-by-Step: Different data perspectives 8分钟
Step-by-Step: Even more data-cleaning techniques 8分钟
Working with .csv files 4分钟
Develop your approach to cleaning data 8分钟
Glossary terms from module 2 4分钟

6个作业总计184分钟

Test your knowledge on data cleaning 8分钟
Hands-On Activity: Cleaning data with spreadsheets 60分钟
Test your knowledge on the first steps toward clean data 8分钟
Hands-On Activity: Clean data with spreadsheet functions 60分钟
Test your knowledge on cleaning data in spreadsheets 8分钟
Module 2 challenge 40分钟

1个插件总计10分钟

Principles of data integrity 10分钟

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.

涵盖的内容

9个视频7篇阅读材料5个作业1个插件

9个视频总计49分钟

Use SQL to clean data 1分钟
Sally: For the love of SQL 3分钟
Understand SQL capabilities 3分钟
Spreadsheets versus SQL 4分钟
Widely used SQL queries 6分钟
Evan: Having fun with SQL 3分钟
Clean string variables using SQL 13分钟
Advanced data-cleaning functions, part 1 6分钟
Advanced data-cleaning functions, part 2 9分钟

7篇阅读材料总计42分钟

How a junior data analyst uses SQL 4分钟
SQL dialects and their uses 8分钟
Review: Set up your BigQuery account 8分钟
Review: Get started with BigQuery 8分钟
Optional: Upload the customer dataset to BigQuery 4分钟
Optional: Upload the store transactions dataset to BigQuery 8分钟
Glossary terms from module 3 2分钟

5个作业总计195分钟

Hands-On Activity: Processing time with SQL 60分钟
Hands-On Activity: Clean data using SQL 60分钟
Test your knowledge on SQL queries 10分钟
Self-Reflection: Challenges with SQL 20分钟
Module 3 challenge 45分钟

1个插件总计10分钟

Data-cleaning with SQL functions 10分钟

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!

涵盖的内容

6个视频5篇阅读材料4个作业

6个视频总计28分钟

Verify and report results 3分钟
Confirm data-cleaning meets business expectations 5分钟
Verification of data cleaning 8分钟
Capture cleaning changes 6分钟
Why documentation is important 3分钟
Feedback and cleaning 2分钟

5篇阅读材料总计26分钟

Step-by-Step: Verification of data cleaning 8分钟
Data-cleaning verification checklist 4分钟
Embrace changelogs 8分钟
Advanced functions for speedy data cleaning 4分钟
Glossary terms from module 4 2分钟

4个作业总计76分钟

Test your knowledge on manual data cleaning 8分钟
Self-Reflection: Creating a changelog 20分钟
Test your knowledge on documenting the cleaning process 8分钟
Module 4 challenge 40分钟

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.

涵盖的内容

3个视频2篇阅读材料

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

涵盖的内容

1个视频3篇阅读材料

获得职业证书

将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。

位教师

授课教师评分

(5,772个评价)

Google Career Certificates

Google

386 门课程 15,927,138 名学生

提供方

Google

人们为什么选择 Coursera 来帮助自己实现职业发展

Felipe M.

自 2018开始学习的学生

''能够按照自己的速度和节奏学习课程是一次很棒的经历。只要符合自己的时间表和心情，我就可以学习。'

Jennifer J.

自 2020开始学习的学生

''我直接将从课程中学到的概念和技能应用到一个令人兴奋的新工作项目中。'

Larry W.

自 2021开始学习的学生

''如果我的大学不提供我需要的主题课程，Coursera 便是最好的去处之一。'

Chaitanya A.

''学习不仅仅是在工作中做的更好：它远不止于此。Coursera 让我无限制地学习。'

学生评论

5 stars
85.12%
4 stars
12.21%
3 stars
1.84%
2 stars
0.43%
1 star
0.38%

显示 3/18782 个

已于 Oct 27, 2023审阅

Fun, concise, and on point course walking new folks through (or a great review for not so new folks) the process of identification, basic change management, and reporting for dataset validation

已于 Jul 7, 2025审阅

Great way of teaching, her lectures were outstaning and engaging, understood each and every concepts very clearly. Thank you Google and Coursera team for making us to interact with such personality...

已于 Oct 26, 2021审阅

Good content overall. However it will be nice to have the glossary for each week not mixed up with those from previous as it makes it hard to navigate and know which new words need to be learnt

查看更多评论