sql

Data Cleaning 101 in SQL - #4.2 A Practical Tutorial for Data Deduplication

I am glad to have you for the fourth part of my complete guide on data cleaning.

Sep 17, 2023 •

Data Cleaning 101 in SQL - #4.1 Where does data duplication come from?

Unlike the Queen in Snow White, we data analysts do not possess a Magic Mirror that reveals the location of duplicated data

Aug 21, 2023 •

Data Cleaning 101 in SQL — # 3.2 The Origin of Outliers & Detection Techniques

Everything that exists has an explanation for its existence

Aug 1, 2023 •

Data Cleaning 101 in SQL — # 3.1 A discussion on the Nature of Outliers

I like weird people.

Jul 27, 2023 •

Data Cleaning 101 in SQL — #2 Dealing with Missing Data

When you are missing someone, time seems to move slower, and when I’m falling in love with someone, time seems to be moving faster.

Jul 16, 2023 •

Data Cleaning 101 in SQL — #1 Tidying Messy Data

Data cleaning has always been a nightmare that every single analyst has to walk through (like through fire and flames).

Jul 16, 2023 •

#nojs-banner { position: fixed; bottom: 0; left: 0; padding: 16px 16px 16px 32px; width: 100%; box-sizing: border-box; background: red; color: white; font-family: -apple-system, "Segoe UI", Roboto, Helvetica, Arial, sans-serif, "Apple Color Emoji", "Segoe UI Emoji", "Segoe UI Symbol"; font-size: 13px; line-height: 13px; } #nojs-banner a { color: inherit; text-decoration: underline; } This site requires JavaScript to run correctly. Please turn on JavaScript or unblock scripts