How To Check Data Quality in Power Query 3
Uploaded by
rajeshps07How To Check Data Quality in Power Query 3
Uploaded by
rajeshps07How to Check
Data Quality
in Power Query
Spot errors, nulls, and patterns in your
data with these options!
01
Why Data Quality Matters?
Imagine this—you’ve spent hours building a report,
only to realise that half the numbers are wrong.
Why? Bad data.
Dirty data can lead to:
- Wrong insights
- Poor business decisions
- Wasted time fixing errors later
The Good news is power Query has built-in tools to
catch these issues early. Let’s explore!
youtube.com/@GoodlyChandeep
02
Meet the Green Line –
Your Data’s Health Indicator
Ever noticed the thin green line under column
headers in Power Query?
It gives you a quick snapshot of your data quality:
Solid Green - All values are valid
Half Green, Half Grey - Some values are missing
Red with Stripes - Errors detected
youtube.com/@GoodlyChandeep
03
Hover over this green bar, and Power Query will give
you a quick summary of the column’s data.
Right-click the bar for quick transformations.
youtube.com/@GoodlyChandeep
04
Column Quality – To See the
Percentage of Errors
Want to know exactly how clean your data is?
Turn on Column Quality (under the View tab) to see
the percentage of valid, error, and empty values.
💡e.g. Imagine you are working with sales data where 5% of
the Order Date column is empty. Would you want to catch that
early? Of course! This tool helps you do just that.
youtube.com/@GoodlyChandeep
05
Column Distribution
This helps you find duplicates and repeating values in
your data. Turn it on (under the View tab) to see:
Unique Values - Values that appear only once
Distinct Values - Total number of different values
💡e.g. Imagine your customer database has 1,000 rows but
only 500 distinct emails, meaning duplicates exist. Cleaning
them ensures accurate analysis.
youtube.com/@GoodlyChandeep
06
Use Column Profile for a
Detailed Check
Column Profile provides a detailed view of your
data, showing row counts, unique values, errors,
and empty records. It also includes a bar chart to
quickly spot duplicates or unusual data.
youtube.com/@GoodlyChandeep
07
Quick Recap
Green Bar - Quick check for valid, null, or error values
Column Quality - See the percentage of valid, empty,
and error values
Column Distribution - Identify duplicates and unique
values
Column Profile - Get a full summary with row counts
and a value distribution chart
Using these tools helps you catch issues early and
keep your data clean & accurate before analysis
youtube.com/@GoodlyChandeep
I have covered a lot of similar
tips and tricks in my book
