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.
This exercise is part of the course
Data Preparation in Power BI
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
