Google Data Analytics Certificate
Immersive understanding of the practices and processes used by a junior or associate data analyst in their day-to-day job..
Understand how to clean and organize data for analysis, and complete analysis and calculations using spreadsheets, SQL and R programming.
Learn key analytical skills (data cleaning, analysis, & visualization) and tools (spreadsheets, SQL, R programming, Tableau).
Learn how to visualize and present data findings in dashboards, presentations and commonly used visualization platforms.
8 Course Series, Learning and Skills Achieved
View My Professional Certificate
Course 1 - Foundations: Data, Data, Everywhere
Learning
Define and explain key concepts involved in data analytics including data, data analysis, and data ecosystems.
Conduct an analytical thinking self assessment giving specific examples of the application of analytical thinking.
Discuss the role of spreadsheets, query languages, and data visualization tools in data analytics.
Describe the role of a data analyst with specific reference to jobs.
View Course Certificate
Skills
Analytical Skills
Analytics
Business Analytics
Data Analysis
Data Cleansing
Data Collection
Data Ethics
Data Processing
Data Sharing
Data Visualization
Data Visualization Software
Data-Driven Decision-Making
Google Sheets
Spreadsheet Software
SQL
Tableau Software
Course 2 - Ask Questions to Make Data-Driven Decisions
Learning
Explain how the problem-solving road map applies to typical analysis scenarios.
Discuss the use of data in the decision-making process.
Demonstrate the use of spreadsheets to complete basic tasks of the data analyst including entering and organizing data.
Describe the key ideas associated with structured thinking.
View Course Certificate
Skills
Analytical Skills
Business Analysis
Dashboard
Data Analysis
Data Presentation
Data-Driven Decision-Making
Problem Solving
Quantitative Research
Smart Goals
Spreadsheet Software
Stakeholder Management
Course 3 - Prepare Data for Exploration
Learning
Explain what factors to consider when making decisions about data collection.
Discuss the difference between biased and unbiased data.
Describe databases with references to their functions and components.
Describe best practices for organizing data.
View Course Certificate
Skills
Data Analysis
Data Collection
Data Ethics
Data Import/Export
Data Literacy
Data Management
Data Quality
Data Security
Data Storage
Databases
Google Sheets
Metadata Management
SQL
Unstructured Data
Course 4 - Process Data from Dirty to Clean
Learning
Define different types of data integrity and identify risks to data integrity.
Apply basic SQL functions to clean string variables in a database.
Develop basic SQL queries for use on databases.
Describe the process of verifying data cleaning results.
View Course Certificate
Skills
Data Analysis
Data Cleansing
Data Integrity
Data Quality
Data Transformation
Data Validation
Sample Size Determination
Sampling (Statistics)
Spreadsheet Software
SQL
Course 5 - Analyze Data to Answer Questions
Learning
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.
View Course Certificate
Skills
Analytics
Data Analysis
Data Compilation
Data Integration
Data Manipulation
Data Transformation
Data Validation
Excel Formulas
Pivot Tables And Charts
Spreadsheet Software
SQL
User Feedback
Course 6 - Share Data Through the Art of Visualization
Learning
Describe the use of data visualizations to talk about data and the results of data analysis.
Identify Tableau as a data visualization tool and understand its uses.
Explain what data driven stories are including reference to their importance and their attributes.
Explain principles and practices associated with effective presentations.
View Course Certificate
Skills
Dashboard
Data Analysis
Data Literacy
Data Presentation
Data Storytelling
Data Visualization
Data Visualization Software
Presentations
Stakeholder Engagement
Tableau Software
Web Content Accessibility Guidelines
Course 7 - Data Analysis with R Programming
Learning
Describe the R programming language and its programming environment.
Explain the fundamental concepts associated with programming in R including functions, variables, data types, pipes, and vectors.
Describe the options for generating visualizations in R.
Demonstrate an understanding of the basic formatting in R Markdown to create structure and emphasize content.
View Course Certificate
Skills
Data Analysis
Data Cleansing
Data Import/Export
Data Manipulation
Data Visualization
Data Visualization Software
Ggplot2
Package and Software Management
R Programming
Rmarkdown
Statistical Programming
Tidyverse (R Package)
Course 8 - Google Data Analytics Capstone: Complete a Case Study
Learning
Identify the key features and attributes of a completed case study.
Apply the practices and procedures associated with the data analysis process to a given set of data.
Discuss the use of case studies/portfolios when communicating with recruiters and potential employers.
Gain a competitive edge by learning AI skills from Google experts.
View Course Certificate
Skills
Analysis
Analytical Skills
Artificial Intelligence
Business Analytics
Case Studies
Data Analysis
Data Cleansing
Data Processing
Data Storytelling
Data Visualization
Data Visualization Software
Google Sheets
Interviewing Skills
LinkedIn
Portfolio Management
Presentations
Spreadsheet Software
