Get startedGet started for free

Addressing outliers in the data

Now that you know how to identify outliers with a dataset, there are times when you would like to address them. This could be for visualization purposes or for helping further analysis (i.e. correlation with other variables). In any case, it's always best practice to log what modifications are performed.

In this exercise, you'll use a nested IF() statement to modified the updated_price variable to address outliers <0.5% or >0.95%.

If you have lost any progress, close any open reports and load 2_3_address_outliers.pbix from the Workbooks folder on the Desktop.

This exercise is part of the course

Exploratory Data Analysis in Power BI

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise