This is the fifth course in the Google Data Analytics Certificate. In this course, you’ll explore what it means to actually analyze your data. You’ll take what you’ve learned up to this point and apply it 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 with your data to address 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.
Analyze Data to Answer Questions
Analyze Data to Answer Questions
本课程是 Google Data Analytics 专业证书 的一部分
访问权限由 Coursera Learning Team 提供
784,831 人已注册
您将学到什么
Discuss the importance of organizing your data before analysis by using sorts and filters.
Convert and format data.
Apply the use of functions and syntax to create SQL queries to combine data from multiple database tables.
Describe the use of functions to conduct basic calculations on data in spreadsheets.
您将获得的技能
要了解的详细信息
添加到您的领英档案
30 项作业
了解顶级公司的员工如何掌握热门技能
积累 Data Analysis 领域的专业知识
- 向行业专家学习新概念
- 获得对主题或工具的基础理解
- 通过实践项目培养工作相关技能
- 通过 Google 获得可共享的职业证书
该课程共有4个模块
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.
涵盖的内容
9个视频13篇阅读材料6个作业
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.
涵盖的内容
10个视频9篇阅读材料5个作业1个插件
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.
涵盖的内容
8个视频10篇阅读材料9个作业1个插件
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.
涵盖的内容
13个视频13篇阅读材料10个作业1个插件
获得职业证书
将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。
位教师
提供方
人们为什么选择 Coursera 来帮助自己实现职业发展
Felipe M.
Jennifer J.
Larry W.
Chaitanya A.
学生评论
- 5 stars
74.60%
- 4 stars
16.40%
- 3 stars
5.23%
- 2 stars
2.13%
- 1 star
1.61%
显示 3/12175 个
已于 Oct 20, 2023审阅
Thank you coursera for this course, it covered many things and helped me learn a lot. I loved the instructor just that her voice was a bit too low but other than that it was wonderful. THANK YOU
已于 Apr 12, 2021审阅
This course is very great for gaining hands-on experience with SQL, as well as instilling the critical thinking skills essential to the data analysis process. Definitely worth the pricetag.
已于 Jan 6, 2022审阅
An excellent course for learning analysis techniques using Spreadsheets and SQL. Recommended for all engineering and data science students as well as for those managing businesses and human resource.
