SQL Server Video to Remove Outliers from Data Sets


By:   |   Updated: 2014-07-23   |   Comments   |   Related: More > Import and Export



 






Enter your business email address to
get free SQL Server tips.

Problem / Solution

When looking at data and trying to determine meaningful trends it is helpful to remove any outlier data, so the reports and graphs depict an accurate picture.  In this tip, Tim Smith shows us how to use a SQL Server stored procedure to analyze the data and remove any outliers from the dataset.  We will look at a sample dataset and the expected results by using averages and standard deviations to determine the outliers for the dataset.

Key Learning Items
  • Why tracking outliers is important and how it can affect our data.
  • How to remove outliers from a data set, by building a table without outliers.
Read Companion Tip
Click Here

Last Updated: 2014-07-23


get scripts

next tip button



About the author
MSSQLTips author Tim Smith Tim Smith works as a DBA and developer and also teaches Automating ETL on Udemy.

View all my tips





Comments For This Article





download


Recommended Reading

Bulk Insert Data into SQL Server

SQL Server Bulk Insert for Multiple CSV Files from a Single Folder

Simple Image Import and Export Using T-SQL for SQL Server

Using OPENROWSET to read large files into SQL Server

How to Copy a Table in SQL Server to Another Database





get free sql tips
agree to terms


Learn more about SQL Server tools