Learn more about SQL Server tools

mssqltips logo
 

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Whitepapers          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories

 

SQL Server Video to Remove Outliers from Data Sets


By:   |   Last Updated: 2014-07-23   |   Comments   |   Related Tips: 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


next webcast button


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




Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 


Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.



    



Learn more about SQL Server tools