Buy Now AED 170.99 + VAT

Monthly Subscription Starting at AED 99 + VAT

Prepare Data for Exploration
  • Level Foundation
  • المدة 26 ساعات hours
  • الطبع بواسطة Google
  • Offered by

عن

This is the third course in the Google Data Analytics Certificate. These courses will equip you with the skills needed to apply to introductory-level data analyst jobs. As you continue to build on your understanding of the topics from the first two courses, you'll also be introduced to new topics that will help you gain practical data analytics skills. You'll learn how to use tools like spreadsheets and SQL to extract and make use of the right data for your objectives and how to organize and protect your data. Current Google data analysts will continue to instruct and provide you with hands-on ways to accomplish common data analyst tasks with the best tools and resources. Learners who complete this certificate program will be equipped to apply for introductory-level jobs as data analysts. No previous experience is necessary. By the end of this course, you will: - Find out how analysts decide which data to collect for analysis. - Learn about structured and unstructured data, data types, and data formats. - Discover how to identify different types of bias in data to help ensure data credibility. - Explore how analysts use spreadsheets and SQL with databases and data sets. - Examine open data and the relationship between and importance of data ethics and data privacy. - Gain an understanding of how to access databases and extract, filter, and sort the data they contain. - Learn the best practices for organizing data and keeping it secure.

الوحدات

Data exploration

    • 2 Videos
    • 2 Readings
    • 1 Plugin
Show info about module content

2 Videos

  • Introduction to data exploration
  • Hallie: Fascinating data insights

2 Readings

  • Course 3 overview: Set your expectations
  • Helpful resources and tips

Collect data

    • 2 Videos
    • 1 Readings
    • 1 Quiz
Show info about module content

2 Videos

  • Data collection in our world
  • Determine what data to collect

1 Readings

  • Select the right data

1 Quiz

  • Test your knowledge on collecting data

Differentiate data formats and structures

    • 2 Videos
    • 3 Readings
    • 2 Quiz
    • 1 Plugin
Show info about module content

2 Videos

  • Discover data formats
  • Continue exploring structured data

3 Readings

  • Data formats in practice
  • The effects of different structures
  • Data modeling levels and techniques

2 Quiz

  • Optional Self-Reflection: Unstructured data
  • Test your knowledge on data formats and structures

Explore data types, fields, and values

    • 3 Videos
    • 3 Readings
    • 1 Quiz
    • 1 Assignment
Show info about module content

1 Assignment

  • Test your knowledge on data types, fields, and values

3 Videos

  • Know the type of data you're working with
  • Data table components
  • Meet wide and long data

3 Readings

  • Use Boolean logic
  • Step-by-Step: Meet wide and long data
  • Transforming data

1 Quiz

  • Hands-On Activity: Introduction to Kaggle

Module 1 challenge

    • 1 Readings
    • 1 Quiz
Show info about module content

1 Readings

  • Glossary terms from module 1

1 Quiz

  • Module 1 challenge

Unbiased and objective data

    • 4 Videos
    • 1 Quiz
Show info about module content

4 Videos

  • Introduction to bias, credibility, privacy, and ethics
  • Bias: From questions to conclusions
  • Biased and unbiased data
  • Understand bias in data

1 Quiz

  • Test your knowledge on unbiased and objective data

Achieve data credibility

    • 2 Videos
    • 1 Assignment
Show info about module content

1 Assignment

  • Test your knowledge on data credibility

2 Videos

  • Identify good data sources
  • What is "bad" data?

Data ethics and privacy

    • 4 Videos
    • 1 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Test your knowledge on data ethics and privacy

4 Videos

  • Essential data ethics
  • Optional refresher: Alex and the importance of data ethics
  • Prioritize data privacy
  • Andrew: The ethical use of data

1 Readings

  • Data anonymization

Understand open data

    • 2 Videos
    • 2 Readings
    • 2 Quiz
Show info about module content

2 Videos

  • Features of open data
  • Andrew: Steps for ethical data use

2 Readings

  • The open data debate
  • Resources for open data

2 Quiz

  • Hands-On Activity: Kaggle datasets
  • Test your knowledge on open data

Module 2 challenge

    • 1 Readings
    • 1 Quiz
Show info about module content

1 Readings

  • Glossary terms from module 2

1 Quiz

  • Module 2 challenge

Work with databases

    • 2 Videos
    • 2 Readings
    • 1 Quiz
