This is the second course in the Google Data Analytics Certificate. You’ll build on your understanding of the topics that were introduced in the first course of this certificate program. The material will help you learn how to ask effective questions, make data-driven decisions, and meet stakeholders’ needs. Current Google data analysts will instruct and provide you with hands-on ways to accomplish common data analytics tasks.
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 about effective questioning techniques that can help guide analysis.
- Gain an understanding of data-driven decision-making and how data analysts present findings.
- Explore a variety of real-world business scenarios as an example of questioning and decision-making.
- Discover how and why spreadsheets are an important tool for data analysts.
- Examine the key ideas associated with structured thinking and how they can help analysts better understand problems and develop solutions.
- Learn strategies for managing the expectations of stakeholders while establishing clear communication with a data analytics team to achieve business objectives.
Data analysts are constantly asking questions in order to find solutions and identify business potential. In this part of the course, you’ll learn about effective questioning techniques that will help guide your analysis.
涵盖的内容
8个视频6篇阅读材料6个作业1个插件
显示有关单元内容的信息
8个视频•总计35分钟
Introduction to problem-solving and effective questioning •3分钟
Data in action•5分钟
Nikki: The data process works•2分钟
Common problem types•6分钟
Continue exploring business applications•7分钟
Anmol: From hypothesis to outcome•2分钟
SMART questions•7分钟
Evan: Data opens doors•3分钟
6篇阅读材料•总计40分钟
Course 2 overview•8分钟
Helpful resources and tips•4分钟
From issue to action: The six data analysis phases•8分钟
Six common problem types•8分钟
More about SMART questions•8分钟
Glossary terms from course 2, module 1•4分钟
6个作业•总计104分钟
Module 1 challenge •40分钟
Test your knowledge on taking action with data•8分钟
Test your knowledge on solving problems with data•8分钟
Self-Reflection: Practice working SMART•20分钟
Self-Reflection: Ask your own SMART questions•20分钟
Test your knowledge on crafting effective questions•8分钟
1个插件•总计10分钟
Name the problem type•10分钟
Make data-driven decisions
第 2 单元•小时 后完成
单元详情
In analytics, data drives decision-making, and this is your opportunity to explore data of all kinds and its impact on all sorts of business decisions. You’ll also learn how to effectively share your data through reports and dashboards.
涵盖的内容
6个视频6篇阅读材料5个作业
显示有关单元内容的信息
6个视频•总计25分钟
Data and decisions•1分钟
How data empowers decisions•5分钟
Qualitative and quantitative data•4分钟
The big reveal: Sharing your findings•5分钟
Data versus metrics•4分钟
Mathematical thinking•5分钟
6篇阅读材料•总计40分钟
Data trials and triumphs•8分钟
Qualitative and quantitative data in business•8分钟
Tools for visualizing data•8分钟
Design compelling dashboards•8分钟
Big and small data•4分钟
Glossary terms from course 2, module 2•4分钟
5个作业•总计84分钟
Module 2 challenge •40分钟
Test your knowledge on the power of data •8分钟
Self-Reflection: Go deeper into dashboards•20分钟
Test your knowledge on following the evidence•8分钟
Test your knowledge on connecting the data dots•8分钟
Spreadsheet magic
第 3 单元•小时 后完成
单元详情
Spreadsheets are a key data analytics tool. Here you’ll learn both why and how data analysts use spreadsheets in their work. You’ll also investigate how structured thinking helps analysts understand problems and come up with solutions.
涵盖的内容
9个视频10篇阅读材料10个作业1个插件
显示有关单元内容的信息
9个视频•总计41分钟
The amazing spreadsheet•2分钟
Get to work with spreadsheets•2分钟
Basic spreadsheet tasks•5分钟
Formulas for success•7分钟
Spreadsheet errors and fixes•8分钟
Functions 101•6分钟
Before solving a problem, understand it•2分钟
Scope of work and structured thinking•5分钟
Staying objective•4分钟
10篇阅读材料•总计68分钟
Spreadsheets and the data life cycle•8分钟
Step-by-Step: Basic spreadsheet tasks•4分钟
Learn more about spreadsheet basics •8分钟
Step-by-Step: Formulas for success •8分钟
Quick Reference: Formulas in spreadsheets•8分钟
More about spreadsheet errors and fixes•8分钟
Step-by-Step: Functions 101•8分钟
Quick Reference: Functions in spreadsheets•8分钟
The importance of context•4分钟
Glossary terms from course 2, module 3•4分钟
10个作业•总计304分钟
Module 3 challenge •40分钟
Hands-On Activity: Introduction to Google Sheets•60分钟
Hands-On Activity: Data analysis and formulas: Bakery sales insights•20分钟
Test your knowledge on using formulas in spreadsheets•8分钟
Hands-On Activity: Create a custom data table•60分钟
Test your knowledge on using functions in spreadsheets•8分钟
Hands-On Activity: Create a scope of work•60分钟
Self-Reflection: Work with datasets•20分钟
Test your knowledge on structured thinking•8分钟
1个插件•总计10分钟
Creating a scope of work•10分钟
Always remember the stakeholder
第 4 单元•小时 后完成
单元详情
Successful data analysts balance the needs and expectations of their team and the stakeholders they support. In this part of the course, you’ll learn strategies for managing stakeholder expectations while establishing clear communication with your team.
涵盖的内容
14个视频8篇阅读材料3个作业1个插件
显示有关单元内容的信息
14个视频•总计51分钟
Communicating with your team•1分钟
Balance needs and expectations across your team•5分钟
Focus on what matters•5分钟
Clear communication is key •4分钟
Tips for effective communication•6分钟
Navigate expectations and realistic project goals•4分钟
Sarah: How to communicate with stakeholders•3分钟
The data tradeoff: Speed versus accuracy•4分钟
Think about your process and outcome•3分钟
Meeting best practices•6分钟
Ximena: Joining a new team•2分钟
From conflict to collaboration•4分钟
Nathan: From the U.S. Marine Corps to data analytics•3分钟
Congratulations! Course wrap-up•1分钟
8篇阅读材料•总计40分钟
Working with stakeholders•8分钟
Use multiple communication strategies to reach your audience•4分钟
Grow with Google is an initiative that draws on Google's decades-long history of building products, platforms, and services that help people and businesses grow. 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.
确定
人们为什么选择 Coursera 来帮助自己实现职业发展
Felipe M.
自 2018开始学习的学生
''能够按照自己的速度和节奏学习课程是一次很棒的经历。只要符合自己的时间表和心情,我就可以学习。'
Jennifer J.
自 2020开始学习的学生
''我直接将从课程中学到的概念和技能应用到一个令人兴奋的新工作项目中。'
Larry W.
自 2021开始学习的学生
''如果我的大学不提供我需要的主题课程,Coursera 便是最好的去处之一。'
Chaitanya A.
''学习不仅仅是在工作中做的更好:它远不止于此。Coursera 让我无限制地学习。'
学生评论
4.7
35,276 条评论
5 stars
79.93%
4 stars
15.79%
3 stars
2.96%
2 stars
0.71%
1 star
0.59%
显示 3/35276 个
M
MW
5·
已于 Mar 31, 2021审阅
I just finished the 2nd Course in the Google Data Analyst course - even though I have experience in the field, this course reminded of areas that I should focus on and work to strengthen my skills in.
R
RN
4·
已于 Oct 18, 2021审阅
Good level of practical activities with the Google Sheets errors task and the course challenge - but still a little basic with few opportunities to see formulas/functions in action or to use SQL.
S
SA
4·
已于 Mar 27, 2021审阅
I feel like this course was rather lackluster and only reinforces basics that most professionals and/or fresh graduates are already aware of. Regardless, it was a good refresher and quick paced.
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.