Gain insights into using SQL for anomaly detection. Delve into applying mean, standard deviation, and z-score to identify and investigate data anomalies, enhancing your analytical skills.

ruby.tar.gz

Learn how to identify anomalies in your data using SQL. Understand how to apply mathematical concepts such as mean, standard deviation, and z-score to detect when an anomaly occurred in your data and how to investigate past data to improve and refine the model.

Simple Anomaly Detection using SQL

# Mean absolute deviation

Median absolute deviation (MAD) is another way of finding anomalies in a series. MAD is considered better than the z-score for real-life data.

MAD is calculated by finding the median of the deviations from the series median. Just for comparison, the standard deviation is the root square of the average square distance from the mean.



Learn how to use the mean absolute deviation to improve the accuracy of anomaly detection.

Detecting Anomalies

Analyzing A Server Log

Backtesting

Improving Accuracy

Other Methods

Mean absolute deviation