|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/process-data
课程评论：没有评论
课程名称：从脏数据到干净数据的处理 课程概述：这是谷歌数据分析证书的第四门课程。这些课程将使您具备申请初级数据分析师职位所需的技能。在本课程中，您将继续加深对数据分析的理解，以及数据分析师在工作中使用的工具和概念。您将学习如何使用电子表格和SQL检查和清理数据，并验证和报告数据清理结果。当前的谷歌数据分析师将继续授课，并提供实践方法来完成数据分析师常见任务所需的最佳工具和资源。完成此证书项目的学习者将具备申请初级数据分析师职位的能力，无需之前的经验。 课程结束时，您将能够做到以下几点： - 学习如何检查数据的完整性。 - 掌握使用电子表格进行数据清理的技巧。 - 开发基本的SQL查询以在数据库中使用。 - 应用基本的SQL函数以清理和转换数据。 - 理解如何验证数据清理的结果。 - 探索数据清理报告的要素及其重要性。 课程大纲： 1. **完整性的重要性**：数据完整性对于成功分析至关重要。在本部分课程中，您将探索分析师检查数据完整性的方法和步骤，包括在数据不足时该如何处理。您还将学习随机抽样及如何避免抽样偏差，这些方法将帮助确保您的分析成功。 2. **清理数据以获得更准确的见解**：每个数据分析师都希望分析干净的数据。在本部分课程中，您将学习清洁数据和脏数据之间的区别，并在电子表格等工具中练习清理数据。 3. **使用SQL进行数据清理**：掌握多种清理数据的方法可以使数据分析师的工作更轻松。在本部分课程中，您将使用SQL清理数据库中的数据，特别是探索如何使用SQL查询和函数在分析前清理和转换数据。 4. **验证和报告清理结果**：当您清理数据时，会对原始数据集进行更改。验证您所做的更改是否准确并通知团队成员是非常重要的。在本部分课程中，您将学习如何验证数据的清洁性并报告数据清理结果。通过验证的干净数据，您就可以开始分析了！ 5. **将数据添加到您的简历中**：创建有效的简历将有助于您的数据分析职业发展。在本部分课程中，您将了解求职申请过程，重点是打造突出您优势和相关经验的简历。 6. **课程总结**：回顾课程词汇表，并为谷歌数据分析证书项目的下一课程做好准备。
Name:The importance of integrity
Description: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.
Name:Clean data for more accurate insights
Description: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.
Name:Data cleaning with SQL
Description: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.
Name:Verify and report on cleaning results
Description: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!
Name:Add data to your resume
Description: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.
Name:Course wrap-up
Description:Review the course glossary and prepare for the next course in the Google Data Analytics Certificate program.
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.
