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

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

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

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

Building a Scripted ETL Pipeline

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

О курсе

Learn how to script, automate, and manage data pipelines through this comprehensive course in the Data Engineering Skill Path. You will develop critical competencies, including cleaning and transforming data using Python, combining datasets from multiple sources, performing scripted extraction and loading tasks, retrieving external data through APIs, and using database-native tools to carry out bulk ingestion into a cloud warehouse. Through hands-on practice with Python, Tableau, Microsoft tools, IBM API workflows, and Snowflake, you will learn to build reliable, repeatable ETL processes that move data from raw form to structured, analysis-ready outputs. This course combines expertise from Fractal Analytics, Tableau, Microsoft, IBM, and Snowflake, offering multiple perspectives on the ETL lifecycle. You will progress from foundational data wrangling to merge and join operations, scripting data processing tasks, collecting external data, and finally scaling ingestion using enterprise-grade cloud tooling. The curriculum balances conceptual understanding with practical exercises, preparing you to confidently script and manage ETL pipelines across diverse platforms. Perfect for aspiring data engineers and learners seeking strong, practical skills in automated data transformation and pipeline development.

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

Python ProgrammingData WarehousingData WranglingWeb ScrapingData IntegrationProgramming PrinciplesData ProcessingScriptingData CollectionData TransformationData PipelinesTableau SoftwareData PreprocessingData Import/ExportApplication Programming Interface (API)Extract, Transform, LoadPandas (Python Package)Data CleansingExploratory Data AnalysisData Manipulation

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

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

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

Getting started with a data set

Diving into CSV DataВидео

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

Professionals from the Industry

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

Building a Scripted ETL Pipeline
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 25.2 ч

7 модулей

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

Субтитры: Арабский, Французский, Узбекский, Украинский, Китайский (Китай), Греческий, Итальянский, Бразильский португальский, Вьетнамский, Нидерландский, Корейский, Немецкий, Пушту, Русский, Тайский, Индонезийский, Шведский, Турецкий, Азербайджанский, Испанский, Хинди, Японский, Казахский, Венгерский, Польский

Часть программы вашего университета
Data inspectionВидео
Finding missing data in the POS dataВидео
Deleting missing data and saving the cleaned data setВидео
Data cleaning with pythonЧтение
Lab data and problemВидео
Data cleaning & manipulation Лабораторная
DataFame essentialsЗадание
Resources - Datasets and Jupyter notebooks Чтение

DataFrame Fundamentals and Indexing

Basic data structures - lists and dictionariesВидеоBasic data structures - seriesВидеоCreating a data frame using lists, dictionaries and seriesВидеоPython statistics fundamentals ЧтениеSlicing with precisionВидеоChanging the indices and saving the new DataFrameВидеоDataFrame operationsЗадание

Exploring and Querying Columns

Navigating data insightsВидеоSelecting data that match certain criteriaВидеоSelecting data that match multiple criteriaВидеоExpert Talk - Understanding your dataВидеоData selection & filteringЗаданиеData slicing & manipulationsЛабораторная

Manipulation and Grouping of Data

What are the unique products in the POS data set?ВидеоFinding specific values in the dataВидеоHow much did we sell per category? ВидеоFinding totals and averages by brand and by categoryВидеоGrouping by multiple attributesВидеоDisplaying aggregated data in a pivot tableВидеоData manipulation & aggregationЗаданиеData aggregationsЛабораторная

Date Time Operations in Python

Expert talk - How insights and data analysis guide each otherВидеоWorking with datesВидеоHow much did we sell each month?ВидеоWhat is the monthly average of sales?ВидеоWere there specific dates when sales were high?ВидеоWorking with dates ЧтениеDate time operationsЗаданиеPractice Programming AssignmentЛабораторная

Putting Together Data from Multiple Sources

What if we have more than one dataset?ВидеоMerging some simple data setsВидеоMerging POS data with the online dataВидеоMerging & joining dataframesЗаданиеMerging the dataЛабораторнаяWalkthrough - How to approach a graded assignmentВидеоSummaryВидео
03Multiple Data Sources in Tableau Public28 материалов

Accessing Multiple Tables

