data-mining-algorithms-sql-server-data-mining-add-ins.md

title	Data Mining Algorithms (SQL Server Data Mining Add-ins) | Microsoft Docs
ms.custom
ms.date	06/13/2017
ms.prod	sql-server-2014
ms.reviewer
ms.technology	analysis-services
ms.topic	conceptual
helpviewer_keywords	segmentation data mining algorithms clustering [data mining] linear regression association [data mining] neural networks logistic regression regression sequence analysis decision tree [data mining] Naive Bayes time series [data mining]
ms.assetid	3a1a62e4-9fb5-4cdb-a6c6-1b8b30d417ef
author	minewiskan
ms.author	owend
manager	craigg

Data Mining Algorithms (SQL Server Data Mining Add-ins)

The Data Mining Add-ins for Office supports creation of analytical models using the following data mining algorithms. All algorithms are based on well-known machine learning methods and have been implemented by Microsoft Research.

Algorithms

Machine learning method	How it works
Microsoft Association Rules algorithm	Discover which products are purchased together or which events occur together, and use the model to create recommendations. https://msdn.microsoft.com/library/ms174916.aspx
Microsoft Clustering algorithm	Define market segments, automatically group related customers together, or find relationships in data to use in further mining. https://msdn.microsoft.com/library/ms174879.aspx
Microsoft Decision Trees algorithm	Identify previously unknown relationships between various elements of your data to better inform your decisions, or find the factors that lead to specific outcomes. https://msdn.microsoft.com/library/ms174923.aspx
Microsoft Linear Regression algorithm	Find a mathematical formula that describes factors that contribute to a numeric outcome. https://msdn.microsoft.com/library/ms174824.aspx
Microsoft Logistic Regression algorithm	Identify the factors that contribute to binary outcomes, and learn how to use those to affect results. https://msdn.microsoft.com/library/ms174828.aspx
Microsoft Naïve Bayes algorithm	Explore relationships in your data and find those mostly closely correlated with an outcome. https://msdn.microsoft.com/library/ms174806.aspx
Microsoft Neural Networks algorithm	Find hidden relationships among multiple inputs and even multiple outputs. Use for exploration or for prediction. https://msdn.microsoft.com/library/ms174941.aspx
Microsoft Time Series algorithm	Use historical data to forecast future values. https://msdn.microsoft.com/library/ms174923.aspx

Advanced Options

When you use the Data Mining Client for Excel, you have the option to create your own data mining structures and models, or to fine-tune the parameters of the algorithms.

Algorithm Parameters (SQL Server Data Mining Add-ins)

There are two ways to customize your models using these advanced options:

• Use the Data Mining Query wizard to create your model.

• In the Data Mining Client, after you start the wizard, click Parameters.

See Also

Query (SQL Server Data Mining Add-ins)
Advanced Modeling (Data Mining Add-ins for Excel)