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

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

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

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

Data Quality Auditing and Profiling

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

О курсе

Learn how to evaluate, validate, and monitor data quality across multiple systems in this comprehensive course within the Data Engineering Skill Path. You will develop essential competencies, including executing predefined quality checks, profiling datasets using descriptive statistics, identifying common data quality issues, reconciling data across systems, and validating warehouse data for completeness and accuracy. Through hands-on practice using Google ETL frameworks, Meta’s statistical methods, and IBM’s Python and warehouse tools, you will gain the skills needed to ensure trustworthy, reliable datasets for downstream analytics. This course combines expertise from Google, Meta, and IBM, offering multiple perspectives on data quality management across pipelines, statistical workflows, and enterprise data warehouses. You will progress from detecting issues in ETL processes, to profiling and summarizing datasets, to programmatically auditing data with Python, and finally to applying structural and business-rule validations in a warehouse environment. The curriculum balances conceptual understanding with practical exercises, preparing you to confidently assess and improve data quality throughout the data lifecycle. Perfect for aspiring data engineers, data analysts, and learners seeking strong foundational skills in data auditing, profiling, and validation across modern data environments.

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

Statistical MethodsSnowflake SchemaData ArchitectureData AccessData WarehousingData CleansingDescriptive StatisticsBayesian StatisticsData QualityQuality AssuranceData AnalysisSQLData PipelinesStar SchemaStatisticsExtract, Transform, LoadDatabase DesignData IntegrityData Validation

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

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

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

Optimizing pipelines and ETL processes

The importance of quality testingВидео

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

Professionals from the Industry

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

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

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 18.3 ч

6 модулей

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

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

Часть программы вашего университета
Seven elements of quality testingЧтение
Validate: Data quality and integrityPLUGIN
Monitor data quality with SQLЧтение
Mana: Quality data is useful dataВидео
Test your knowledge: Optimize pipelines and ETL processesЗадание

Data schema validation

Conformity from source to destinationВидеоSample data dictionary and data lineageЧтениеCheck your schemaВидеоSchema-validation checklistЧтениеActivity: Evaluate a schema using a validation checklist ЗаданиеActivity Exemplar: Evaluate a schema using a validation checklistЧтениеTest your knowledge: Data schema validationЗадание

Business rules and performance testing

Verify business rulesВидеоBusiness rulesЧтениеDatabase performance testing in an ETL contextЧтениеEvaluate: Performance test your data pipelinePLUGINDefend against known issuesЧтениеBurak: Evolving technologyВидеоCase study: FeatureBase, Part 2: Alternative solutions to pipeline systemsЧтениеTest your knowledge: Business rules and performance testing Задание

Review: Optimize ETL processes

Wrap-upВидеоGlossaryЧтение

[Optional] Review Google Data Analytics

[Optional] Review Google Data Analytics Certificate content about data integrityВидео[Optional] Review Google Data Analytics Certificate content about metadataВидео
03Descriptive Statistics22 материалов

Measures of Central Tendency

Introduction to Statistics FoundationsВидеоCapstone IntroductionВидеоIntroduction: Measures of Central TendencyВидеоUsing Measures of Central Tendency to Find the MiddleВидеоWhen to Use Different Measures of Central TendencyВидеоFinding the Middle with SpreadsheetsВидеоMeasures of Central Tendency ReviewЧтениеPractice Quiz: Measures of Central TendencyЗадание

Measures of Dispersion

Introduction: Measures of SpreadВидеоVariance and Range in Data AnalyticsВидеоStandard Deviation in Data AnalyticsВидеоUsing Z-Scores to Judge a ValueВидеоStandard Deviation in SpreadsheetsВидеоMeasures of Spread ReviewЧтение

Frequency Tables

Introduction: Frequency TablesВидеоFrequency Tables in Marketing AnalyticsВидеоHow to Use Contingency TablesВидеоConditional Probability: Bayesian StatisticsВидеоUnderstanding Scatter Plots and CorrelationВидеоFrequency, Contingency, and Scatterplots ReviewЧтение
04Accessing Databases using Python17 материалов

Accessing databases using Python

How to Access Databases Using PythonВидеоWriting code using DB-APIВидеоHands-on Lab: Creating tables, inserting and querying DataВнешний инструментAccessing Databases with SQL MagicВидеоHands-on Tutorial: Accessing Databases with SQL magicВнешний инструментAnalyzing data with PythonВидеоHands-on Lab: Analyzing a Real-World Data SetВнешний инструментSummary: Accessing databases using PythonЧтениеPractice Quiz: Accessing Databases using PythonЗаданиеSQL Cheat Sheet: Accessing Databases using PythonPLUGIN

[Optional] Using IBM Db2

[Optional] Hands-on Labs Using IBM Db2ЧтениеConnecting to a database using ibm_db APIВидео(Optional) Db2 Lab: Connecting to a database instanceВнешний инструментCreating tables, loading data and querying dataВидео(Optional) Db2 Lab: Creating tables, inserting and querying DataВнешний инструмент(Optional) Db2 Lab: Tutorial, Accessing Databases with SQL magicВнешний инструмент
05Designing, Modeling, and Implementing Data Warehouses17 материалов

Designing, Modeling and Implementing Data Warehouses

Overview of Data Warehouse Architectures ВидеоCubes, Rollups, and Materialized Views and TablesВидеоGrouping Sets in SQLЧтениеFacts and Dimensional ModelingВидеоHands-on Lab: Working with Facts and Dimension TablesВнешний инструментData Modeling using Star and Snowflake SchemasВидеоUnderstanding Slowly Changing Dimensions (SCD)ЧтениеData Warehousing with Star and Snowflake schemasЧтениеStaging Areas for Data WarehousesВидеоHands-on Lab: Setting up a Staging AreaВнешний инструментVerify Data QualityВидеоHands-on Lab: Verifying Data Quality for a Data WarehouseВнешний инструментPopulating a Data WarehouseВидеоHands-on Lab: Populating a Data Warehouse using PostgreSQLВнешний инструментQuerying the DataВидеоHands-On Lab: Querying the Data Warehouse using PostgreSQL (Cubes, Rollups, Grouping Sets and Materialized Views)Внешний инструментPractice Quiz: Designing, Modeling and Implementing Data WarehousesЗадание
06Skill Assessment – Data Quality Auditing and Profiling2 материалов

Lesson

Learner Expectations for Skill AssessmentЧтениеSkill AssessmentЗадание
Practice Quiz: Measures of SpreadЗадание
Capstone Module 1: Getting to Know the DataЗадание
(Optional) Db2 Lab: Analyzing a real World Data SetВнешний инструмент