Show info about module content

2 Videos

  • All about databases
  • Database features and components

2 Readings

  • Maximize databases in data analytics
  • Inspect a dataset: A guided, hands-on tour

1 Quiz

  • Test your knowledge on working with databases

Manage data with metadata

    • 3 Videos
    • 2 Readings
    • 1 Assignment
Show info about module content

1 Assignment

  • Test your knowledge on metadata

3 Videos

  • Demystify metadata
  • Manage data with metadata
  • Megan: Fun with metadata

2 Readings

  • Metadata is as important as the data itself
  • Metadata and metadata repositories

Access different data sources

    • 2 Videos
    • 4 Readings
    • 1 Quiz
Show info about module content

2 Videos

  • So many places to find data
  • Import data from spreadsheets and databases

4 Readings

  • Working with .csv files
  • Step-by-Step: Import data from spreadsheets and databases
  • Import data dynamically
  • Explore public datasets

1 Quiz

  • Test your knowledge on accessing data sources

Sort and filter data

    • 1 Videos
    • 3 Quiz
Show info about module content

1 Videos

  • Sort and filter to focus on relevant data

3 Quiz

  • Hands-On Activity: Clean data in spreadsheets with sorting and filtering
  • Self-Reflection: Compare databases and spreadsheets
  • Test your knowledge on sorting and filtering

Large datasets in SQL

    • 2 Videos
    • 4 Readings
    • 5 Quiz
Show info about module content

2 Videos

  • Get to know BigQuery, including sandbox and billing options
  • BigQuery in action

4 Readings

  • Set up your BigQuery account
  • Get started with BigQuery
  • Step-by-Step: BigQuery in action
  • In-depth guide: SQL best practices

5 Quiz

  • Hands-On Activity: Introduction to BigQuery
  • Hands-On Activity: Create a custom table in BigQuery
  • Hands-On Activity: Choose the right tool for the job
  • Hands-On Activity: More practice with SQL
  • Test your knowledge on using SQL with large datasets

Module 3 challenge

    • 1 Readings
    • 1 Quiz
Show info about module content

1 Readings

  • Glossary terms from module 3

1 Quiz

  • Module 3 challenge

Bring data to order

    • 2 Videos
    • 1 Readings
    • 1 Plugin
    • 1 Assignment
Show info about module content

1 Assignment

  • Test your knowledge on bringing data to order

2 Videos

  • Feel confident in your data
  • Let's get organized

1 Readings

  • File organization guidelines

Secure data

    • 1 Videos
    • 1 Readings
    • 2 Quiz
Show info about module content

1 Videos

  • Security features in spreadsheets

1 Readings

  • Balance security and analytics

2 Quiz

  • Self-Reflection: Protect your resources
  • Test your knowledge on securing data

Module 4 challenge

    • 1 Readings
    • 1 Quiz
Show info about module content

1 Readings

  • Glossary terms from module 4

1 Quiz

  • Module 4 challenge

Create or enhance your online presence

    • 3 Videos
    • 2 Readings
    • 1 Quiz
Show info about module content

3 Videos

  • Manage your presence as a data analyst
  • Why an online presence is important
  • Tips for enhancing your online presence

2 Readings

  • Get started with LinkedIn
  • Build connections on LinkedIn

1 Quiz

  • Self-Reflection: Add Kaggle to your online presence

Build a data analytics network

    • 3 Videos
    • 1 Readings
Show info about module content

3 Videos

  • Networking know-how
  • Benefits of mentorship
  • Rachel: Mentors are key

1 Readings

  • Develop a network

Course wrap-up

    • 1 Videos
    • 3 Readings
Show info about module content

1 Videos

  • Congratulations! Course wrap-up

3 Readings

  • Reflect and connect with peers
  • Course 3 glossary
  • Coming up next...

Auto Summary

"Prepare Data for Exploration" is the third course in the Google Data Analytics Certificate, focusing on practical data analytics skills within the Data Science & AI domain. Taught by current Google data analysts, this foundational course covers tools like spreadsheets and SQL to extract, organize, and protect data. Over 1560 minutes, learners will explore data collection, structured and unstructured data, bias identification, data ethics, and privacy. Ideal for beginners, this Coursera offering prepares you for entry-level data analyst roles with a Starter subscription.

Google Career Certificates
Instructor

Google Career Certificates