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
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
