SQL Server Analysis Service:
Data Mining Algorithms (Analysis Services – Data Mining)
https://docs.microsoft.com/en-us/sql/analysis-services/data-mining/data-mining-algorithms-analysis-services-data-mining?view=sql-server-2017
—
Microsoft Association Algorithm
https://docs.microsoft.com/en-us/sql/analysis-services/data-mining/microsoft-association-algorithm?view=sql-server-2017
—
Association Model Query Examples
https://docs.microsoft.com/en-us/sql/analysis-services/data-mining/association-model-query-examples?view=sql-server-2017
—
Microsoft Clustering Algorithm
https://docs.microsoft.com/en-us/sql/analysis-services/data-mining/microsoft-clustering-algorithm?view=sql-server-2017
Clustering Model Query Examples
https://docs.microsoft.com/en-us/sql/analysis-services/data-mining/clustering-model-query-examples?view=sql-server-2017
—
Microsoft Time Series Algorithm
https://docs.microsoft.com/en-us/sql/analysis-services/data-mining/microsoft-time-series-algorithm?view=sql-server-2017
—
Time Series Model Query Examples
https://docs.microsoft.com/en-us/sql/analysis-services/data-mining/time-series-model-query-examples?view=sql-server-2017
—
Microsoft Neural Network Algorithm
https://docs.microsoft.com/en-us/sql/analysis-services/data-mining/microsoft-neural-network-algorithm?view=sql-server-2017
—
Neural Network Model Query Examples
https://docs.microsoft.com/en-us/sql/analysis-services/data-mining/neural-network-model-query-examples?view=sql-server-2017
—
Microsoft Naive Bayes Algorithm
https://docs.microsoft.com/en-us/sql/analysis-services/data-mining/microsoft-naive-bayes-algorithm?view=sql-server-2017
—
Microsoft Logistic Regression Algorithm
https://docs.microsoft.com/en-us/sql/analysis-services/data-mining/microsoft-logistic-regression-algorithm?view=sql-server-2017
—
Logistic Regression Model Query Examples
https://docs.microsoft.com/en-us/sql/analysis-services/data-mining/logistic-regression-model-query-examples?view=sql-server-2017
—
Statistics in SQL: Simple Linear Regressions
"
Statistics in SQL: Pearson’s Correlation
Statistics in SQL: Kendall’s Tau Rank Correlation
Statistics in SQL: Simple Linear Regressions
Statistics in SQL: The Kruskal–Wallis Test
Statistics in SQL: The Mann–Whitney U Test
Statistics in SQL: Student’s T Test
"
https://www.red-gate.com/simple-talk/blogs/statistics-sql-simple-linear-regressions/
—
Linear Regression Model Query Examples
"Sample Query 1: Using the Data Mining Schema Rowset to Determine Parameters Used for a Model
Sample Query 2: Retrieving the Regression Formula for the Model
Sample Query 3: Returning Only the Coefficient for the Model
Sample Query 4: Predicting Income using a Singleton Query
Sample Query 5: Using Prediction Functions with a Regression Model"
Prediction Functions:
"
Prediction Function Usage
IsDescendant (DMX) Determines whether one node is a child of another node in the model.
IsInNode (DMX) Indicates whether the specified node contains the current case.
PredictHistogram (DMX) Returns a predicted value, or set of values, for a specified column.
PredictNodeId (DMX) Returns the Node_ID for each case.
PredictStdev (DMX) Returns standard deviation for the predicted value.
PredictSupport (DMX) Returns the support value for a specified state.
PredictVariance (DMX) Returns the variance of a specified column.
Microsoft Linear Regression Algorithm
https://docs.microsoft.com/en-us/sql/analysis-services/data-mining/microsoft-linear-regression-algorithm?view=sql-server-2017
—
Microsoft R
https://mran.microsoft.com/spotlightarchive
—
Decision Trees Model Query Examples
Sample Query 3: Retrieving Subtrees from the Model
Making Predictions using a Decision Trees Model
Sample Query 4: Returning Predictions with Probabilities
Sample Query 5: Predicting Associations from a Decision Trees Model
Sample Query 6: Retrieving a Regression Formula from a Decision Trees Model
Sayed Ahmed
Linkedin: https://ca.linkedin.com/in/sayedjustetc
Blog: http://sitestree.com, http://bangla.salearningschool.com
