К содержимому
learnspaceYOUR NEXT CHAPTER
ПРОСТРАНСТВО ОБУЧЕНИЯ
ГлавнаяКаталог курсовМоё обучениеCoursera

Знания без границ

Учитесь у лучших университетов и компаний мира.

Открыть Coursera
Интеграция
Пространство университета
Моё пространствоСтраница курса
↵
ЯЛичный кабинетСтудент
© 2026 LearnSpaceКаждый день — возможность узнать больше.Помощь
Prepare Data for Exploration · LearnSpace
Назад в каталог
courseraАнализ данных

Prepare Data for Exploration

Курс от Google
Начальный≈ 18.7 чАнглийский
О курсеНавыкиПрограммаПреподаватели

О курсе

This is the third course in the Google Data Analytics Certificate. As you continue to build on your understanding of the topics from the first two courses, you’ll 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, learners will: - Find out how analysts decide what 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 within 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 best practices for organizing data and keeping it secure.

Навыки, которые вы освоите

Data SecuritySQLMetadata ManagementData EthicsFile ManagementData CollectionUnstructured DataRelational DatabasesDatabasesData QualityData SharingData AccessData LiteracyGoogle SheetsData ManipulationData Storage

Программа курса

5 модулей · 101 учебных материалов

01 Data types and structures26 материалов

Data exploration

Introduction to data explorationВидеоCourse 3 overviewЧтениеHallie: Fascinating data insights ВидеоHelpful resources and tipsЧтение

Collect data

Учитесь у экспертов

Google Career Certificates

Преподаватель курса

Prepare Data for Exploration
В каталоге вашей программы

Инвестируйте в себя

Новые знания — в удобное для вас время.

Начать на Coursera

Обучение откроется на Coursera
в новой вкладке

Обучение на Coursera

≈ 18.7 ч

5 модулей

Язык: Английский

Субтитры: Арабский, Французский, Украинский, Бразильский португальский, Корейский, Немецкий, Индонезийский, Турецкий, Испанский, Японский

Часть программы вашего университета
Data collection in our worldВидео
Determine what data to collectВидео
Select the right dataЧтение
Test your knowledge on collecting data Задание

Differentiate data formats and structures

Discover data formatsВидеоData formats in practiceЧтениеOptional Self-Reflection: Unstructured dataЗаданиеContinue exploring structured dataВидеоThe effects of different structuresЧтениеDifferentiate data typesPLUGINData modeling levels and techniquesЧтениеTest your knowledge on data formats and structuresЗадание

Explore data types, fields, and values

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ЧтениеHands-On Activity: Introduction to KaggleЗаданиеTest your knowledge on data types, fields, and values Задание

Module 1 challenge

Glossary terms from module 1ЧтениеModule 1 challengeЗадание
02Data responsibility22 материалов

Unbiased and objective data

Introduction to bias, credibility, privacy, and ethicsВидеоBias: From questions to conclusionsВидеоBiased and unbiased dataВидеоUnderstand bias in dataВидеоTest your knowledge on unbiased and objective data Задание

Achieve data credibility

Identify good data sourcesВидеоWhat is "bad" data?ВидеоTest your knowledge on data credibilityЗадание

Data ethics and privacy

Essential data ethicsВидеоOptional refresher: Alex and the importance of data ethicsВидеоPrioritize data privacyВидеоData anonymizationЧтениеAndrew: The ethical use of dataВидеоTest your knowledge on data ethics and privacy Задание

Understand open data

Features of open dataВидеоThe open data debateЧтениеAndrew: Steps for ethical data useВидеоResources for open dataЧтениеHands-On Activity: Kaggle datasetsЗаданиеTest your knowledge on open dataЗадание

Module 2 challenge

Glossary terms from module 2ЧтениеModule 2 challengeЗадание
03Database essentials35 материалов

Work with databases

All about databasesВидеоDatabase features and componentsВидеоMaximize databases in data analyticsЧтениеInspect a dataset: A guided, hands-on tourЧтениеTest your knowledge on working with databasesЗадание

Manage data with metadata

Demystify metadata ВидеоMetadata is as important as the data itselfЧтениеMetadata and metadata repositoriesЧтениеManage data with metadataВидеоMegan: Fun with metadataВидеоTest your knowledge on metadataЗадание

Access different data sources

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Чтение

Sort and filter data

Sort and filter to focus on relevant dataВидео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

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ВидеоHands-On Activity: Introduction to BigQueryЗадание

Module 3 challenge

Glossary terms from module 3ЧтениеModule 3 challengeЗадание
04Organize and protect data 11 материалов

Bring data to order

Feel confident in your dataВидеоLet's get organizedВидеоFile organization guidelinesЧтениеEffective file-naming and organization methodsPLUGINTest your knowledge on bringing data to orderЗадание

Secure data

Security features in spreadsheetsВидеоBalance security and analyticsЧтениеSelf-Reflection: Protect your resourcesЗаданиеTest your knowledge on securing dataЗадание

Module 4 challenge

Glossary terms from module 4ЧтениеModule 4 challengeЗадание
05Engage in the data community7 материалов

Build a data analytics network

Self-Reflection: Add Kaggle to your online presenceЗаданиеDevelop a networkЧтениеRachel: Mentors are keyВидео

Course wrap-up

Reflect and connect with peersЧтениеCourse 3 glossaryЧтениеCongratulations! Course wrap-upВидеоComing up next...Чтение
Test your knowledge on accessing data sourcesЗадание
In-depth guide: SQL best practicesЧтение
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Задание