Analyze Data to Answer Questions

Analyze Data to Answer Questions

课程
en
英语
26 时
此内容评级为 4.5/5
来源
  • 来自www.coursera.org
状况
  • 自定进度
  • 免费获取
  • 收费证书
更多信息
  • 4 序列
  • 等级 介绍

课程详情

教学大纲

WEEK 1: Organizing data to begin analysis
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 for analysis.

WEEK 2: Formatting and adjusting data
As you move closer to analyzing your data, you’ll want to have the data 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 new learning that you can apply to your work.

WEEK 3: Aggregating data for analysis
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.

WEEK 4: Performing data calculations
Calculations are one of the more common tasks that data analysts complete during analysis. 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.

先决条件

No prior experience with spreadsheets or data analytics is required. All you need is high-school level math and a curiosity about how things work. 

讲师

Google Career Certificates
Google Career Certificates are part of Grow with Google, an initiative that draws on Google's 20-year history of building products, platforms, and services that help people and businesses grow. Through programs like these, we aim to help everyone– those who make up the workforce of today and the students who will drive the workforce of tomorrow – access the best of Google’s training and tools to grow their skills, careers, and businesses.

编辑

谷歌是一家公司,由谷歌搜索引擎的创始人拉里-佩奇(Larry Page)和塞尔吉-布林(Sergueï Brin)于 1998 年 9 月 4 日在加利福尼亚州硅谷的谷歌车库创立。

该公司主要通过其搜索引擎的垄断地位而声名鹊起,先是面临 AltaVista 的竞争,然后是雅虎和必应的竞争。此后,该公司进行了一系列收购和开发,如今拥有许多著名的软件产品和网站,包括 YouTube、Android 手机操作系统以及 Google Earth、Google Maps 和 Google Play 等其他服务。

平台

Coursera是一家数字公司,提供由位于加利福尼亚州山景城的计算机教师Andrew Ng和达芙妮科勒斯坦福大学创建的大型开放式在线课程。

Coursera与顶尖大学和组织合作,在线提供一些课程,并提供许多科目的课程,包括:物理,工程,人文,医学,生物学,社会科学,数学,商业,计算机科学,数字营销,数据科学 和其他科目。

完成这个资源,写一篇评论