Watch me Cleaning Data in minutes with SQL

Join my Academy, learn Data & AI skills and land a job👇 https://analyticsautomation.academy/ Data cleaning with SQL seems straightforward, but ironically, real-world errors and debugging make it anything but simple. In this video, I walk you through an end-to-end data cleaning process in SQL using Google BigQuery, tackling messy data issues like inconsistent formats, incorrect data types, duplicates, and null values - the real challenges data pros face daily. The dataset that I used is available here https://drive.google.com/drive/folders/1Y1CtbX6CLOfKBNI9AxbtDN4_pjLpeROs?usp=sharing 📸 SOCIAL Instagram and TikTok - @Loresowhat https://www.instagram.com/loresowhat/ https://www.tiktok.com/@loresowhat 📩 Get in touch: loresowhat@gmail.com 🔎 CONTENT 0:00 Introduction to Data Cleaning and Overview 2:01 Setup of Project and Dataset in Google BigQuery 4:18 Standardizing Order Status Data 7:46 Standardizing Product Name Data 8:20 Cleaning the Quantity Field 10:37 Cleaning Customer Name Field 12:37 Identifying Duplicates with Window Functions 17:27 Removing Duplicated Orders 19:01 Final Clean Data Query and Closing Remarks #DataCleaning #SQLTutorial #GoogleBigQuery