Using ML to clean data

In addition to being a market-leading visualization platform, Power BI offers a suite of built-in machine learning features that empower users to take their data analysis and preparation to the next level. In this section, we will explore those features within Power BI and understand how they can be harnessed to streamline data cleaning, preparation, and enhancement.

Data cleaning with anomaly detection

Data cleaning is often the first step in the data preparation process. Anomalies or outliers in the data can skew analysis results and compromise the quality of reports. Power BI’s built-in anomaly detection feature can automatically identify and flag data points that deviate significantly from the norm. Power BI’s anomaly detection leverages machine learning algorithms to detect data points that are statistically different from the rest. Users can set the sensitivity level to control the number of anomalies detected.

Here are some examples...