Google Data Analytics Professional Certificate

This is your path to a career in Data Analytics. Learn in-demand skills to have you job-ready to succeed in an entry-level Data Analytics job

no degree or experience required
Videos
200
Exercises
0
quizzes
50
Readings
150
proud partners

Pave your career path to become job-ready and put your skills to work

What you Will Learn

1

Data Analysis Tools

Have working knowledge of essential platforms (spreadsheets, SQL, Tableau, R programming) and when to use them in the data lifecycle

2

Design Thinking

Understand how to translate a business question into a data analysis exercise, including transforming, visualizing, and modeling data

3

Experiential Learning

Know how to distill findings into actionable takeaways

4

Portfolio Development

Complete a capstone project to put it in your resume and portfolio to showcase your skills to hiring partners

Junior Data Analyst
Associate Data Analyst
Data Technician
Marketing Analyst
Finance Analyst
Operations Analyst
Business Performance Analyst
Healthcare Analyst

JObs Associated

Skills you will gain

R Programming
R Studio
Metadata
Data Cleansing
Questioning
Data Ethics
Data Visualization
Decision Making
Problem Solving
Data Collection
Sample Size Determination
SQL
Module 1 - Foundations: Data, Data, Everywhere
ABOUT THIS MODULE

You will gain a deeper understanding of foundational data analytics terminology and the role responsibilities of a data analyst. An introduction to the kind of jobs you might pursue after completing this program is also covered.

 
WHAT YOU WILL LEARN

-  Insight into practices & processes used by junior or associate data analyst in their day-to-day job

-  Develop key analytical skills such as data cleaning, data analysis, & data visualization 

-  Discover a wide variety of terms and concepts relevant to the role of a junior data analyst

-  Evaluate the role of analytics in the data ecosystem

-  Conduct an analytical thinking self-assessment

-  Learn about best practices in job search

-  Explore job opportunities available upon program completion

 
SKILLS ACQUIRED

Spreadsheet Basics | Database & Query Basics | Data Visualization (DataViz) Basics

 

TOPICS

Introduction to Data Analytics | Thinking Analytically | Exploring the world of Data | Setting up Data Toolbox | Discovering Data Career Possibilities

Module 2 - Ask Questions to Make Data-Driven Decisions
ABOUT THIS MODULE

You will build on the topics introduced in the first course and cover how to ask effective questions to make data-driven decisions, while connecting with stakeholders’ needs.

 

WHAT YOU WILL LEARN

-  Learn about effective questioning techniques that can help guide analysis

-  Gain an understanding of data-driven, decision-making, & how data analysts present findings

-  Explore a variety of real-world business scenarios to support an understanding of questioning & decision-making

-  Discover how & 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

-  Manage the expectations of stakeholders while establishing clear communication with a data analytics team to achieve business objectives

 
SKILLS ACQUIRED

Spreadsheet Formulas & Functions | Asking SMART & Effective Questions | Dashboard Basics, including Tableau | Managing Team & Stakeholder expectations

 
TOPICS

Asking Effective Questions | Making Data-Driven Decisions | Learning Spreadsheet Basics | Managing Stakeholder Expectations

Module 3 - Prepare Data for Exploration
ABOUT THIS MODULE

You will build on the topics introduced in the first two courses and cover how to use tools like spreadsheets and SQL to extract and make use of the right data for key objectives in an organized and protected manner.

 
WHAT YOU WILL LEARN

-  Find out how analysts decide which data to collect for analysis

-  Discover how to identify different types of bias in data to help ensure data credibility

-  Explore how analysts use spreadsheets & SQL with databases & data sets

-  Examine open data & the relationship between & importance of data ethics and data privacy

-  Learn how to access databases and extract, filter, & sort the data they contain

-  Learn the best practices for organizing data & keeping it secure

 
SKILLS ACQUIRED

Understanding Data Types, Fields, & Values | Writing Simple Queries | Metadata in Data Analytics | SQL Functions

 
TOPICS

Data Types & Data Structures | Understanding Bias, Credibility, Privacy, Ethics, and access | Databases: where Data lives | Organizing & Protecting your Data | Engaging in the Data Community (Optional)

Module 4 - Process Data from Dirty to Clean
ABOUT THIS MODULE

You will build on topics introduced in previous courses and also explore how to check and clean data using spreadsheets and SQL. We also explore how to verify and report data cleaning results.

 
WHAT YOU WILL LEARN

-  Learn how to check for data integrity

-  Discover data cleaning techniques using spreadsheets

-  Develop basic SQL queries for use on databases

-  Apply basic SQL functions for cleaning and transforming data

-  Learn how to verify the results of cleaning data

-  Explore the elements and importance of data cleaning reports

 
SKILLS ACQUIRED

Statistics, Hypothesis Testing, & Margin of Error | Tools & Processes for Data Cleansing | Data Integrity

 

TOPICS

