Get startedGet started for free

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

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise