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

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

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

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

Process Data from Dirty to Clean

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

О курсе

This is the fourth course in the Google Data Analytics Certificate. In this course, you’ll continue to build your understanding of data analytics and the concepts and tools that data analysts use in their work. You’ll learn how to check and clean your data using spreadsheets and SQL, as well as how to verify and report your data cleaning results. 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: - Check for data integrity. - Apply data cleaning techniques using spreadsheets. - Develop basic SQL queries for use on databases. - Use basic SQL functions to clean and transform data. - Verify the results of cleaning data. - Write an effective data cleaning report

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

Data CleansingSQLData IntegrityData TransformationData ManipulationData QualityData ValidationAnalyticsData ProcessingSampling (Statistics)Spreadsheet SoftwareData AnalysisSample Size Determination

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

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

01The importance of integrity24 материалов

Focus on integrity

Introduction to data integrityВидеоCourse 4 overviewЧтениеHelpful resources and tipsЧтение

Data integrity and analytics objectives

Why data integrity is importantВидео

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

Google Career Certificates

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

Process Data from Dirty to Clean
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 16.4 ч

6 модулей

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

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

Часть программы вашего университета
More about data integrity and complianceЧтение
Balance objectives with data integrityВидео
Well-aligned objectives and data Чтение
Test your knowledge on data integrity and analytics objectivesЗадание

Overcome the challenges of insufficient data

Deal with insufficient dataВидеоWhen you find an issue with your dataЧтениеThe importance of sample sizeВидеоCalculate sample sizeЧтениеSelf-Reflection: Pre-cleaning activitiesЗаданиеTest your knowledge on insufficient dataЗадание

Test your data

Using statistical powerВидеоWhen data isn't readily availableЧтениеDetermine the best sample size ВидеоSample size calculatorЧтениеTest your knowledge on testing your dataЗадание

Consider the margin of error

Evaluate data reliabilityВидеоAll about margin of errorЧтениеTest your knowledge on margin of errorЗадание

Module 1 challenge

Glossary terms from module 1ЧтениеModule 1 challengeЗадание
02Clean data for more accurate insights27 материалов

Data cleaning is a must

Clean it up!ВидеоWhy data cleaning is criticalВидеоAngie: I love cleaning dataВидеоWhat is dirty data?ЧтениеRecognize and remedy dirty dataВидеоPrinciples of data integrity PLUGINTest your knowledge on data cleaningЗадание

First steps toward clean data

Data-cleaning tools and techniquesВидеоClean data from multiple sourcesВидеоCommon data-cleaning pitfallsЧтениеHands-On Activity: Cleaning data with spreadsheetsЗаданиеTest your knowledge on the first steps toward clean dataЗадание

Continue cleaning data in spreadsheets

Step-by-Step guide: Data-cleaning features in spreadsheetsЧтениеData-cleaning features in spreadsheetsВидеоStep-by-Step: Optimize the data-cleaning process ЧтениеOptimize the data-cleaning processВидеоWorkflow automationЧтениеStep-by-Step: Different data perspectivesЧтение

Module 2 challenge

Glossary terms from module 2ЧтениеModule 2 challengeЗадание
03Data cleaning with SQL22 материалов

SQL for sparkling clean data

Use SQL to clean dataВидеоSally: For the love of SQLВидеоUnderstand SQL capabilitiesВидеоHow a junior data analyst uses SQLЧтениеSpreadsheets versus SQLВидеоSQL dialects and their usesЧтениеReview: Set up your BigQuery accountЧтениеReview: Get started with BigQueryЧтениеHands-On Activity: Processing time with SQLЗадание

Learn basic SQL queries

Optional: Upload the customer dataset to BigQueryЧтениеWidely used SQL queriesВидеоEvan: Having fun with SQL ВидеоClean string variables using SQLВидеоHands-On Activity: Clean data using SQLЗаданиеTest your knowledge on SQL queriesЗадание

Transforming data

Optional: Upload the store transactions dataset to BigQueryЧтениеAdvanced data-cleaning functions, part 1ВидеоAdvanced data-cleaning functions, part 2ВидеоData-cleaning with SQL functionsPLUGINSelf-Reflection: Challenges with SQLЗадание

Module 3 challenge

Glossary terms from module 3ЧтениеModule 3 challengeЗадание
04Verify and report on cleaning results 15 материалов

Manually cleaning data

Verify and report resultsВидеоConfirm data-cleaning meets business expectationsВидеоStep-by-Step: Verification of data cleaningЧтениеVerification of data cleaningВидеоData-cleaning verification checklistЧтениеTest your knowledge on manual data cleaningЗадание

Document the cleaning process

Capture cleaning changesВидеоEmbrace changelogsЧтениеSelf-Reflection: Creating a changelogЗаданиеWhy documentation is importantВидеоFeedback and cleaningВидеоAdvanced functions for speedy data cleaningЧтение

Module 4 challenge

Glossary terms from module 4ЧтениеModule 4 challengeЗадание
05Add data to your resume5 материалов

Key elements of a data professional's resume

Make your resume uniqueВидеоJoseph: Black and African American inclusion in the data industryВидеоThe importance of diversity on a data analytics teamЧтениеAdd technical skills to your resumeЧтениеWhere does your interest lie?Видео
06Course wrap-up 4 материалов

Course wrap-up

Reflect and connect with peersЧтениеCourse 4 glossaryЧтениеCongratulations! Course wrap-upВидеоComing up next ...Чтение
Different data perspectivesВидео
Step-by-Step: Even more data-cleaning techniquesЧтение
Even more data-cleaning techniquesВидео
Working with .csv filesЧтение
Hands-On Activity: Clean data with spreadsheet functionsЗадание
Develop your approach to cleaning dataЧтение
Test your knowledge on cleaning data in spreadsheetsЗадание
Test your knowledge on documenting the cleaning processЗадание