Description
In this course, you will learn :
- Learn how to use SQL to detect anomalies in your data.
- Understand how to use mathematical concepts like mean, standard deviation, and z-score to detect anomalies in your data.
- How to investigate previous data to improve and refine the model.
Syllabus :
1. Detecting Anomalies
- Introduction
- What are Anomalies?
- Understanding Z-score
- Optimizing Z-score
2. Analyzing A Server Log
- Getting a Sense of the Data
- Preparing the Data
- Identifying Anomalies
3. Backtesting
- Finding Past Anomalies
- Adding Thresholds
- Eliminating Repeating Alerts
- Experiment with Different Values
4. Improving Accuracy
- Weighted Mean
- Median
- Other Methods
- Conclusion