What is data analytics?

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.

Why start a career in data analytics?

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.

Why enroll in the Google Data Analytics Certificate?

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.

What background is required?

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.

Do you need to be strong at math to succeed in this certificate?

You don't need to be a math all-star to succeed in this certificate. You need to be curious and open to learning with numbers (the language of data analysts). Being a strong data analyst is more than just math, it's about asking the right questions, finding the best sources to answer your questions effectively, and illustrating your findings clearly in visualizations.

What tools and platforms are taught in the curriculum?

You'll learn to use analysis tools and platforms such as spreadsheets (Google Sheets or Microsoft Excel), SQL, presentation tools (Powerpoint or Google Slides), Tableau, Python, and Kaggle.

Which “spreadsheet” platform is being taught?

Learners can self-select which platform they want to use throughout the program: Google Sheets or Microsoft Excel. It’s up to the learner’s preference, and all activities throughout the syllabus can be performed on either platform.

Do you need to take each course in course order?

We highly recommend completing the courses in the order presented because the content in each course builds on information from earlier lessons.

When will I have access to the lectures and assignments?

To access the course materials, assignments and to earn a Certificate, you will need to purchase the Certificate experience when you enroll in a course. You can try a Free Trial instead, or apply for Financial Aid. The course may offer 'Full Course, No Certificate' instead. This option lets you see all course materials, submit required assessments, and get a final grade. This also means that you will not be able to purchase a Certificate experience.

What will I get if I subscribe to this Certificate?

When you enroll in the course, you get access to all of the courses in the Certificate, and you earn a certificate when you complete the work. Your electronic Certificate will be added to your Accomplishments page - from there, you can print your Certificate or add it to your LinkedIn profile.

Analyze Data to Answer Questions

本课程是 Google Data Analytics 专业证书的一部分

位教师：Google Career Certificates

815,799 人已注册

包含在中

了解更多

4个模块

深入了解一个主题并学习基础知识。

12,235 条评论

初级等级

推荐体验

灵活的计划

3 周在 10 小时一周

自行安排学习进度

96%

大多数学生喜欢此课程

4个模块

深入了解一个主题并学习基础知识。

12,235 条评论

初级等级

推荐体验

灵活的计划

3 周在 10 小时一周

自行安排学习进度

96%

大多数学生喜欢此课程

您将学到什么

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 项作业

授课语言：英语（English）

积累 Data Analysis 领域的专业知识

本课程是 Google Data Analytics 专业证书专项课程的一部分

在注册此课程时，您还会同时注册此专业证书。

向行业专家学习新概念
获得对主题或工具的基础理解
通过实践项目培养工作相关技能
通过 Google 获得可共享的职业证书

该课程共有4个模块

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.

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, learners will: - Learn how to organize data for analysis. - Understand the processes for formatting and adjusting data. - Explore how to aggregate data in spreadsheets and by using SQL. - Use formulas and functions in spreadsheets to make data calculations. - Learn how to complete calculations using SQL queries.

单元详情

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个作业

9个视频总计37分钟

Introduction to getting organized3分钟
The analysis process5分钟
Ayanna: Sticking with it2分钟
Always a need to organize 3分钟
Filter data with SQL5分钟
Sort data in spreadsheets5分钟
Use the SORT function in spreadsheets5分钟
Emma: Journey to a meaningful career2分钟
Sort data with SQL8分钟

13篇阅读材料总计70分钟

Course 5 overview8分钟
Helpful resources and tips4分钟
Sort and filter data to keep it organized8分钟
Review: Set up your BigQuery account8分钟
Review: Get started with BigQuery4分钟
Working with .csv files4分钟
Upload the movie dataset to BigQuery4分钟
Step-by-Step: Filter data with SQL4分钟
Step-by-step: Sort datasets in spreadsheets4分钟
Step-by-step: Use the SORT function in spreadsheets4分钟
Sort and filter in Sheets and Excel8分钟
Step-by-Step: Sort data with SQL8分钟
Glossary terms from module 12分钟

6个作业总计184分钟

Test your knowledge on organizing data for analysis8分钟
Test your knowledge on sorting data in spreadsheets 8分钟
Hands-On Activity: SQL sorting queries60分钟
Hands-On Activity: Analyze weather data in BigQuery60分钟
Test your knowledge on sorting data with SQL 8分钟
Module 1 challenge40分钟

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个插件

10个视频总计38分钟

Get started with data formatting 1分钟
From one type to another 5分钟
Data validation4分钟
Conditional formatting 5分钟
Merge text strings to gain insights5分钟
Strings in spreadsheets 3分钟
When you get stuck3分钟
Layla: All about the analyze stage3分钟
Running into challenges? Not to worry!6分钟
When to use which tool2分钟

9篇阅读材料总计58分钟

