Google Data Analytics

Beginner Level

Module 1 — Foundations of Data Analytics

1. Introduction to Data Analytics
2. What Does a Data Analyst Do?
3. The Data Analysis Process
4. Types of Data
5. Structured and Unstructured Data
6. Data-Driven Decision Making
7. Asking Effective Business Questions
8. Understanding Stakeholders
9. Data Ethics and Privacy
10. Career Paths in Data Analytics

Module 2 — Spreadsheets for Data Analysis

1. Spreadsheet Fundamentals
2. Rows, Columns and Data Types
3. Data Entry and Organization
4. Sorting and Filtering
5. Basic Spreadsheet Formulas
6. Functions for Analysis
7. Conditional Logic
8. Data Validation
9. Pivot Tables
10. Spreadsheet Analysis Project

Module 3 — Data Cleaning

1. Introduction to Data Cleaning
2. Identifying Data Quality Problems
3. Missing Values
4. Duplicate Records
5. Incorrect Data Types
6. Standardizing Data
7. Handling Outliers
8. Text and Date Cleaning
9. Data Validation
10. Data Cleaning Project

Module 4 — SQL Fundamentals

1. Introduction to Databases
2. Tables, Rows and Columns
3. Introduction to SQL
4. SELECT Statements
5. WHERE Conditions
6. Sorting Query Results
7. Filtering Data
8. Aggregate Functions
9. GROUP BY and HAVING
10. Beginner SQL Project

Module 5 — Data Visualization

1. Introduction to Data Visualization
2. Choosing the Right Chart
3. Bar Charts
4. Line Charts
5. Pie and Donut Charts
6. Scatter Plots
7. Dashboards
8. Visualization Mistakes
9. Communicating Insights
10. Beginner Analytics Portfolio Project