Profiling to find anomalies

Let's put together the skills we've acquired in this chapter to clean up a dataset of products from the Adventure Works database, although this dataset has some anomalies in it.

We can find some duplicated records as well as missing values in this data, which we will identify and fix. We will convert the dollar-amount columns as currencies, so that it is easier to interpret once we start analyzing them in the report. Finally, we will use the Column Profile feature to answer a question about our data.