Home - sj50179/Google-Data-Analytics-Professional-Certificate GitHub Wiki

Welcome to my study note wiki for the Google Data Analytics Professional Certificate

My Certificate URL

1. Foundations: Data, Data, Everywhere

• Introducing data analytics
• Thinking analytically
• Exploring the wonderful world of data
• Setting up a data toolbox
• Discovering data career possibilities
• Course Challenge

2. Ask Questions to Make Data-Driven Decisions

• Asking effective questions
• Making data-driven decisions
• Learning spreadsheet basics
• Always remember the stakeholder
• Course challenge

3. Prepare Data for Exploration

• Data types and data structures
• Bias, credibility, privacy, ethics, and access
• Databases: Where data lives
• Organizing and protecting your data
• Course challenge

4. Process Data from Dirty to Clean

• The importance of integrity
• Sparkling-clean data
• Cleaning data with SQL
• Verify and report on your cleaning results
• Course challenge

5. Analyze Data to Answer Questions

• Organizing data to begin analysis
• Formatting and adjusting data
• Aggregating data for analysis
• Performing data calculations
• Course challenge
• (Bonus) Intermediate Guide to SQL

6. Share Data Through the Art of Visualization

• Visualizing data
• Creating data visualizations with Tableau
• Crafting data stories
• Developing presentations and slideshows
• Course challenge

7. Data Analysis with R Programming

• Programming and data analytics
• Programming using RStudio
• Working with data in R
• More about visualizations, aesthetics, and annotations
• Documentation and reports
• Course Challenge

8. Complete a Case Study

• Learn about capstone basics - Introduction to the capstone & Sample cases for data analysts
• Optional: Building your portfolio
• Optional: Using your portfolio

---

• Glossary