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

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

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

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

Data Preparation and Management

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

О курсе

Data Preparation and Management is designed to equip you with the essential skills needed to prepare and manage data effectively using Microsoft Power BI. Throughout this course, you'll learn how to connect, clean, and transform data from various sources to ensure its integrity and quality. You will explore the principles of Extract, Transform, Load (ETL) processes, data storage, and the importance of maintaining data accuracy. This course emphasizes practical applications, providing you with hands-on experience in managing real-world data scenarios. By the end of this course, you’ll be ready to confidently handle data preparation tasks and ensure that your data is ready for analysis and visualization. This program is for anyone interested in data analytics and visualization; there are no prerequisites. To get the most out of the learning experience, it is recommended to follow the courses in sequence, as each one builds on the skills and knowledge gained in the previous ones. By the time you begin this course, you should have a strong understanding of different types of visualizations and their appropriate use, along with the ability to create cohesive and compelling reports in Power BI. You should also be capable of identifying and addressing common design problems in reports, producing audience-focused reports by understanding business needs.

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

Power BIData TransformationData CleansingData QualityExtract, Transform, LoadData AnalysisData IntegrationData StorageData MaintenanceData IntegrityData ProcessingData ManagementData PreprocessingData Wrangling

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

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

01Data sources30 материалов

Course introduction

Course introductionВидеоHow to be successful in this courseЧтениеCourse navigation: Enhanced image viewingЧтениеCourse navigation: Locating downloaded filesЧтение

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

Microsoft

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

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

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 17.4 ч

4 модулей

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

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

Часть программы вашего университета
Activity: Setting up Microsoft 365Чтение
Activity: Setting up your Power BI environmentЧтение
Activity: Updating a data source pathЧтение
Course syllabusЧтение

Introduction to Extract, Transform, Load

The ETL (Extract, Transform, Load) processВидеоHow combining data sources gives business insightsЧтениеSetting up a simple data sourceВидеоActivity: Setting up an Excel data sourceЗаданиеExemplar: Setting up an Excel data sourceЧтениеKnowledge check: Introduction to Extract, Transform, LoadЗадание

Gathering data

Identifying and evaluating required dataВидеоStructured vs. unstructured dataВидеоActivity: Identify appropriate data sourcesЗаданиеExemplar: Identify appropriate data sourcesЧтениеKnowledge check: Gathering dataЗадание

Working with data sources

What are connectors?ВидеоData sources supported by Power BIЧтениеTriggers and actionsВидеоActivity: Implementing a triggerЗаданиеExemplar: Implementing a triggerЧтениеNavigating Microsoft Fabric subscriptionsЧтениеWalkthrough: Summarizing a semantic model with CopilotЧтениеKnowledge check: Working with data sourcesЗадание

Module wrap up

Module summary: Data sourcesВидеоModule quiz: Data sourcesЗаданиеAdditional resources: Data sourcesЧтение
02Data transformation25 материалов

Introduction to data transformation

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ВидеоCommon data errorsЧтениеActivity: Working with Applied stepsЗаданиеExemplar: Working with Applied stepsЧтениеKnowledge check: Introduction to data transformationЗадание

Advanced transformations

Unpivot and pivot columnsВидеоCombining tables with appendВидеоThe importance of matching column namesЧтениеActivity: Pivoting and appending tablesЗаданиеExemplar: Pivoting and appending tablesЧтениеKnowledge check: Advanced transformationsЗадание

Combining data

What is a join?ВидеоIdentifying join keysЧтениеJoin typesВидеоCombining tables with mergeВидеоActivity: Merging two data sourcesЗаданиеExemplar: Merging two data sourcesЧтениеKnowledge check: Combining data

Module wrap up

Module summary: Data transformationВидеоModule quiz: Data transformationЗаданиеAdditional resources: Data transformationЧтение
03Data storage and processing14 материалов

Data cleaning

Dealing with errors in Power QueryВидеоCleaning data at sourceЧтениеEvaluating and changing column data typesВидеоActivity: Clean data in Power QueryЗаданиеExemplar: Clean data in Power QueryЧтениеKnowledge check: Data cleaningЗадание

Data storage

Storing and managing dataВидеоStorage modes in Power BIВидеоConfiguring storage modes in Power BIЧтениеWalk-through: Setting up storage modeЧтениеKnowledge check: Data storageЗадание

Module wrap up

Module summary: Data storage and processingВидеоModule quiz: Data storage and processingЗаданиеAdditional resources: Data storage and processingЧтение
04Final project and assessment: Data Preparation and Management9 материалов

Introduction to the final project

About the final project and assessmentЧтениеFinal project: Transforming multiple data sourcesЧтениеSelf-review: Transforming multiple data sourcesЗаданиеExemplar: Transforming multiple data sourcesPLUGIN

Next steps

Course recap: Data Preparation and ManagementВидеоCourse quiz: Data Preparation and ManagementЗаданиеShowcase your skillsЧтениеCoursera communityЧтениеNext stepsЧтение
Задание