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

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

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

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

Extract, Transform and Load Data in Power BI

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

О курсе

This course forms part of the Microsoft Power BI Analyst Professional Certificate. This Professional Certificate consists of a series of courses that offers a good starting point for a career in data analysis using Microsoft Power BI. In this course, you will learn the process of Extract, Transform and Load or ETL. You will identify how to collect data from and configure multiple sources in Power BI and prepare and clean data using Power Query. You’ll also have the opportunity to inspect and analyze ingested data to ensure data integrity. After completing this course, you’ll be able to: • Identify, explain and configure multiple data sources in Power BI • Clean and transform data using Power Query • Inspect and analyze ingested data to ensure data integrity This is also a great way to prepare for the Microsoft PL-300 exam. By passing the PL-300 exam, you’ll earn the Microsoft Power BI Data Analyst certification.

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

Data TransformationData IntegrationExtract, Transform, LoadPower BIData CleansingData IntegrityData QualityData Import/ExportData AnalysisData StorageData Validation

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

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

01Data Sources in Power BI29 материалов

Welcome to the Course

Course IntroductionВидеоCourse SyllabusЧтениеDiscovering Your Data FoundationsDIALOGUESetting up your Power BI environmentЧтение

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

Microsoft

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

Extract, Transform and Load Data in Power BI
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 20.4 ч

4 модулей

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

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

Часть программы вашего университета
Additional Resources: Data sources in Power BIЧтение

Basic Data Sources

How combining data sources gives business insightsВидеоData Sources supported by Power BIЧтениеSetting up a flat data sourceВидеоLocal datasets vs. shared datasetsЧтениеExercise: Setting up an Excel data sourceЧтениеSelf-review: Setting up an Excel data sourceЗаданиеExemplar: Setting up an Excel data sourceЧтениеStorage modes in Power BIВидеоConfiguring storage modes in Power BIВидеоWalkthrough: Setting up your storage modeЧтениеChoosing the Right Data Source and Storage ModeDIALOGUEKnowledge check: Basic data sourcesЗаданиеAdditional resources: Basic data sourcesЧтение

Advanced Data Sources

Structured vs. unstructured dataВидеоWhat are connectors?ВидеоTriggers and actionsВидеоExercise: Implementing triggersЧтениеSelf-review: Implementing triggersЗаданиеExemplar: Implementing triggersЧтениеKnowledge check: Advanced data sourcesЗаданиеMastering Data Sources, Connectors, and AutomationDIALOGUEModule summary: Data sources in Power BIВидеоModule quiz: Data sources in Power BIЗаданиеAdditional resources: Advanced data sourcesЧтение
02Transforming Data in Power BI36 материалов

Introduction to Transforming Data in Power BI

Why data needs to be transformedВидеоIntroduction to Power Query and its interfaceВидеоThe Applied Steps listВидеоData types in Power BIЧтениеWorking with columnsВидеоEvaluating and changing column data typesЧтениеCommon data errorsЧтениеDealing with errors in Power QueryВидеоExercise: Preparing a datasetЧтениеSelf-review: Preparing a datasetЗаданиеExemplar: Preparing a datasetЧтениеUnpivot and pivot columnsВидеоActivity: Apply a pivotЧтениеKnowledge Check: Introduction to transforming data in Power BIЗаданиеAdditional Resources: Introduction to transforming data in Power BIЧтение

Advanced Data Transformations in Power BI

The Importance of data combinationВидеоCombining tables with appendВидеоThe importance of matching column namesЧтениеExercise: Appending two tablesЧтениеSelf-review: Appending two tablesЗаданиеExemplar: Appending two tablesЧтение

Transformations by Combining Data

What is a join?ВидеоIdentifying join keysЧтениеJoin typesВидеоCombining tables with mergeВидеоExercise: Merging two data sourcesЧтениеSelf-review: Merging two data sourcesЗаданиеExemplar: Merging two data sources
03Advanced ETL in PowerBI31 материалов

Loading Data with Power BI

Introduction to loading dataВидеоThe Staging Area in Power BIВидеоEnd-to-end ETL process and Power BIЧтениеKnowledge Check: Loading data with Power BIЗаданиеAdditional Resources: Loading data with Power BIЧтение

Data Profiling in Power BI

Introduction to data profilingВидеоProfiling Data in Power BIВидеоUsing the Data Profiling ToolsЧтениеExercise: Profiling a datasetЧтениеSelf-review: Profiling a datasetЗаданиеExemplar: Profiling a datasetЧтениеVignette: Bad dataВидеоKnowledge Check: Data profiling in Power BIЗаданиеAdditional Resources: Data profiling in Power BIЧтениеPower BI Data Profiling: Fixing Anomalies at Adventure WorksDIALOGUE

Advanced Queries

Best practices when working with Power QueryВидеоActivity: Import a dataset with best practicesЧтениеIntroduction to dataflowsВидеоIntroduction to Reference QueriesВидеоReference queries and dataflowsВидеоActivity: Using reference queriesЧтение
04Graded Assessment and Course wrap up9 материалов

Final project and assessment: Extract Transform and Load Data in Power BI

Course Recap: Extract, transform and load data in Power BIВидеоAbout the final project and assessment: Extract, transform and load data in Power BIЧтениеFinal Course Project: Transforming multiple data sourcesЧтениеSelf-review: Transforming multiple data sourcesЗаданиеExemplar: Transforming multiple data sourcesЧтениеCourse quiz: Extract, transform and load Data in Power BIЗадание

Course wrap-up

CongratulationsВидеоReflect on learningОбсуждениеNext stepsЧтение
Knowledge Check: Advanced data transformations in Power BIЗадание
Additional Resources: Advanced data transformations in Power BIЧтение
Чтение
Identifying a new potential productВидео
Knowledge check: Transformations by combining dataЗадание
Module summary: Transforming data in Power BIВидео
What challenges might you encounter when combining data?Обсуждение
Module quiz: Transforming data in Power BIЗадание
Additional resources: Transformations by combining dataЧтение
Query parametersВидео
Helper QueriesЧтение
Activity: Disabling helper queriesЧтение
Using Advanced Editor to modify codeВидео
Global options for filesЧтение
Knowledge check: Advanced queriesЗадание
Module Summary: Advanced ETL in PowerBIВидео
Which best practices did you find most useful?Обсуждение
Module Quiz: Advanced ETL in PowerBIЗадание
Additional Resources: Advanced queriesЧтение