Step-by-Step: From one type to another8分钟
Convert data in spreadsheets 8分钟
Transform data with SQL4分钟
Import and combine data in spreadsheets and databases8分钟
Step-by-Step: Merge text strings to gain insights8分钟
Step-by-Step: Strings in spreadsheets 8分钟
Manipulate strings with SQL4分钟
Advanced spreadsheet tips and tricks8分钟
Glossary terms from module 22分钟

5个作业总计136分钟

Test your knowledge on converting and formatting data8分钟
Hands-On Activity: Combine multiple pieces of data60分钟
Test your knowledge on combining multiple datasets 8分钟
Self-Reflection: Stack Overflow 20分钟
Module 2 challenge40分钟

1个插件总计10分钟

SQL query syntax10分钟

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个插件

8个视频总计41分钟

Aggregate data for analysis 3分钟
Prepare for VLOOKUP5分钟
VLOOKUP in action3分钟
Identify and fix common VLOOKUP errors 6分钟
Explore how JOINs work 8分钟
Queries within queries7分钟
Use subqueries to aggregate data 7分钟
Justin: Where data analysis takes you 2分钟

10篇阅读材料总计74分钟

VLOOKUP Core Concepts 8分钟
Upload the employee dataset to BigQuery8分钟
Step-by-Step: Explore how JOINs work8分钟
Secret identities: The importance of aliases8分钟
Use JOINs effectively 8分钟
Upload the warehouse dataset to BigQuery8分钟
Step-by-Step: Queries within queries8分钟
Step-by-Step: Use subqueries to aggregate data8分钟
SQL functions and subqueries: A functional friendship8分钟
Glossary terms from module 32分钟

9个作业总计364分钟

Hands-On Activity: Use VLOOKUP to perform a task60分钟
Test your knowledge on VLOOKUP8分钟
Hands-On Activity: Queries for JOINS60分钟
Hands-On Activity: COUNT and COUNT DISTINCT60分钟
Test your knowledge on using JOINS to aggregate data 8分钟
Hands-On Activity: Use subqueries to refine data60分钟
Hands-on activity: Use subqueries60分钟
Test your knowledge on working with subqueries 8分钟
Module 3 challenge40分钟

1个插件总计10分钟

Review subqueries10分钟

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个插件

13个视频总计70分钟

Data calculations 2分钟
Common calculation formulas 10分钟
Functions and conditions9分钟
Composite functions 6分钟
Start working with pivot tables 7分钟
Pivot tables continued5分钟
Queries and calculations4分钟
Embed simple calculations with SQL7分钟
Calculations with other statements 4分钟
Check and recheck5分钟
Temporary tables6分钟
Multiple table variations4分钟
Congratulations! Course wrap-up1分钟

13篇阅读材料总计80分钟

Functions with multiple conditions8分钟
Elements of a pivot table4分钟
Use pivot tables in analysis 8分钟
Upload the avocado dataset to BigQuery8分钟
Step-by-Step: Embed simple calculations with SQL8分钟
Types of data validation4分钟
Work with temporary tables 8分钟
Your intermediate guide to SQL 8分钟
Use Connected Sheets with BigQuery8分钟
Glossary terms from module 44分钟
Reflect and connect with peers4分钟
Course 5 glossary4分钟
Coming up next...4分钟

10个作业总计372分钟

Hands-On Activity: Work with conditions60分钟
Test your knowledge on data calculations 8分钟
Hands-On Activity: Explore movie data with pivot tables60分钟
Test your knowledge on pivot tables 8分钟
Hands-On Activity: Calculations with SQL 60分钟
Test your knowledge on SQL calculations 8分钟
Hands-On Activity: From spreadsheets to BigQuery60分钟
Hands-On Activity: Create temporary tables 60分钟
Test your knowledge on using SQL with temporary tables 8分钟
Module 4 challenge 40分钟

1个插件总计10分钟

Start validating10分钟

获得职业证书

将此证书添加到您的 LinkedIn 个人资料、简历或履历中。在社交媒体和绩效考核中分享。

位教师

授课教师评分

(3,555个评价)

Google Career Certificates

Google

386 门课程16,646,662 名学生

提供方

Google

学生评论

5 stars
74.60%
4 stars
16.38%
3 stars
5.21%
2 stars
2.14%
1 star
1.64%

显示 3/12235 个

已于 Jul 26, 2022审阅

Excellent course for Learning SQL and important Data analytics, Course well structured for learning we have been provided most useful link to understand cocepts and become expertise in SQL

已于 Jun 25, 2024审阅

I found this course the hardest within the Google Data Analytics certification. It was challenging, there was a lot of new information, I had to reflect and try new things a lot! Way to go!

已于 May 29, 2023审阅

alot harder than the other courses but it was still goodsome of the data sets you have to work with is outdated or isnt there on Big query other tha that all was good i learnt alot and enjoyed myself

查看更多评论