Data Cleaning with Power BI
Keep adding new skills with 10,000+ programs for $239 (usually $399). Save now.
Data Cleaning with Power BI
Included with
Ask Coursera
Recommended experience
Recommended experience
What you'll learn
Connect to data sources using import and DirectQuery methods
Apply data transformations using the Query Editor and M language
Design clean and optimized data models with relationships and DAX calculations
Skills you'll gain
Tools you'll learn
Details to know
March 2026
15 assignments
See how employees at top companies are mastering in-demand skills
There are 15 modules in this course
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.
In this section, we explore data cleaning in Power BI, focusing on Power Query and DAX for effective data preparation and analysis.
What's included
2 videos1 reading1 assignment
2 videos•Total 1 minute
- Courser Overview•1 minute
- Introduction to Power BI Data Cleaning - Overview Video•1 minute
1 reading•Total 20 minutes
- Introduction to Power BI Data Cleaning - The Reading•20 minutes
1 assignment•Total 10 minutes
- Power BI Data Preparation Fundamentals•10 minutes
In this section, we examine factors affecting data quality and the importance of data cleaning for accurate business intelligence. Key concepts include data integrity, best practices, and their impact on decision-making.
What's included
1 video1 reading1 assignment
1 video•Total 1 minute
- Understanding Data Quality and Why Data Cleaning Is Important - Overview Video•1 minute
1 reading•Total 20 minutes
- Understanding Data Quality and Why Data Cleaning Is Important- The Reading•20 minutes
1 assignment•Total 10 minutes
- Data Quality and Cleaning Fundamentals•10 minutes
In this section, we cover data cleaning fundamentals, including quality criteria and systematic approaches for reliable analysis.
What's included
1 video2 readings1 assignment
1 video•Total 1 minute
- Data Cleaning Fundamentals and Principles - Overview Video•1 minute
2 readings•Total 30 minutes
- Introduction•20 minutes
- Building a Process for Cleaning Data•10 minutes
1 assignment•Total 10 minutes
- Data Cleaning Fundamentals•10 minutes
In this section, we explore common data cleaning operations in Power BI, including removing duplicates, handling missing data, and manipulating columns to improve data quality and reliability.
What's included
1 video2 readings1 assignment
1 video•Total 1 minute
- The Most Common Data Cleaning Operations - Overview Video•1 minute
2 readings•Total 50 minutes
- Introduction•20 minutes
- Removing Missing Data•30 minutes
1 assignment•Total 10 minutes
- Data Preparation and Modeling Fundamentals•10 minutes
In this section, we explore assessing data completeness, accuracy, and consistency in Power BI to evaluate data quality and ensure reliable analysis.
What's included
1 video2 readings1 assignment
1 video•Total 1 minute
- Importing Data into Power BI - Overview Video•1 minute
2 readings•Total 50 minutes
- Introduction•30 minutes
- Assessing Data Normalization, Denormalization, and Star Schemas•20 minutes
1 assignment•Total 10 minutes
- Power BI Data Import and Preparation•10 minutes
In this section, we explore data cleaning techniques in Query Editor, including pivot, merge, and type conversion, and compare its workflow with DAX for efficient data transformation.
What's included
1 video3 readings1 assignment
1 video•Total 1 minute
- Cleaning Data with Query Editor - Overview Video•1 minute
3 readings•Total 40 minutes
- Introduction•10 minutes
- Data Cleaning Techniques and Functions•20 minutes
- Using Query Editor Versus DAX for Transformation•10 minutes
1 assignment•Total 10 minutes
- Mastering Data Preparation in Power BI•10 minutes
In this section, we explore the M language for data transformation, focusing on filtering, sorting, and dynamic data sources. It emphasizes practical skills for advanced data manipulation beyond GUI tools.
What's included
1 video6 readings1 assignment
1 video•Total 1 minute
- Transforming Data with the M Language - Overview Video•1 minute
6 readings•Total 120 minutes
- Introduction•20 minutes
- In Expressions•10 minutes
- Filtering and Sorting Data with M•30 minutes
- Working with Data Sources in M•20 minutes
- Using Parameters to Filter Data and Conditional Data Source Selection•20 minutes
- Combining Multiple CSV Files•20 minutes
1 assignment•Total 10 minutes
- Mastering Data Transformation with M Language•10 minutes
In this section, we explore Power BI's data profiling tools for EDA, focusing on column quality, distribution, and profile to improve data reliability and analysis outcomes.
What's included
1 video2 readings1 assignment
1 video•Total 1 minute
- Using Data Profiling for Exploratory Data Analysis (EDA) - Overview Video•1 minute
2 readings•Total 30 minutes
- Introduction•10 minutes
- Column Profile•20 minutes
1 assignment•Total 10 minutes
- Exploratory Data Analysis with Data Profiling•10 minutes
In this section, we explore advanced data cleaning techniques using Power Query, R, Python, and ML to improve data accuracy and analysis quality in Power BI.
What's included
1 video4 readings1 assignment
1 video•Total 1 minute
- Advanced Data Cleaning Techniques - Overview Video•1 minute
4 readings•Total 90 minutes
- Introduction•20 minutes
- Best Practices for Using Fuzzy Matching and Fill Down•30 minutes
- Using ML to Clean Data•30 minutes
- Data Enhancement with AI Insights•10 minutes
1 assignment•Total 10 minutes
- Mastering Data Preparation in Power BI•10 minutes
In this section, we explore creating custom Power Query functions in Power BI, focusing on planning, parameter usage, and writing M code for efficient data transformation.
What's included
1 video2 readings1 assignment
1 video•Total 1 minute
- Creating Custom Functions in Power Query - Overview Video•1 minute
2 readings•Total 60 minutes
- Introduction•30 minutes
- Best Practices for Using Parameters•30 minutes
1 assignment•Total 10 minutes
- Mastering Custom Functions in Power Query•10 minutes
In this section, we explore techniques to optimize Power Query performance, including filtering data early, using native M functions, and applying lazy evaluation for efficient memory use.
What's included
1 video4 readings1 assignment
1 video•Total 1 minute
- Query Optimization - Overview Video•1 minute
4 readings•Total 80 minutes
- Introduction•20 minutes
- Filtering and Reducing Data•20 minutes
- Using Native M Functions•10 minutes
- Parallel Query Execution•30 minutes
1 assignment•Total 10 minutes
- M Query Optimization Fundamentals•10 minutes
In this section, we explore data modeling techniques in Power BI, focusing on relationships, cardinality, and performance optimization to ensure clean and reliable data for analysis.
What's included
1 video8 readings1 assignment
1 video•Total 1 minute
- Data Modeling and Managing Relationships - Overview Video•1 minute
8 readings•Total 110 minutes
- Introduction•20 minutes
- Snowflake Schema•10 minutes
- Role-playing Dimensions•10 minutes
- Using Bidirectional Cross-Filtering•20 minutes
- Best Practices for Bidirectional Cross-Filtering•10 minutes
- Choosing the Right Cardinality•10 minutes
- Handling Large and Complex Datasets•10 minutes
- Avoiding Circular References•20 minutes
1 assignment•Total 10 minutes
- Mastering Data Relationships and Schema Design•10 minutes
In this section, we explore data preparation for paginated reports in Power BI Report Builder, focusing on connecting data sources, using filters, and structuring reports for precise output.
What's included
1 video5 readings1 assignment
1 video•Total 1 minute
- Preparing Data for Paginated Reporting - Overview Video•1 minute
5 readings•Total 90 minutes
- Introduction•10 minutes
- Connecting to Data Sources Within Power BI Report Builder•20 minutes
- Data Preparation•10 minutes
- Creating a Dataset Example•20 minutes
- Using Row Groups/Column Groups•30 minutes
1 assignment•Total 10 minutes
- Data Preparation for Paginated Reporting•10 minutes
In this section, we explore Power Automate's role in automating data cleaning, refreshing, and notifications, enhancing data reliability and efficiency in Power BI workflows.
What's included
1 video3 readings1 assignment
1 video•Total 1 minute
- Automating Data Cleaning Tasks with Power Automate - Overview Video•1 minute
3 readings•Total 70 minutes
- Introduction•20 minutes
- Automating Refreshing of Data•20 minutes
- Creating a Snapshot of Yesterday's Data•30 minutes
1 assignment•Total 10 minutes
- Automating Data Cleaning with Power Automate•10 minutes
In this section, we explore how OpenAI and AI tools enhance data cleaning and preparation in Power BI, focusing on efficiency, accuracy, and workflow optimization using ChatGPT and DAX.
What's included
1 video4 readings1 assignment
1 video•Total 1 minute
- Making Life Easier with OpenAI - Overview Video•1 minute
4 readings•Total 70 minutes
- Introduction•10 minutes
- Using OpenAI for M Queries•30 minutes
- Using Microsoft Copilot•20 minutes
- Tackling Challenges with AI•10 minutes
1 assignment•Total 10 minutes
- Efficient Data Processing with AI Tools•10 minutes
Instructor
Why people choose Coursera for their career
Frequently asked questions
Yes, you can preview the first video and view the syllabus before you enroll. You must purchase the course to access content not included in the preview.
If you decide to enroll in the course before the session start date, you will have access to all of the lecture videos and readings for the course. You’ll be able to submit assignments once the session starts.
Once you enroll and your session begins, you will have access to all videos and other resources, including reading items and the course discussion forum. You’ll be able to view and submit practice assessments, and complete required graded assignments to earn a grade and a Course Certificate.
More questions
Financial aid available,