My general motto when it comes to data science is that anything that can be done in SQL should be. Obviously a lot of valuable data science problems require machine learning and, therefore, machine…

Towards Data Science is a community-powered publication that showcases work in data science, machine learning and artificial intelligence. Every day newcomers, seasoned researchers and industry practitioners publish tutorials, research notes and real-world case studies that help the field move forward.

Towards Data Science

Anomaly Detection with Z-Scoring is a simple, unsupervised statistical technique for flagging outliers. Z-scoring is a powerful, minimalist anomaly detection model that can be implemented quickly and flexibly in the data warehouse. The model is based on a fictitious transaction-level table in Snowflake.

Anomaly Detection in SQL