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

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

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

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

Data Preparation & Infrastructure

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

О курсе

Build the technical foundation required for modern marketing analytics workflows. In this course, you’ll learn how to prepare, clean, validate, and structure marketing data so it can be trusted for reporting and decision-making. You’ll work with campaign exports, CRM records, web analytics data, and marketing performance datasets while learning how to identify inconsistencies, normalize UTM conventions, and remove duplicate or incomplete records. You’ll also learn how to use SQL to extract and combine marketing-relevant data from multiple sources, enabling you to create campaign-level metrics and performance summaries. In addition, you’ll evaluate data quality using profiling techniques that help identify gaps, anomalies, and reporting risks before they affect business decisions. By the end of the course, you’ll be able to create repeatable data-cleaning workflows, validate marketing datasets across platforms, and prepare reliable datasets for dashboarding, analysis, and optimization projects.

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

Data CleansingData QualityData ValidationSQLMarketing OperationsData SynthesisData PreprocessingData WranglingData TransformationSoftware Technical ReviewData AnalysisMarketing AnalyticsData ModelingGoogle AnalyticsData MappingCross-Channel MarketingCode ReviewData IntegrityData ManipulationVerification And Validation

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

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

01Data Cleaning: Normalize Marketing Datasets7 материалов
The Cost of Dirty DataВидеоMarketing Data Cleaning FundamentalsВидеоUTM Normalization StandardsЧтениеStep-by-Step Cleaning in ActionВидео

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

Professionals from the Industry

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

Data Preparation & Infrastructure
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 7.4 ч

8 модулей

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

Часть программы вашего университета
Hands-On Activity: Standardize UTM EntriesЗадание
Exemplar for Hands-On Activity: Standardize UTM EntriesЧтение
Knowledge Check: Cleaning RoutinesЗадание
02Data Cleaning: Reconcile Conversion Counts7 материалов
The Mystery of the Missing ConversionsDIALOGUECross-Platform Validation LogicВидеоBuilding a Validation ScriptЧтениеHands-On Activity: Cross-Check Conversion FiguresЗаданиеExemplar for Hands-On Activity: Cross-Check Conversion FiguresЧтениеKnowledge Check: Data ReconciliationЗаданиеQuiz: Data Cleaning BasicsЗадание
03SQL: Extract and Join Marketing Data6 материалов
SQL: The Marketing Analyst’s SuperpowerЧтениеJoining Marketing TablesВидеоBuilding the Master Campaign QueryВидеоHands-on Activity: Generate Campaign Performance MetricsЗаданиеExemplar for Hands-on Activity: Generate Campaign Performance MetricsЧтениеKnowledge Check: Marketing SQL JoinsЗадание
04SQL: Analyze and Optimize Queries7 материалов
When Queries CrawlDIALOGUECommon Marketing Aggregation PitfallsЧтениеOptimizing for Speed and AccuracyВидеоHands-on Activity: Optimize a Performance QueryЗаданиеExemplar for Hands-on Activity: Optimize a Performance QueryЧтениеKnowledge Check: Query OptimizationЗаданиеQuiz: Querying Marketing DataЗадание
05Profiling: Compute Quality Metrics7 материалов
Trust, But VerifyВидеоThe Three Pillars of Marketing Data QualityЧтениеProfiling with SQLВидеоProfiling with ExcelВидеоHands-On Activity: Assess Campaign Data HealthЗаданиеExemplar for Hands-On Activity: Assess Campaign Data HealthЧтениеKnowledge Check: Profiling MetricsЗадание
06Profiling: Evaluate and Remediate8 материалов
Prioritizing the FixDIALOGUEEstablishing Data BaselinesВидеоInterpreting Profiling Outputs to Prioritize RemediationЧтениеWriting a Remediation Plan from a Profiling ReportВидеоHands-On Activity: Prepare a Data Remediation PlanЗаданиеExemplar for Hands-On Activity: Prepare a Data Remediation PlanЧтениеKnowledge Check: Remediation StrategyЗаданиеQuiz: Data ProfilingЗадание
07GenAI Module: AI-Assisted Data Preparation6 материалов
Your AI Data AssistantDIALOGUEPrompting for SQL and ScriptsВидеоThe Limits of AI in Data OpsЧтениеDemo: Cleaning a Dataset with AIВидеоHands-on Activity: Prompting for Complex JoinsЗаданиеKnowledge Check: AI for Data PrepЗадание
08Project Module: Data Audit & Cleaning4 материалов
Why This Project MattersЧтениеProject RequirementsЧтениеProject InstructionsЧтениеProject: OmniRetail Data AuditЗадание