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

Is the following statement true or false:

_"Backtesting can be used to identify past anomalies"_

Is the following statement true or false:
“Backtesting can be used to identify past anomalies”

Is the following statement true or false:

_"Backtesting is used primarily to refine the parameters"_

Is the following statement true or false:
“Backtesting is used primarily to refine the parameters”

Is the following statement true or false:

_"An anomaly detection system cannot produce false alerts"_

Is the following statement true or false:
“An anomaly detection system cannot produce false alerts”

Is the following statement true or false:

_"Thresholds are used to minimize false positives on very low values"_

Is the following statement true or false:
“Thresholds are used to minimize false positives on very low values”

Is the following statement true or false:

_"False alerts compromise the reliability of the anomaly detection system"_

Is the following statement true or false:
“False alerts compromise the reliability of the anomaly detection system”

Detecting Anomalies

Analyzing A Server Log

Backtesting

Improving Accuracy

Quiz 3