When will I receive my Course Certificate?

If you complete the course successfully, your electronic Course Certificate will be added to your Accomplishments page - from there, you can print your Course Certificate or add it to your LinkedIn profile.

Why can’t I audit this course?

This course is currently available only to learners who have paid or received financial aid, when available.

Is financial aid available?

Yes. In select learning programs, you can apply for financial aid or a scholarship if you can’t afford the enrollment fee. If fin aid or scholarship is available for your learning program selection, you’ll find a link to apply on the description page.

Data Cleaning with Power BI

Data Cleaning with Power BI

Instructor: Packt - Course Instructors

Included with

Learn more

15 modules

Gain insight into a topic and learn the fundamentals.

Beginner level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

15 modules

Gain insight into a topic and learn the fundamentals.

Beginner level

Recommended experience

2 weeks to complete

at 10 hours a week

Flexible schedule

Learn at your own pace

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

Details to know

Shareable certificate

Add to your LinkedIn profile

See how employees at top companies are mastering in-demand skills

Learn more about Coursera for Business

logos of Petrobras, TATA, Danone, Capgemini, P&G and L'Oreal

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

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

In this section, we cover data cleaning fundamentals, including quality criteria and systematic approaches for reliable analysis.

What's included

1 video2 readings1 assignment

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

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

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

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

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

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

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

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

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

Instructor

Packt - Course Instructors

Packt

1,608 Courses 446,194 learners

Offered by

Packt

Why people choose Coursera for their career

Felipe M.

Learner since 2018

"To be able to take courses at my own pace and rhythm has been an amazing experience. I can learn whenever it fits my schedule and mood."

Jennifer J.

Learner since 2020

"I directly applied the concepts and skills I learned from my courses to an exciting new project at work."

Larry W.

Learner since 2021

"When I need courses on topics that my university doesn't offer, Coursera is one of the best places to go."

Chaitanya A.

"Learning isn't just about being better at your job: it's so much more than that. Coursera allows me to learn without limits."

Open new doors with Coursera Plus

Unlimited access to 10,000+ world-class courses, hands-on projects, and job-ready certificate programs - all included in your subscription

Learn more

Advance your career with an online degree

Earn a degree from world-class universities - 100% online

Explore degrees

Join over 3,400 global companies that choose Coursera for Business

Upskill your employees to excel in the digital economy

Learn more

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.

Data Cleaning with Power BI

Data Cleaning with Power BI

What you'll learn

Details to know

See how employees at top companies are mastering in-demand skills

There are 15 modules in this course

Introduction to Power BI Data Cleaning

What's included

Understanding Data Quality and Why Data Cleaning Is Important

What's included

Data Cleaning Fundamentals and Principles

What's included

The Most Common Data Cleaning Operations

What's included

Importing Data into Power BI

What's included

Cleaning Data with Query Editor

What's included

Transforming Data with the M Language

What's included

Using Data Profiling for Exploratory Data Analysis (EDA)

What's included

Advanced Data Cleaning Techniques

What's included

Creating Custom Functions in Power Query

What's included

Query Optimization

What's included

Data Modeling and Managing Relationships

What's included

Preparing Data for Paginated Reporting

What's included

Automating Data Cleaning Tasks with Power Automate

What's included

Making Life Easier with OpenAI

What's included

Instructor

Offered by

Why people choose Coursera for their career

Felipe M.

Jennifer J.

Larry W.

Chaitanya A.

Open new doors with Coursera Plus

Advance your career with an online degree

Join over 3,400 global companies that choose Coursera for Business

Frequently asked questions

Can I preview a course before enrolling?

When will I have access to the lectures and assignments?

What will I get when I enroll?

More questions