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

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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/en-us/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

Concepts

Query (SQL Server Data Mining Add-ins)

Advanced Modeling (Data Mining Add-ins for Excel)