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

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

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

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

Data Quality Check, Profiling and Debugging

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

О курсе

Develop strong, industry-relevant skills in ensuring data accuracy, consistency, and reliability through this comprehensive course in Data Quality Check, Profiling, and Debugging. You’ll learn how to analyze and debug SQL queries, apply data standardization techniques, identify and remove duplicates, handle missing values, and perform critical data profiling tasks to understand the structure and health of your datasets. You will also explore validation techniques that ensure reports and pipelines meet business requirements, and practice diagnosing common data quality issues through routine checks and targeted profiling queries. This course brings together expertise from IBM, Google, Microsoft, and Unilever, giving you multiple perspectives on data quality management across spreadsheets, SQL, Python, and Power BI. You’ll progress from foundational SQL debugging and spreadsheet-based cleaning to programmatic data manipulation, ETL optimization, and advanced profiling in modern BI tools. Each module blends conceptual clarity with hands-on exercises to help you confidently clean, validate, and troubleshoot data in real-world analytics and reporting scenarios. Ideal for aspiring data analysts, data engineers, and professionals seeking to strengthen their data quality and debugging skills across diverse tools and environments.

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

SQLData TransformationSpreadsheet SoftwarePower BIBusiness IntelligenceData IntegrityData CleansingData ValidationData ManipulationMicrosoft ExcelData ManagementExtract, Transform, LoadData QualityExploratory Data AnalysisDebuggingData Analysis

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

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

01Start Here: Get Oriented and Check Your Skills2 материалов
Start Here: How This Skill-Based Course WorksЧтениеSkill Diagnostic: Find Your Recommended Starting PointЗадание
02Intermediate SQL5 материалов

Functions, Multiple Tables, and Sub-queries

Sub-Queries and Nested SelectsВидео

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

Professionals from the Industry

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

Data Quality Check, Profiling and Debugging
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 7.8 ч

11 модулей

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

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

Часть программы вашего университета
Working with Multiple TablesВидео
(Optional) Db2 Lab: Sub-queries and Nested SELECTs PLUGIN
(Optional) Db2 Lab: Working with Multiple Tables  PLUGIN
Debugging Data Issues in SQL ReportsЧтение
03Explore raw data4 материалов

"Discovering" is the beginning of an investigation

Reference guide: Pandas methods for the discovery of a datasetЧтениеEDA using basic data functions with PythonВидео

Understand data format

Discover what is missing from your datasetВидеоAnnotated follow-along resource: EDA using basic functions with PythonЛабораторная
04Clean your data2 материалов

The challenge of missing or duplicate data

Methods for handling missing data ВидеоAnnotated follow-along guide: Work with missing data in a Python notebookЛабораторная
05Cleaning & Wrangling Data Using Spreadsheets4 материалов

Basics of Data Quality and Privacy

Importing File DataВидео

Cleaning Data

Dealing with Inconsistencies in DataВидеоMore Excel Features for Cleaning DataВидеоStandardizing Inconsistent Data in ExcelЧтение
06Progamming languages: Python and SQL3 материалов

Using Python for data analytics

Use Python to prepare and format dataВидео

SQL: Managing large amounts of data

Test query against sourcesВидеоFilter out "noise" from available informationВидео
07Cleaning & Wrangling Data Using Spreadsheets4 материалов

Basics of Data Quality and Privacy

Introduction to Data QualityВидео

Cleaning Data

Removing Duplicated or Inaccurate Data and Empty RowsВидеоViewpoints: Issues with Data QualityВидеоHandling Missing Values in ExcelЧтение
08Optimize ETL processes5 материалов

Data schema validation

Schema-validation checklistЧтениеSample data dictionary and data lineageЧтениеCheck your schemaВидеоConformity from source to destinationВидео

Optimizing pipelines and ETL processes

Monitor data quality with SQLЧтение
09Analyze, validate, and interpret the data4 материалов

Validate the data

How to perform data validationВидеоSteps to take if errors existВидеоSolving common challenges of data validationЧтениеPreparing Data for Executive ReportingDIALOGUE
10Advanced ETL in PowerBI3 материалов

Data Profiling in Power BI

Introduction to data profilingВидеоProfiling Data in Power BIВидеоUsing the Data Profiling ToolsЧтение
11Assessments2 материалов

Lesson

Learner Expectations for Skill AssessmentЧтениеSkill AssessmentЗадание