{"id":14810,"date":"2019-06-15T17:19:06","date_gmt":"2019-06-15T21:19:06","guid":{"rendered":"https:\/\/bangla.salearningschool.com\/recent-posts\/sql-server-ssas-data-mining-data-science-data-analytics-prediction-neural-networks-linear-logistics-regression\/"},"modified":"2020-02-08T09:40:52","modified_gmt":"2020-02-08T14:40:52","slug":"sql-server-ssas-data-mining-data-science-data-analytics-prediction-neural-networks-linear-logistics-regression","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=14810","title":{"rendered":"SQL Server (SSAS): Data Mining: Data Science: Data Analytics: Prediction: Neural Networks : Linear\/Logistics Regression"},"content":{"rendered":"<p>SQL Server Analysis Service:<\/p>\n<p>Data Mining Algorithms (Analysis Services &#8211; Data Mining)<br \/>\n<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/data-mining-algorithms-analysis-services-data-mining?view=sql-server-2017\">https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/data-mining-algorithms-analysis-services-data-mining?view=sql-server-2017<\/a><br \/>\n&#8212;<br \/>\nMicrosoft Association Algorithm<br \/>\n<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/microsoft-association-algorithm?view=sql-server-2017\">https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/microsoft-association-algorithm?view=sql-server-2017<\/a><br \/>\n&#8212;<br \/>\nAssociation Model Query Examples<br \/>\n<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/association-model-query-examples?view=sql-server-2017\">https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/association-model-query-examples?view=sql-server-2017<\/a><br \/>\n&#8212;<br \/>\nMicrosoft Clustering Algorithm<br \/>\n<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/microsoft-clustering-algorithm?view=sql-server-2017\">https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/microsoft-clustering-algorithm?view=sql-server-2017<\/a><\/p>\n<p>Clustering Model Query Examples<br \/>\n<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/clustering-model-query-examples?view=sql-server-2017\">https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/clustering-model-query-examples?view=sql-server-2017<\/a><\/p>\n<p>&#8212;<br \/>\nMicrosoft Time Series Algorithm<br \/>\n<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/microsoft-time-series-algorithm?view=sql-server-2017\">https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/microsoft-time-series-algorithm?view=sql-server-2017<\/a><br \/>\n&#8212;<br \/>\nTime Series Model Query Examples<br \/>\n<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/time-series-model-query-examples?view=sql-server-2017\">https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/time-series-model-query-examples?view=sql-server-2017<\/a><br \/>\n&#8212;<\/p>\n<p>Microsoft Neural Network Algorithm<br \/>\n<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/microsoft-neural-network-algorithm?view=sql-server-2017\">https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/microsoft-neural-network-algorithm?view=sql-server-2017<\/a><br \/>\n&#8212;<br \/>\nNeural Network Model Query Examples<br \/>\n<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/neural-network-model-query-examples?view=sql-server-2017\">https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/neural-network-model-query-examples?view=sql-server-2017<\/a><br \/>\n&#8212;<br \/>\nMicrosoft Naive Bayes Algorithm<br \/>\n<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/microsoft-naive-bayes-algorithm?view=sql-server-2017\">https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/microsoft-naive-bayes-algorithm?view=sql-server-2017<\/a><br \/>\n&#8212;<br \/>\nMicrosoft Logistic Regression Algorithm<br \/>\n<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/microsoft-logistic-regression-algorithm?view=sql-server-2017\">https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/microsoft-logistic-regression-algorithm?view=sql-server-2017<\/a><br \/>\n&#8212;<br \/>\nLogistic Regression Model Query Examples<br \/>\n<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/logistic-regression-model-query-examples?view=sql-server-2017\">https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/logistic-regression-model-query-examples?view=sql-server-2017<\/a><br \/>\n&#8212;<\/p>\n<p>Statistics in SQL: Simple Linear Regressions<br \/>\n&quot;<br \/>\nStatistics in SQL: Pearson\u2019s Correlation<br \/>\nStatistics in SQL: Kendall\u2019s Tau Rank Correlation<br \/>\nStatistics in SQL: Simple Linear Regressions<br \/>\nStatistics in SQL: The Kruskal\u2013Wallis Test<br \/>\nStatistics in SQL: The Mann\u2013Whitney U Test<br \/>\nStatistics in SQL: Student&#8217;s T Test<br \/>\n&quot;<br \/>\n<a href=\"https:\/\/www.red-gate.com\/simple-talk\/blogs\/statistics-sql-simple-linear-regressions\/\">https:\/\/www.red-gate.com\/simple-talk\/blogs\/statistics-sql-simple-linear-regressions\/<\/a><br \/>\n&#8212;<\/p>\n<p>Linear Regression Model Query Examples<br \/>\n&quot;Sample Query 1: Using the Data Mining Schema Rowset to Determine Parameters Used for a Model<br \/>\nSample Query 2: Retrieving the Regression Formula for the Model<br \/>\nSample Query 3: Returning Only the Coefficient for the Model<br \/>\nSample Query 4: Predicting Income using a Singleton Query<br \/>\nSample Query 5: Using Prediction Functions with a Regression Model&quot;<\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/linear-regression-model-query-examples?view=sql-server-2017\">https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/linear-regression-model-query-examples?view=sql-server-2017<\/a><br \/>\n&#8212;<\/p>\n<p>Prediction Functions:<\/p>\n<p>&quot;<br \/>\nPrediction Function\tUsage<br \/>\nIsDescendant (DMX)\tDetermines whether one node is a child of another node in the model.<br \/>\nIsInNode (DMX)\tIndicates whether the specified node contains the current case.<br \/>\nPredictHistogram (DMX)\tReturns a predicted value, or set of values, for a specified column.<br \/>\nPredictNodeId (DMX)\tReturns the Node_ID for each case.<br \/>\nPredictStdev (DMX)\tReturns standard deviation for the predicted value.<br \/>\nPredictSupport (DMX)\tReturns the support value for a specified state.<br \/>\nPredictVariance (DMX)\tReturns the variance of a specified column.<\/p>\n<p>&quot;<br \/>\n<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/linear-regression-model-query-examples?view=sql-server-2017\">https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/linear-regression-model-query-examples?view=sql-server-2017<\/a><br \/>\n&#8212;<\/p>\n<p>Microsoft Linear Regression Algorithm<br \/>\n<a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/microsoft-linear-regression-algorithm?view=sql-server-2017\">https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/microsoft-linear-regression-algorithm?view=sql-server-2017<\/a><br \/>\n&#8212;<\/p>\n<p>Microsoft R<br \/>\n<a href=\"https:\/\/mran.microsoft.com\/spotlightarchive\">https:\/\/mran.microsoft.com\/spotlightarchive<\/a><\/p>\n<p>&#8212;<\/p>\n<p>Decision Trees Model Query Examples<br \/>\nSample Query 3: Retrieving Subtrees from the Model<br \/>\nMaking Predictions using a Decision Trees Model<br \/>\nSample Query 4: Returning Predictions with Probabilities<br \/>\nSample Query 5: Predicting Associations from a Decision Trees Model<br \/>\nSample Query 6: Retrieving a Regression Formula from a Decision Trees Model<\/p>\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/decision-trees-model-query-examples?view=sql-server-2017\">https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/decision-trees-model-query-examples?view=sql-server-2017<\/a><br \/>\n&#8212;<\/p>\n<p>Sayed Ahmed<\/p>\n<p>Linkedin: <a href=\"https:\/\/ca.linkedin.com\/in\/sayedjustetc\">https:\/\/ca.linkedin.com\/in\/sayedjustetc<\/a><\/p>\n<p>Blog: <a href=\"http:\/\/sitestree.com\">http:\/\/sitestree.com<\/a>, <a href=\"http:\/\/bangla.salearningschool.com\">http:\/\/bangla.salearningschool.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>SQL Server Analysis Service: Data Mining Algorithms (Analysis Services &#8211; Data Mining) https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/data-mining-algorithms-analysis-services-data-mining?view=sql-server-2017 &#8212; Microsoft Association Algorithm https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/microsoft-association-algorithm?view=sql-server-2017 &#8212; Association Model Query Examples https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/association-model-query-examples?view=sql-server-2017 &#8212; 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 &#8212; Microsoft Time Series Algorithm https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/microsoft-time-series-algorithm?view=sql-server-2017 &#8212; 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 &#8212; Microsoft Neural Network Algorithm https:\/\/docs.microsoft.com\/en-us\/sql\/analysis-services\/data-mining\/microsoft-neural-network-algorithm?view=sql-server-2017 &#8212; Neural &hellip; <\/p>\n<p><a class=\"more-link btn\" href=\"http:\/\/bangla.sitestree.com\/?p=14810\">Continue reading<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[1910,182],"tags":[],"class_list":["post-14810","post","type-post","status-publish","format-standard","hentry","category-ai-ml-ds-rl-dl-nn-nlp-data-mining-optimization","category---blog","item-wrap"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":23012,"url":"http:\/\/bangla.sitestree.com\/?p=23012","url_meta":{"origin":14810,"position":0},"title":"SQL Server and Data Mining Algorithms #Root #By Sayed Ahmed","author":"Author-Check- Article-or-Video","date":"March 23, 2021","format":false,"excerpt":"SQL Server and Data Mining Algorithms Microsoft Association Algorithm Microsoft Clustering Algorithm Microsoft Decision Trees Algorithm Microsoft Linear Regression Algorithm Microsoft Logistic Regression Algorithm Microsoft Naive Bayes Algorithm Microsoft Neural Network Algorithm Microsoft Sequence Clustering Algorithm Microsoft Time Series Algorithm From: http:\/\/sitestree.com\/?p=1901 Categories:Root, By Sayed AhmedTags: Post Data:2015-02-04 22:27:13 Shop\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":69207,"url":"http:\/\/bangla.sitestree.com\/?p=69207","url_meta":{"origin":14810,"position":1},"title":"How to implement BI\/Warehouse #44","author":"Author-Check- Article-or-Video","date":"August 14, 2021","format":false,"excerpt":"Crime Detection using BI Credit Card fraud detection using BI A presentation on Oracle Data Mining Oracle by Example - Business Intelligence Oracle Data Mining Components Business Intelligence with Microsoft SQL Server Reporting Services - Part 1 SQL Server 2005 Analysis Services Tutorial SQL Server 2005 Data Mining BI for\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":22243,"url":"http:\/\/bangla.sitestree.com\/?p=22243","url_meta":{"origin":14810,"position":2},"title":"Data Mining Tools Overview for Excel and SQL Server #Root #Computer Networks #By Sayed Ahmed #MS SQL Server","author":"Author-Check- Article-or-Video","date":"March 12, 2021","format":false,"excerpt":"Data Mining Tools Overview for Excel and SQL Server [youtube http:\/\/www.youtube.com\/watch?v=4RZ30Y8Qz_A] From: http:\/\/sitestree.com\/?p=1908 Categories:Root, Computer Networks, By Sayed Ahmed, MS SQL ServerTags: Post Data:2015-02-08 21:33:40 Shop Online: https:\/\/www.ShopForSoul.com\/ (Big Data, Cloud, Security, Machine Learning): Courses: http:\/\/Training.SitesTree.com In Bengali: http:\/\/Bangla.SaLearningSchool.com http:\/\/SitesTree.com 8112223 Canada Inc.\/JustEtc: http:\/\/JustEtc.net (Software\/Web\/Mobile\/Big-Data\/Machine Learning) Shop Online: https:\/\/www.ShopForSoul.com\/ Medium:\u2026","rel":"","context":"In &quot;FromSitesTree.com&quot;","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":74166,"url":"http:\/\/bangla.sitestree.com\/?p=74166","url_meta":{"origin":14810,"position":3},"title":"Data Mining Tools Overview for Excel and SQL Server","author":"Sayed","date":"April 16, 2022","format":false,"excerpt":"https:\/\/youtu.be\/4RZ30Y8Qz_A","rel":"","context":"In &quot;From Youtube Channel&quot;","block_context":{"text":"From Youtube Channel","link":"http:\/\/bangla.sitestree.com\/?cat=1952"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/img.youtube.com\/vi\/4RZ30Y8Qz_A\/0.jpg?resize=350%2C200","width":350,"height":200},"classes":[]},{"id":22891,"url":"http:\/\/bangla.sitestree.com\/?p=22891","url_meta":{"origin":14810,"position":4},"title":"Graph Mining: Misc. Topics to Learn: Misc. Resources to Learn From","author":"Sayed","date":"March 21, 2021","format":false,"excerpt":"Graph Mining: Misc. Topics to Learn: Misc. Resources to Learn From Influence\/Virus\/Label Propagation Resources to learn fromPage A presentation on Influence\/Virus PropagationURL Big Data Graph Databases Resources to Learn FromPage Graph DatabaseURL Neo4jPage Big Data Graph Processing Resources to Learn FromPage ToolURL Techniques, Tools and Applications of Graph AnalyticURL Graph\u2026","rel":"","context":"In &quot;Graph Mining&quot;","block_context":{"text":"Graph Mining","link":"http:\/\/bangla.sitestree.com\/?cat=1905"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":78210,"url":"http:\/\/bangla.sitestree.com\/?p=78210","url_meta":{"origin":14810,"position":5},"title":"Model Selection for your Project","author":"Sayed","date":"May 21, 2025","format":false,"excerpt":"Potential Models \u2022 Statistical Models \u2022 Parametric and Non-Parametric \u2022 Mathematical Model (Optimization) \u2022 Machine Learning \u2022 Data Mining \u2022 Deep Learning \u2022 Reinforcement Learning \u2022 Graph Mining \u2022 NLP \u2022 Optimization \u2022 Genetic Algorithm \u2022Association \u2022Basket Association \u2022Apriori Algorithm \u2022Supervised \u2022Classification \u2022Regression \u2022Unsupervised \u2022Clustering\/Customer Segmentation \u2022Reinforcement \u2022Learn a policy\u2026","rel":"","context":"In &quot;Analytics and Machine Learning Project Development&quot;","block_context":{"text":"Analytics and Machine Learning Project Development","link":"http:\/\/bangla.sitestree.com\/?cat=1974"},"img":{"alt_text":"","src":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/05\/image-22.png?resize=350%2C200","width":350,"height":200,"srcset":"https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/05\/image-22.png?resize=350%2C200 1x, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/05\/image-22.png?resize=525%2C300 1.5x, https:\/\/i0.wp.com\/bangla.sitestree.com\/wp-content\/uploads\/2025\/05\/image-22.png?resize=700%2C400 2x"},"classes":[]}],"_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/14810","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=14810"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/14810\/revisions"}],"predecessor-version":[{"id":16773,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/14810\/revisions\/16773"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=14810"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=14810"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=14810"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}