中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.
Process Data from Dirty to Clean
您将学到什么
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）
了解顶级公司的员工如何掌握热门技能
积累 Data Analysis 领域的专业知识
本课程是 Google Data Analytics 专业证书 专项课程的一部分
在注册此课程时，您还会同时注册此专业证书。
- 向行业专家学习新概念
- 获得对主题或工具的基础理解
- 通过实践项目培养工作相关技能
- 通过 Google 获得可共享的职业证书
该课程共有6个模块
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个作业
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个插件
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个插件
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个作业
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 个人资料、简历或履历中。在社交媒体和绩效考核中分享。
位教师
授课教师评分
4.9 (5,686个评价)
提供方
从 Data Analysis 浏览更多内容
状态：免费试用Johns Hopkins University
状态：免费试用
状态：免费试用
状态：免费试用
人们为什么选择 Coursera 来帮助自己实现职业发展
Felipe M.
自 2018开始学习的学生
''能够按照自己的速度和节奏学习课程是一次很棒的经历。只要符合自己的时间表和心情，我就可以学习。'
Jennifer J.
自 2020开始学习的学生
''我直接将从课程中学到的概念和技能应用到一个令人兴奋的新工作项目中。'
Larry W.
自 2021开始学习的学生
''如果我的大学不提供我需要的主题课程，Coursera 便是最好的去处之一。'
Chaitanya A.
''学习不仅仅是在工作中做的更好：它远不止于此。Coursera 让我无限制地学习。'
学生评论
4.8
18,489 条评论
- 5 stars
85.04%
- 4 stars
12.31%
- 3 stars
1.83%
- 2 stars
0.42%
- 1 star
0.37%
显示 3/18489 个
OO
5
已于 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
RH
5
已于 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
OO
5
已于 Jan 27, 2023审阅
The course covers the topic of data cleaning, handling missing values, outliers and errors using SQL and spreadsheets, which are important skills for data analysis and working with real-world data.
常见问题
Data is a group of facts that can take many different forms, such as numbers, pictures, words, videos, observations, and more. We use and create data everyday, like when we stream a show or song or post on social media.
Data analytics is the collection, transformation, and organization of these facts to draw conclusions, make predictions, and drive informed decision-making.
The amount of data created each day is tremendous. Any time you use your phone, look up something online, stream music, shop with a credit card, post on social media, or use GPS to map a route, you’re creating data. Companies must continually adjust their products, services, tools, and business strategies to meet consumer demand and react to emerging trends. Because of this, data analyst roles are in demand and competitively paid.
Data analysts make sense of data and numbers to help organizations make better business decisions. They prepare, process, analyze, and visualize data, discovering patterns and trends and answering key questions along the way. Their work empowers their wider team to make better business decisions.
You will learn the skill set required for becoming a junior or associate data analyst in the Google Data Analytics Certificate. Data analysts know how to ask the right question; prepare, process, and analyze data for key insights; effectively share their findings with stakeholders; and provide data-driven recommendations for thoughtful action.
You’ll learn these job-ready skills in our certificate program through interactive content (discussion prompts, quizzes, and activities) in under six months, with under 10 hours of flexible study a week. Along the way, you'll work through a curriculum designed with input from top employers and industry leaders, like Tableau, Accenture, and Deloitte. You’ll even have the opportunity to complete a case study that you can share with potential employers to showcase your new skill set.
After you’ve graduated from the program, you’ll have access to career resources and be connected directly with employers hiring for open entry-level roles in data analytics.
更多问题
提供助学金，