Before you clean, Check for integrity | All about Clean Data | Cleaning Data in SQL | Verify & report your cleaning results | Adding Data to your Resume (Optional) 

Module 5 - Analyze Data to Answer Questions
 
ABOUT THIS MODULE

You will explore the “analyze” phase of the data analysis process by learning how to organize and format the data using spreadsheets & SQL to help you look at and think about your data in different ways. Discover how to perform complex calculations on data to complete business objectives. Additionally, learners are exposed to how to use formulas, functions, & SQL queries to conduct analysis.

 
WHAT YOU WILL LEARN 

-  Learn how to organize data for analysis

-  Discover the processes for formatting and adjusting data

-  Learn how to aggregate data in spreadsheets and by using SQL

-  Use formulas and functions in spreadsheets for data calculations

-  Learn how to complete calculations using SQL queries

 
SKILLS ACQUIRED

Sorting & Filtering Data with SQL | Spreadsheet Calculations | SQL Calculations | Data Validation | Temporary & Pivot tables

 

TOPICS

Organising Data to begin Analysis | Formatting & Adjusting Data | Aggregating Data for Analysis | Performing Data Calculations 

Module 6 - Share Data Through the Art of Visualization
 
ABOUT THIS MODULE

You will explore how to visualize & present data findings during the data analysis process. This module demonstrates how data visualizations, such as visual dashboards, can help bring data to life. You will also explore Tableau, a data visualization platform that helps create effective visualizations for presentations.

 
WHAT YOU WILL LEARN 

-  Examine the importance of data visualization

-  Learn how to form a compelling narrative through data stories

-  Learn how to use Tableau to create dashboards & dashboard filters

-  Learn how to use Tableau to create effective visualizations

-  Learn the principles & practices involved with effective presentations

-  Learn how to consider potential limitations associated with the data in your presentations

-  Learn how to apply best practices to a Q&A with your audience

 
SKILLS ACQUIRED

Design Thinking | Tableau Software | Data-Driven Storytelling | Dashboards & Dashboard Filters

 

TOPICS

Visualizing Data | Creating Data Visualizations with Tableau | Crafting Data Stories | Developing Presentations & Slideshows

Module 7 - Data Analysis with R Programming
 
ABOUT THIS MODULE

You will explore he programming language known as R with an environment called RStudio. This course also covers the software applications and tools that are unique to R, such as R packages. You will also discover how to clean, organize, analyze, visualize, and report data in new and more powerful ways using R.

 
WHAT YOU WILL LEARN 

-  Examine the benefits of using the R programming language

-  Discover how to use RStudio to apply R to data analysis

-  Learn the fundamental concepts associated with programming in R

-  Explore the contents & components of R packages including the Tidyverse package

-  Gain an understanding of dataframes and their use in R

-  Discover the options for generating visualizations in R

-  Learn about R Markdown for documenting R programming

 
SKILLS ACQUIRED

R Programming Functions | R Programming Variables | R Programming Data Types, Pipes, & Vectors | Coding, Writing Functions, Accessing & Cleaning Data, & Generating Visualizations in R

 
TOPICS

Programming & Data Analytics | Programming using R Studio | More about Visualizations, Aesthetics, & Annotations  | Documentation & Reports 

Module 8 - Capstone: Complete a Case Study
 
ABOUT THIS MODULE

You will have the opportunity to complete an optional case study. The case studies are commonly used by employers to assess analytical skills. For their case study, they’ll choose an analytics-based scenario, ask questions, prepare, process, analyze, visualize and act on the data from the scenario.

 
WHAT YOU WILL LEARN 

-  Learn the benefits & uses of case studies and portfolios in the job search

-  Discover real world job interview scenarios & common interview questions

-  Discover how case studies can be a part of the job interview process

-  Examine & consider different case study scenarios

-  Have the chance to complete your own case study for your portfolio

 
SKILLS ACQUIRED

Building a Job Portfolio | Practical, real-world Problem Solving | Clear Presentation of Data Findings | Showcasing Data Analytics Skills, Knowledge, & Technical Expertise

 

TOPICS

Learn about Capstone Basics | Putting your Certificate to Work | Aggregating Data for Analysis | Building your Portfolio (Optional) | Using your Portfolio (Optional) 

Explore Modules

Employer consortium
Meet Employers that recognise Google Career Certificate as relevant Work Experience in their recruitment process

Hear from Google's Graduates who paved their path to career success

The Google Data Analytics Certificate is a great program. In my personal experience, it got me somewhere. Even if you get an entry level job, you start at a decent salary and get your foot in the door, into an industry that is booming.

Karrim

Associate Analyst at Infosys

Helping everyone unlock new opportunities

Jump start your career with a free Google Career Certificate and become job-ready

Leave your details to get started

Let’s make your vision a reality!

Get in touch

Whether you’re curious about what we do or what we offer – we’d  be happy to answer all your questions