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

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

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

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

Data Cleaning with Power BI

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

О курсе

Data cleaning is one of the most critical stages in the analytics process, ensuring that every insight drawn from data is accurate and trustworthy. This course, Data Cleaning with Power BI, equips professionals with the skills to transform messy, inconsistent data into actionable insights using Microsoft’s most powerful business intelligence platform. Through hands-on lessons, you’ll learn how to use Power Query, DAX, and the M language to streamline your data preparation workflows. By the end of the course, you’ll be able to connect to multiple data sources, apply robust transformations, and design optimized data models ready for visualization and analysis. Unlike other Power BI courses that focus solely on dashboards, this one emphasizes the foundations of clean, structured, and meaningful data. Each module combines theory with real-world applications, enabling you to solve practical business problems using tested data-cleaning techniques. This course is ideal for data analysts, BI professionals, and data scientists who want to enhance their Power BI capabilities. While a basic understanding of BI tools is recommended, beginners can also follow along thanks to step-by-step examples and guided exercises.

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

Data CleansingData TransformationPower BIData VisualizationData AnalysisData IntegrationData WranglingData PreprocessingData ProcessingData ManagementData Visualization SoftwareData ManipulationData ModelingData QualityData Analysis Expressions (DAX)Query LanguagesPandas (Python Package)

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

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

01Introduction to Power BI Data Cleaning4 материалов

Lesson 1

Courser OverviewВидеоIntroduction to Power BI Data Cleaning - Overview VideoВидеоIntroduction to Power BI Data Cleaning - The ReadingЧтениеPower BI Data Preparation FundamentalsЗадание

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

Packt - Course Instructors

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

Data Cleaning with Power BI
В каталоге вашей программы

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

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

Начать на Coursera

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

Обучение на Coursera

≈ 18.2 ч

15 модулей

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

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

Часть программы вашего университета
02Understanding Data Quality and Why Data Cleaning Is Important3 материалов

Lesson 1

Understanding Data Quality and Why Data Cleaning Is Important - Overview VideoВидеоUnderstanding Data Quality and Why Data Cleaning Is Important- The ReadingЧтениеData Quality and Cleaning FundamentalsЗадание
03Data Cleaning Fundamentals and Principles4 материалов

Lesson 1

Data Cleaning Fundamentals and Principles - Overview VideoВидеоIntroductionЧтениеBuilding a Process for Cleaning DataЧтениеData Cleaning FundamentalsЗадание
04The Most Common Data Cleaning Operations4 материалов

Lesson 1

The Most Common Data Cleaning Operations - Overview VideoВидеоIntroductionЧтениеRemoving Missing DataЧтениеData Preparation and Modeling FundamentalsЗадание
05Importing Data into Power BI4 материалов

Lesson 1

Importing Data into Power BI - Overview VideoВидеоIntroductionЧтениеAssessing Data Normalization, Denormalization, and Star SchemasЧтениеPower BI Data Import and PreparationЗадание
06Cleaning Data with Query Editor5 материалов

Lesson 1

Cleaning Data with Query Editor - Overview VideoВидеоIntroductionЧтениеData Cleaning Techniques and FunctionsЧтениеUsing Query Editor Versus DAX for TransformationЧтениеMastering Data Preparation in Power BIЗадание
07Transforming Data with the M Language8 материалов

Lesson 1

Transforming Data with the M Language - Overview VideoВидеоIntroductionЧтениеIn ExpressionsЧтениеFiltering and Sorting Data with MЧтениеWorking with Data Sources in MЧтениеUsing Parameters to Filter Data and Conditional Data Source SelectionЧтениеCombining Multiple CSV FilesЧтениеMastering Data Transformation with M LanguageЗадание
08Using Data Profiling for Exploratory Data Analysis (EDA)4 материалов

Lesson 1

Using Data Profiling for Exploratory Data Analysis (EDA) - Overview VideoВидеоIntroductionЧтениеColumn ProfileЧтениеExploratory Data Analysis with Data ProfilingЗадание
09Advanced Data Cleaning Techniques6 материалов

Lesson 1

Advanced Data Cleaning Techniques - Overview VideoВидеоIntroductionЧтениеBest Practices for Using Fuzzy Matching and Fill DownЧтениеUsing ML to Clean DataЧтениеData Enhancement with AI InsightsЧтениеMastering Data Preparation in Power BIЗадание
10Creating Custom Functions in Power Query4 материалов

Lesson 1

Creating Custom Functions in Power Query - Overview VideoВидеоIntroductionЧтениеBest Practices for Using ParametersЧтениеMastering Custom Functions in Power QueryЗадание
11Query Optimization6 материалов

Lesson 1

Query Optimization - Overview VideoВидеоIntroductionЧтениеFiltering and Reducing DataЧтениеUsing Native M FunctionsЧтениеParallel Query ExecutionЧтениеM Query Optimization FundamentalsЗадание
12Data Modeling and Managing Relationships10 материалов

Lesson 1

Data Modeling and Managing Relationships - Overview VideoВидеоIntroductionЧтениеSnowflake SchemaЧтениеRole-playing DimensionsЧтениеUsing Bidirectional Cross-FilteringЧтениеBest Practices for Bidirectional Cross-FilteringЧтениеChoosing the Right CardinalityЧтениеHandling Large and Complex DatasetsЧтениеAvoiding Circular ReferencesЧтениеMastering Data Relationships and Schema DesignЗадание
13Preparing Data for Paginated Reporting7 материалов

Lesson 1

Preparing Data for Paginated Reporting - Overview VideoВидеоIntroductionЧтениеConnecting to Data Sources Within Power BI Report BuilderЧтениеData PreparationЧтениеCreating a Dataset ExampleЧтениеUsing Row Groups/Column GroupsЧтениеData Preparation for Paginated ReportingЗадание
14Automating Data Cleaning Tasks with Power Automate5 материалов

Lesson 1

Automating Data Cleaning Tasks with Power Automate - Overview VideoВидеоIntroductionЧтениеAutomating Refreshing of DataЧтениеCreating a Snapshot of Yesterday's DataЧтениеAutomating Data Cleaning with Power AutomateЗадание
15Making Life Easier with OpenAI6 материалов

Lesson 1

Making Life Easier with OpenAI - Overview VideoВидеоIntroductionЧтениеUsing OpenAI for M QueriesЧтениеUsing Microsoft CopilotЧтениеTackling Challenges with AIЧтениеEfficient Data Processing with AI ToolsЗадание