Cleaning and Transforming Data with SQL

One of the first tasks performed when doing data analytics or sciences is to clean the dataset you’re working with. The insights you draw from your data are only as good as the data itself, so it’s no surprise that an estimated 80% of the time spent by analytics professionals involves preparing data for use in analysis. I will discuss and demo different functions commonly used to clean, transform, and remove duplicate data from query outputs that may not be in the form we would like.