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

The methods you learned in this course are straightforward methods to detect anomalies and produce actionable alerts that can save you much grief. There are many tools out there that provide similar functionality, but they require tight integration or money. The main appeal of this approach is that you can get started with tools you probably already have, some SQL, and a scheduled task!



Detecting Anomalies

Analyzing A Server Log

Backtesting

Improving Accuracy

Conclusion