When you enroll in this course, you'll also be enrolled in this Professional Certificate.
Learn new concepts from industry experts
Gain a foundational understanding of a subject or tool
Develop job-relevant skills with hands-on projects
Earn a shareable career certificate from Google
There are 5 modules in this course
This is the second course in the Google Advanced Data Analytics Certificate. In this course, you’ll learn how to find the story within data and tell that story in a compelling way. You'll discover how data professionals use storytelling to better understand their data and communicate key insights to teammates and stakeholders. You'll also practice exploratory data analysis and learn how to create effective data visualizations.
Google employees who currently work in the field will guide you through this course by providing hands-on activities that simulate relevant tasks, sharing examples from their day-to-day work, and helping you build your data analytics skills to prepare for your career.
Learners who complete the eight courses in this program will have the skills needed to apply for data science and advanced data analytics jobs. This certificate assumes prior knowledge of foundational analytical principles, skills, and tools covered in the Google Data Analytics Certificate.
By the end of this course, you will:
-Use Python tools to examine raw data structure and format
-Select relevant Python libraries to clean raw data
-Demonstrate how to transform categorical data into numerical data with Python
-Utilize input validation skills to validate a dataset with Python
-Identify techniques for creating accessible data visualizations with Tableau
-Determine decisions about missing data and outliers
-Structure and organize data by manipulating date strings
You’ll learn how to find the stories within data and share them with your audience. You’ll learn about the methods and benefits of data cleaning and how it can help you discover those stories. You’ll also go over the steps of the EDA process and learn how EDA can help you quickly understand data. Finally, you'll explore different ways to visualize data to communicate key insights.
What's included
8 videos5 readings3 assignments2 plugins
Show info about module content
8 videos•Total 37 minutes
Introduction to Course 2•5 minutes
Robb: Obstacles and achievements•4 minutes
Welcome to module 1•1 minute
Find stories using the six exploratory data analysis practices •10 minutes
Benj: Data science and storytelling•3 minutes
Combine PACE and EDA practices•7 minutes
PACE with data visualizations•5 minutes
Wrap-up•3 minutes
5 readings•Total 34 minutes
Course 2 overview•8 minutes
Helpful resources and tips•8 minutes
Case study: Deloitte •8 minutes
Reference guide: The EDA process•8 minutes
Glossary terms from module 1•2 minutes
3 assignments•Total 62 minutes
Test your knowledge: Tell stories with data•6 minutes
Test your knowledge: How PACE informs EDA and data visualizations•6 minutes
Module 1 challenge•50 minutes
2 plugins•Total 20 minutes
Categorize: EDA best practices•10 minutes
[Turkish learners ONLY] Categorize: EDA best practices - Türkçe•10 minutes
Explore raw data
Module 2•7 hours to complete
Module details
Finding stories in data using EDA is all about organizing and interpreting raw data. Python can help you do this quickly and effectively. You’ll learn how to use Python to perform the EDA practices of discovering and sculpting.
You’ll explore three more EDA practices: cleaning, joining, and validating. You'll discover the importance of these practices for data analysis, and you’ll use Python to clean, validate, and join data.
Work with missing data in a Python notebook•12 minutes
Remy: A day in the life of a data professional•3 minutes
Account for outliers•6 minutes
Identify and deal with outliers in Python•14 minutes
Sort numbers versus names•5 minutes
Label encoding in Python•9 minutes
The value of input validation•7 minutes
Input validation with Python•8 minutes
Wrap-up•2 minutes
6 readings•Total 44 minutes
Data deduplication with Python•8 minutes
Protect the people behind the data•8 minutes
Reference guide: How to handle outliers•8 minutes
Other approaches to data transformation•8 minutes
Reference guide: Data cleaning in Python •8 minutes
Glossary terms from module 3•4 minutes
5 assignments•Total 76 minutes
Test your knowledge: The challenge of missing or duplicate data•8 minutes
Test your knowledge: The ins and outs of data outliers•6 minutes
Test your knowledge: Changing categorical data to numerical data•6 minutes
Test your knowledge: Input validation•6 minutes
Module 3 challenge•50 minutes
5 ungraded labs•Total 180 minutes
Annotated follow-along guide: Work with missing data in a Python notebook•20 minutes
Activity: Address missing data•60 minutes
Exemplar: Address missing data•20 minutes
Activity: Validate and clean your data•60 minutes
Exemplar: Validate and clean your data•20 minutes
2 plugins•Total 20 minutes
Identify: Python functions for cleaning data•10 minutes
[Turkish learners ONLY] Identify: Python functions for cleaning data - Türkçe•10 minutes
Data visualizations and presentations
Module 4•4 hours to complete
Module details
You’ll practice creating and presenting data stories in an ethical, accessible, and professional way. You'll also explore advanced data visualization techniques in Tableau.
What's included
8 videos11 readings5 assignments2 plugins
Show info about module content
8 videos•Total 41 minutes
Welcome to module 4•3 minutes
The visualization life cycle•5 minutes
Work with Tableau, Part 1•7 minutes
Work with Tableau, Part 2•7 minutes
Drew: Explore the possibilities of data•3 minutes
Craft compelling stories with Tableau•9 minutes
Present like a pro with Tableau•6 minutes
Wrap-up•1 minute
11 readings•Total 64 minutes
Tableau Public overview•8 minutes
How to sign on to Tableau Public •8 minutes
Download your datasets and begin presenting with Tableau •4 minutes
Follow-along guide: Work with Tableau, Part 1•4 minutes
Follow-along guide: Work with Tableau, Part 2•8 minutes
Activity Exemplar: Design a bar graph that tells a story in Tableau Public•4 minutes
Follow-along guide: Craft compelling stories with Tableau•8 minutes
The top five data visualization resources•8 minutes
Follow-along guide: Present like a pro with Tableau•4 minutes
Activity Exemplar: Build an interactive dashboard in Tableau Public•4 minutes
Glossary terms from module 4•4 minutes
5 assignments•Total 120 minutes
Test your knowledge: Present a story•4 minutes
Activity: Design a bar graph that tells a story in Tableau Public•30 minutes
Activity: Build an interactive dashboard in Tableau Public•30 minutes
In this end-of-course project, you’ll practice using Python to perform EDA on a workplace scenario dataset. Then, you'll use Python and Tableau to visualize the data.
What's included
4 videos10 readings4 assignments6 ungraded labs
Show info about module content
4 videos•Total 9 minutes
Welcome to module 5•3 minutes
Introduction to your Course 2 end-of-course portfolio project•1 minute
End-of-course project wrap-up and tips for ongoing career success•2 minutes
Course wrap-up•3 minutes
10 readings•Total 52 minutes
Explore your Course 2 workplace scenarios•8 minutes
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.
"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."
Jennifer J.
Learner since 2020
"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."
Larry W.
Learner since 2021
"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."
Chaitanya A.
"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."
Learner reviews
4.7
913 reviews
5 stars
82.80%
4 stars
12.48%
3 stars
2.08%
2 stars
1.31%
1 star
1.31%
Showing 3 of 913
M
MB
5·
Reviewed on Feb 11, 2024
Very well designed course for anyone having experience of any field willing to dive into data analytics.
M
MH
5·
Reviewed on Dec 19, 2023
The Course was very effective which increased my skills, knowledge and confidence level.
J
JM
5·
Reviewed on Aug 22, 2023
Very Helpful Course! The storytell methods described are really helpful to me. I have always had an issue with getting my point across but now I know where my problem was and have corrected it.
Organizations of all types and sizes have business processes that generate massive volumes of data. Every moment, all sorts of information gets created by computers, the internet, phones, texts, streaming video, photographs, sensors, and much more. In the global digital landscape, data is increasingly imprecise, chaotic, and unstructured. As the speed and variety of data increases exponentially, organizations are struggling to keep pace.
Data science and advanced data analytics are part of a field of study that uses raw data to create new ways of modeling and understanding the unknown. To gain insights, businesses rely on data professionals to acquire, organize, and interpret data, which helps inform internal projects and processes. Data scientists and advanced data analysts rely on a combination of critical skills, including statistics, scientific methods, data analysis, and artificial intelligence.
What do data professionals do?
A data professional is a term used to describe any individual who works with data and/or has data skills. At a minimum, a data professional is capable of exploring, cleaning, selecting, analyzing, and visualizing data. They may also be comfortable with writing code and have some familiarity with the techniques used by statisticians and machine learning engineers, including building models, developing algorithmic thinking, and building machine learning models.
Data professionals are responsible for collecting, analyzing, and interpreting large amounts of data within a variety of different organizations. The role of a data professional is defined differently across companies. Generally speaking, data professionals possess technical and strategic capabilities that require more advanced analytical skills such as data manipulation, experimental design, predictive modeling, and machine learning. They perform a variety of tasks related to gathering, structuring, interpreting, monitoring, and reporting data in accessible formats, enabling stakeholders to understand and use data effectively. Ultimately, the work of data professionals helps organizations make informed, ethical decisions.
Why start a career in data science or advanced data analytics?
Large volumes of data — and the technology needed to manage and analyze it — are becoming increasingly accessible. Because of this, there has been a surge in career opportunities for people who can tell stories using data, such as senior data analysts and data scientists. These professionals collect, analyze, and interpret large amounts of data within a variety of different organizations. Their responsibilities require advanced analytical skills such as data manipulation, experimental design, predictive modeling, and machine learning.
Which jobs will this certificate help me prepare for?
The Google Advanced Data Analytics Certificate on Coursera is designed to prepare learners for roles as entry-level data scientists and advanced-level data analysts.
What tools and platforms are taught in the curriculum?
During this certificate program, you’ll gain knowledge of tools and platforms like Jupyter Notebook, Kaggle, Python, Stack Overflow, and Tableau.
What background is required?
This certificate program assumes prior knowledge of foundational analytical principles, skills, and tools. To succeed in this certificate program, you should already know about key foundational aspects of data analysis, such as the data analysis process and data life cycle, databases and general database elements, programming language basics, and project stakeholders.
The content in this certificate program builds upon data analytics concepts taught in the Google Data Analytics Certificate. These include key foundational aspects of data analysis such as the data analysis process and data life cycle, databases and general database elements such as primary and foreign keys, SQL and programming language basics, and project stakeholders. If you haven’t completed that program or if you’re unsure whether you have the necessary prerequisites, you can take an ungraded assessment in Course 1 Module 1 of this certificate to evaluate your readiness.
Why enroll in the Google Advanced Data Analytics Certificate?
You’ll learn job-ready skills through interactive content — like activities, quizzes, and discussion prompts — in under six months, with less than 10 hours of flexible study a week. Along the way, you’ll work through a curriculum designed by Google employees who work in the field, with input from top employers and industry leaders. You’ll even have the opportunity to complete end-of-course projects and a final capstone project that you can share with potential employers to showcase your data analysis skills. 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 science and advanced roles in data analytics.
Do I need to take the course in a certain order?
We highly recommend completing the seven courses in the order presented because the content in each course builds on information covered in 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.