{"id":78970,"date":"2026-11-10T19:50:56","date_gmt":"2026-11-10T19:50:56","guid":{"rendered":"http:\/\/bangla.sitestree.com\/?p=78970"},"modified":"2026-11-10T19:56:58","modified_gmt":"2026-11-10T19:56:58","slug":"rewritten-sql-server-14810","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=78970","title":{"rendered":"SQL Server Analysis Services Data Mining Algorithms: Historical Survey"},"content":{"rendered":"<p>Earlier SQL Server Analysis Services editions supported data mining algorithms for classification, regression, clustering, association discovery and time-series modelling.<\/p>\n<h2>Concepts and context<\/h2>\n<p>Decision trees split a population into predictive segments, logistic regression predicts categories, linear regression estimates continuous outcomes, and clustering identifies similar records. Association rules find co-occurrence patterns; time-series models estimate temporal behaviour.<\/p>\n<h2>Practical application<\/h2>\n<p>A modern project can source clean data from SQL Server, fit baseline and advanced models in a supported ML environment, compare accuracy on held-out observations and monitor drift in production.<\/p>\n<h2>Compatibility and cautions<\/h2>\n<p>SSAS data mining was deprecated in SQL Server 2017 and discontinued in SQL Server 2022. Legacy DMX and Excel add-in tutorials are historical, not current installation guidance.<\/p>\n<hr\/>\n<p><strong>AI and reuse disclosure:<\/strong> This newly written tutorial was generated with AI using <a href=\"https:\/\/bangla.sitestree.com\/?p=14810\">an existing Open Education article (post 14810)<\/a> as its starting point; explanations and examples may have been added. You may copy, edit and reuse the generated text with or without a reference. Rights in trademarks and third-party content remain with their respective owners. <strong>AI can make mistakes.<\/strong> Verify version compatibility, code and operational advice against current official documentation.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Earlier SQL Server Analysis Services editions supported data mining algorithms for classification, regression, clustering, association discovery and time-series modelling.<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":true,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_hide_featured_image":false,"_jetpack_featured_image_duplicate_dismissed":0,"_jetpack_feature_clip_id":0,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[20,182],"tags":[466],"class_list":["post-78970","post","type-post","status-publish","format-standard","hentry","category-information-technology","category---blog","tag-sql-server","item-wrap"],"jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":78955,"url":"http:\/\/bangla.sitestree.com\/?p=78955","url_meta":{"origin":78970,"position":0},"title":"Historical SQL Server Analysis Services Data Mining Algorithms Explained","author":"Sayed","date":"November 10, 2026","format":false,"excerpt":"Classic SQL Server Analysis Services data mining offered clustering, classification, association, regression, and forecasting models. The algorithms are educationally valuable, but these exact SSAS features are no longer supported in current SQL Server releases.","rel":"","context":"In &quot;Information Technology&quot;","block_context":{"text":"Information Technology","link":"http:\/\/bangla.sitestree.com\/?cat=20"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":14810,"url":"http:\/\/bangla.sitestree.com\/?p=14810","url_meta":{"origin":78970,"position":1},"title":"SQL Server (SSAS): Data Mining: Data Science: Data Analytics: Prediction: Neural Networks : Linear\/Logistics Regression","author":"Sayed","date":"June 15, 2019","format":false,"excerpt":"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\u2026","rel":"","context":"In &quot;AI ML DS RL DL NN NLP Data Mining Optimization&quot;","block_context":{"text":"AI ML DS RL DL NN NLP Data Mining Optimization","link":"http:\/\/bangla.sitestree.com\/?cat=1910"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":23012,"url":"http:\/\/bangla.sitestree.com\/?p=23012","url_meta":{"origin":78970,"position":2},"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":78927,"url":"http:\/\/bangla.sitestree.com\/?p=78927","url_meta":{"origin":78970,"position":3},"title":"Data Mining with Excel and SQL Server: Legacy Tools and Modern Alternatives","author":"Sayed","date":"November 10, 2026","format":false,"excerpt":"Excel and SQL Server have been used together for extracting, cleaning, exploring, and modelling business data. It is important to distinguish current analytical workflows from historical SQL Server Analysis Services data","rel":"","context":"In &quot;Information Technology&quot;","block_context":{"text":"Information Technology","link":"http:\/\/bangla.sitestree.com\/?cat=20"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":78217,"url":"http:\/\/bangla.sitestree.com\/?p=78217","url_meta":{"origin":78970,"position":4},"title":"Model Selection","author":"Sayed","date":"May 21, 2025","format":false,"excerpt":"\u2022 Optimizations\/Machine Learning\/Data Mining\/Deep Learning\/Reinforcement Learning\/Graph Mining\/NLP\/Genetic Algorithms \u2022 Regression \u2022 Linear \u2022 Non-Linear \u2022 Classifications \u2022 Logistics Regression \u2022 Sigmoid : Binary \u2022 Softmax: Multi-Class \u2022 Bayes Classifier \u2022 SVM \u2022 Bayesian: Regression\/Classification \u2022 Clustering \u2022 K-NN \u2022 KNN+ \u2022 Kmeans, Hierarchical, Density \u2022Machine Learning\/Data Mining\/Deep Learning\/Reinforcement Learning\/Graph Mining\/NLP\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":"","width":0,"height":0},"classes":[]},{"id":78210,"url":"http:\/\/bangla.sitestree.com\/?p=78210","url_meta":{"origin":78970,"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":[]}],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/78970","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=78970"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/78970\/revisions"}],"predecessor-version":[{"id":79032,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/78970\/revisions\/79032"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=78970"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=78970"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=78970"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}