Coursera Plus Annual is 40% Off — Ends July 13.

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Google

Prepare Data for Exploration

Google via Google Skills

Go to class Write review
DataCamp Ad

PowerBI Data Analyst - Create visualizations and dashboards from scratch

Learn More → Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One plan covers every Professional Certificate on Coursera.
Unlock All Certificates
Learn how to effectively use spreadsheets and SQL for data extraction, organization, and protection. Get practical tips from data analysts at Google who provide hands-on ways to accomplish common tasks with industry-standard tools and helpful resources. This is the third course in the Google Data Analytics Certificate, a series designed to prepare you for an introductory-level data analyst role.

Syllabus

  • Data types and structures
    • Introduction to data exploration
    • Course 3 overview
    • Hallie: Fascinating data insights
    • Data collection in our world
    • Determine what data to collect
    • Select the right data
    • Practice Quiz: Test your knowledge on collecting data
    • Discover data formats
    • Data formats in practice
    • Practice Quiz: Optional Self-Reflection: Unstructured data
    • Continue exploring structured data
    • The effects of different structures
    • Data modeling levels and techniques
    • Practice Quiz: Test your knowledge on data formats and structures
    • Know the type of data you're working with
    • Use Boolean logic
    • Data table components
    • Step-by-Step: Meet wide and long data
    • Meet wide and long data
    • Transforming data
    • Practice Quiz: Hands-On Activity: Introduction to Kaggle
    • Practice Quiz: Test your knowledge on data types, fields, and values
    • Glossary terms from module 1
    • Graded Quiz: Module 1 challenge
  • Data responsibility
    • Introduction to bias, credibility, privacy, and ethics
    • Bias: From questions to conclusions
    • Biased and unbiased data
    • Understand bias in data
    • Practice Quiz: Test your knowledge on unbiased and objective data
    • Identify good data sources
    • What is "bad" data?
    • Practice Quiz: Test your knowledge on data credibility
    • Essential data ethics
    • Optional refresher: Alex and the importance of data ethics
    • Prioritize data privacy
    • Data anonymization
    • Andrew: The ethical use of data
    • Practice Quiz: Test your knowledge on data ethics and privacy
    • Features of open data
    • The open data debate
    • Andrew: Steps for ethical data use
    • Resources for open data
    • Practice Quiz: Hands-On Activity: Kaggle datasets
    • Practice Quiz: Test your knowledge on open data
    • Glossary terms from module 2
    • Graded Quiz: Module 2 challenge
  • Database essentials
    • All about databases
    • Database features and components
    • Maximize databases in data analytics
    • Inspect a dataset: A guided, hands-on tour
    • Practice Quiz: Test your knowledge on working with databases
    • Demystify metadata
    • Metadata is as important as the data itself
    • Metadata and metadata repositories
    • Manage data with metadata
    • Megan: Fun with metadata
    • Practice Quiz: Test your knowledge on metadata
    • So many places to find data
    • Working with .csv files
    • Step-by-Step: Import data from spreadsheets and databases
    • Import data from spreadsheets and databases
    • Import data dynamically
    • Explore public datasets
    • Practice Quiz: Test your knowledge on accessing data sources
    • Sort and filter to focus on relevant data
    • Practice Quiz: Hands-On Activity: Clean data in spreadsheets with sorting and filtering
    • Practice Quiz: Self-Reflection: Compare databases and spreadsheets
    • Practice Quiz: Test your knowledge on sorting and filtering
    • Get to know BigQuery, including sandbox and billing options
    • Set up your BigQuery account
    • Get started with BigQuery
    • Step-by-Step: BigQuery in action
    • BigQuery in action
    • Practice Quiz: Hands-On Activity: Introduction to BigQuery
    • In-depth guide: SQL best practices
    • Practice Quiz: Hands-On Activity: Create a custom table in BigQuery
    • Practice Quiz: Hands-On Activity: Choose the right tool for the job
    • Practice Quiz: Hands-On Activity: More practice with SQL
    • Practice Quiz: Test your knowledge on using SQL with large datasets
    • Glossary terms from module 3
    • Graded Quiz: Module 3 challenge
  • Organize and protect data
    • Feel confident in your data
    • Let's get organized
    • File organization guidelines
    • Practice Quiz: Test your knowledge on bringing data to order
    • Security features in spreadsheets
    • Balance security and analytics
    • Practice Quiz: Self-Reflection: Protect your resources
    • Practice Quiz: Test your knowledge on securing data
    • Glossary terms from module 4
    • Graded Quiz: Module 4 challenge
  • Engage in the data community
    • Practice Quiz: Self-Reflection: Add Kaggle to your online presence
    • Develop a network
    • Rachel: Mentors are key
    • Course 3 glossary
    • Congratulations! Course wrap-up
    • Coming up next...
    • Course 3 resources and citations

Tags

Reviews

Start your review of Prepare Data for Exploration

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.