Follow Me

Data Analytics Certificate

Data Analytics Certificate
Data Analytics Certificate. Understand how to clean and organize data for analysis, calculations using spreadsheets, SQL and R programming.

Table of Contents

About the 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.

Course Series

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.

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.

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.

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.

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.

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.

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.

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.

Skills

Analysis
Analytical Skills
Analytics
Artificial Intelligence
Business Analysis
Business Analytics
Case Studies
Dashboard
Data Analysis
Data Cleansing
Data Collection
Data Compilation
Data Ethics
Data Import/Export
Data Integration
Data Literacy
Data Manipulation
Data Presentation
Data Processing
Data Sharing
Data Storytelling
Data Transformation
Data Validation
Data Visualization
Data Visualization Software

Data-Driven Decision-Making
Excel Formulas
Ggplot2
Google Sheets
Interviewing Skills
LinkedIn
Package and Software Management
Pivot Tables And Charts
Portfolio Management
Presentations
Problem Solving
Quantitative Research
R Programming
Rmarkdown
Smart Goals
Spreadsheet Software
SQL
Stakeholder Engagement
Stakeholder Management
Statistical Programming
Tableau Software
Tidyverse (R Package)
User Feedback
Web Content Accessibility Guidelines

My Data Analytics Experience

My Certification

Coursera

Back to top