SQL Functions to Make Messy Data Clean

Top SQL functions for cleaning raw data

In a perfect world, our data would be clean from the very start. There would be no missing values. The columns would be cast to the right types. We’d be able to perform aggregations and use the data in models with no work at all.

Unfortunately, raw data can be very messy. Consider yourself lucky if you’ve never had to apply a bunch of transformations to …