Cleaning and Standardizing Data: Data Quality with Power Query

By: Mobiluck -. Code247 Ai, Vu Tri Cong

The pipeline reruns. The cleaning log explains itself.

Dirty data is not a one-off chore - it arrives again next month. This book builds a repeatable cleaning pipeline in Power Query, and in SQL and Python when the volume outgrows it, then proves the cleaning actually worked.

Every defect it treats is measured first on a raw edition of the Cedar Ridge systems, so you clean what is there rather than what you assume is there.

What you will be able to doProfile first: a defect inventory measured, not guessedTypes, missing values, duplicates, outliers and implausible valuesRecord matching, entity resolution, names, addresses, currency and unitsValidation rules and a cleaning log somebody else can auditWhen not to clean - and how to say so out loudWho it is for

Anyone who receives data from somebody else and is held responsible for what comes out of it.

The labs

Every chapter ends with a practice lab. Each one can be worked in the tools you already have, or in a free browser version that checks your answer as you go - no account, no install. The address is printed inside the book.

About the series

Analytics at Work is an eight-book series for business professionals. All eight run on the same thirty-six months of enterprise data from Cedar Ridge Brands, a fictional American consumer-goods maker. This is Book 3 of 8.

• Format: Paperback
• Language: English
• ISBN: B0HLYW4WRY
• ISBN13: 9798178776452
• Release Date: October 2026
• Publisher: Independently Published
• Length: 262 Pages
• Weight: 0.78 lbs.
• Dimensions: 0.6" x 6.0" x 9.0"