Google Data Analytics
Course 1
Foundations: Data, Data, Everywhere
Learn
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.
Skills
Spreadsheet
Data Integrity
Sample Size Determination SQL
Data Cleansing
Course 2
Ask Questions to Make Data-Driven Decisions
Learn
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.
Skills
Data Analysis
Creating Case Studies
Data Visualization
Data Cleansing
Developing a Portofolio
Course 3
Prepare Data for Exploration
Learn
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.
Skills
Decision-Making
Spreadsheet
Data Analysis
Problem Solving
Questioning
Course 4
Process Data from Dirty to Clean
Learn
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.
Skills
Data Analysis
R Markdown
Data Visualization
R Programing
Rstudio
Correlation One
Week 1
Learn
Data Literacy
Skills
Intro to Excel
Week 2
Learn
Quantifying a Business Problem
Skills
Interpreting Tables and Charts