{ "item_title" : "Cleaning and Standardizing Data", "item_author" : [" Vu Tri Cong Mobiluck -. Code247 Ai "], "item_description" : "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 forAnyone who receives data from somebody else and is held responsible for what comes out of it.The labsEvery 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 seriesAnalytics 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.", "item_img_path" : "https://covers1.booksamillion.com/covers/bam/9/79/817/877/9798178776452_b.jpg", "price_data" : { "retail_price" : "12.99", "online_price" : "12.99", "our_price" : "12.99", "club_price" : "12.99", "savings_pct" : "0", "savings_amt" : "0.00", "club_savings_pct" : "0", "club_savings_amt" : "0.00", "discount_pct" : "10", "store_price" : "" } }

Overview

Customers Also Bought

Details