Chapter 12: Adding Statistics Insights: Outliers and Missing Values
In an effort to extend the data enrichment possibilities in Power BI through statistical functions, we will explore some methodologies to detect univariate and multivariate outliers in your dataset. In addition, advanced methodologies to impute possible missing values in datasets and time-series will be explored. Knowledge of these techniques is critical for the experienced analyst because Power BI does not provide useful tools for this purpose by default.
In this chapter, we will cover the following topics:
- What outliers are and how to deal with them
- Identifying outliers
- Implementing outlier detection algorithms
- What missing values are and how to deal with them
- Diagnosing missing values
- Implementing missing value imputation algorithms
