|
所在平台: Coursera |
课程主页: https://www.coursera.org/learn/analyze-data
课程评论：没有评论
课程名称：分析数据以回答问题 概述： 本课程是谷歌数据分析证书的第五门课程，旨在培养学员具备申请初级数据分析师职位所需的技能。在本课程中，您将深入探索数据分析过程中的“分析”阶段，将之前所学的知识应用于数据分析，帮助您理解收集到的数据。您将学习如何使用电子表格和SQL整理和格式化数据，从而以不同的方式查看和思考数据。此外，您还将了解如何在数据中执行复杂计算，以实现商业目标。您将学习在分析过程中使用公式、函数和SQL查询。当前的谷歌数据分析师将继续指导您，提供完成常见数据分析任务所需的最佳工具和资源。 完成本课程后，学习者将能够申请初级数据分析师职位，无需先前经验。 课程目标： - 学习如何组织数据以便进行分析。 - 探索数据格式化和调整的流程。 - 理解如何在电子表格和SQL中聚合数据。 - 在电子表格中使用公式和函数进行数据计算。 - 学习如何使用SQL查询完成计算。 课程大纲： 1. 组织数据以提高分析效率 - 学习通过排序和过滤来组织数据的重要性，并在电子表格和SQL中探索相关流程。 2. 格式化和调整数据 - 了解如何转换和格式化数据，包括如何通过SQL查询合并数据，以及同事的反馈和支持对工作的帮助。 3. 聚合数据以进行分析 - 探索结合数据所需的函数、过程和语法，学习如何从多个电子表格单元和数据库表中聚合数据。 4. 执行数据计算 - 深入探讨电子表格中的公式、函数和数据透视表，以及SQL查询，帮助您进行数据计算，并了解使用SQL管理临时表的优势。
Name:Organize data for more effective analysis
Description:Organizing data makes the data easier to use in your analysis. In this part of the course, you’ll learn the importance of organizing your data through sorting and filtering. You’ll explore these processes in both spreadsheets and SQL as you continue to prepare your data.
Name:Format and adjust data
Description:As you move closer to analyzing your data, you’ll want to have it formatted and ready to go. In this part of the course, you’ll learn all about converting and formatting data, including how SQL queries can help you combine data. You’ll also find out the value of feedback and support from your colleagues and how it can lead to learnings that you can apply to your work.
Name:Aggregate data for analysis
Description:As part of your analysis, you’ll often have to combine data in order to gain insights and complete business objectives. In this part of the course, you’ll explore the functions, procedures, and syntax involved in combining, or aggregating, data. You’ll learn how to do this from multiple cells in spreadsheets and from multiple database tables using SQL queries.
Name:Perform data calculations
Description:Calculations are a common task for data analysts. In this part of the course, you’ll explore formulas, functions, and pivot tables in spreadsheets and queries in SQL, all of which will help with your calculations. You’ll also learn about the benefits of using SQL to manage temporary tables.
This is the fifth 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 explore the “analyze” phase of the data analysis process. You’ll take what you’ve learned to this point and apply it to your analysis to make sense of the data you’ve collected. You’ll learn how to organize and format your data using spreadsheets and SQL to help you look at and think about your data in different ways. You’ll also find out how to perform complex calculations on your data to complete business objectives. You’ll learn how to use formulas, functions, and SQL queries as you conduct your analysis. 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: - Learn how to organize data for analysis. - Discover the processes for formatting and adjusting data. - Gain an understanding of how to aggregate data in spreadsheets and by using SQL. - Use formulas and functions in spreadsheets for data calculations. - Learn how to complete calculations using SQL queries.