Accessing Multiple TablesЧтениеJoins in TableauЧтениеJoinsВидеоTableau Data ModelЧтениеUnions in TableauЧтениеUnionsВидеоRelationships in TableauЧтениеRelationshipsВидеоPractice - Accessing Multiple TablesЗадание

Accessing Multiple Data Sources

Data SourcesЧтениеTableau Data SourcesЧтениеConnecting Data SourcesЧтениеCross-Database JoinsЧтениеCross-Database JoinsВидеоRecap: Cross-Database Join ExampleЧтениеData Blends

Live vs. Extracts

OptimizationЧтениеLive vs. ExtractЧтениеPractice - Live vs. ExtractЗаданиеRecapЧтение

Project

Project OverviewЧтение

Course Wrap Up

RecapЧтениеWant to Become a Business Intelligence Analyst?ЧтениеCongratulationsВидео
04Data processing and manipulation22 материалов

pandas: Your data manipulation powerhouse

Manipulating data with pandasВидеоpandas Dataframes: The basicsВидеоpandas indexing explainedЧтениеDemo: Loading and inspecting datasets in pandasВидеоExploring data transformationsВидеоpandas cheat sheetЧтениеDemo: Transforming data with pandasВидеоActivity: Loading and inspecting datasets in pandasЗаданиеpandas: Your data manipulation powerhouseЗадание

The hero of data analysis: Data cleaning

Exploratory data analysis (EDA)ВидеоThe importance of data cleaningВидеоEssential tactics for data manipulationЧтениеIdentifying and handling missing dataВидеоHandling duplicate valuesВидеоCommon causes of missing dataЧтение

Using pandas for cleaning and exploration

Data types in Python: Choosing the right fitВидеоpandas for essential analysis tasksЧтениеDemo: pandas for exploration and cleaningВидеоTaming messy data with pandasВидеоUsing pandas for cleaning and explorationЗадание
05APIs and Data Collection22 материалов

Simple APIs

Application Program InterfaceВидеоReading: Some Context on APIsPLUGINHands-On Lab: Introduction to APIВнешний инструментPractice Quiz: Simple APIs Задание

REST APIs, Web Scraping, and Working with Files

REST APIs & HTTP Requests - Part 1ВидеоREST APIs & HTTP Requests - Part 2ВидеоReading: Web Scraping and HTML BasicsPLUGINHands-on Lab: Access REST APIs & Request HTTPВнешний инструментHands-On Lab: API ExamplesВнешний инструмент(Optional) HTML for Web ScrapingВидео(Optional) Web Scraping ВидеоReading: Web Scraping - A Key Tool in Data SciencePLUGINReading: Web Scraping Tables using PandasPLUGINHands-on Lab: Web ScrapingВнешний инструментWorking with Different File Formats ВидеоHands-on Lab: Working with different file formatsВнешний инструмент Practice Quiz: REST APIs, Web Scraping, and Working with FilesЗаданиеPractice Project: GDP Data Extraction and ProcessingВнешний инструмент

Summary, Cheatsheet, and Glossary

Summary: APIs and Data CollectionЧтениеCheat Sheet: APIs and Data CollectionPLUGINPython Cheat Sheet: The BasicsЧтениеGlossary: APIs and Data CollectionPLUGIN
06Batch data ingestion with Snowflake12 материалов
What is data ingestion?ВидеоBatch ingestion with SnowflakeВидеоLoading data from Snowflake MarketplaceВидеоLoading data using Snowflake’s web interfaceВидеоOptimize compute resources for efficient batch ingestionВидеоLoading data using Snowflake CLIВидеоLoading data using the COPY INTO commandВидеоScenario briefing and account setupЧтениеIngesting data from other data systems using connectorsВидеоRecap and best practices for batch ingestionВидеоAdditional resources on batch ingestion with SnowflakeЧтениеTroubleshooting errors encountered in Module 2Чтение
07Assessment2 материалов
Learner Expectations for Skill AssessmentЧтениеSkill AssessmentЗадание
Чтение
Data Blends vs. JoinsЧтение
Creating a New Tableau Data SourceЧтение
NetflixВидео
Practice - Accessing Multiple Data SourceЗадание
Detecting and removing outliersВидео
The hero of data analysis: Data cleaningЗадание