{"id":78955,"date":"2026-11-10T19:47:09","date_gmt":"2026-11-10T19:47:09","guid":{"rendered":"http:\/\/bangla.sitestree.com\/?p=78955"},"modified":"2026-11-10T19:56:28","modified_gmt":"2026-11-10T19:56:28","slug":"rewritten-sql-server-23012","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=78955","title":{"rendered":"Historical SQL Server Analysis Services Data Mining Algorithms Explained"},"content":{"rendered":"<p>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.<\/p>\n<h2>Algorithm families<\/h2>\n<p>Association rules discover co-occurrence patterns. Clustering identifies groups with similar characteristics. Decision trees and Naive Bayes classify records; regression estimates numerical or categorical outcomes; time-series methods model trends.<\/p>\n<h2>Historic SSAS algorithms<\/h2>\n<p>Microsoft&#8217;s former data-mining feature set included Association, Clustering, Decision Trees, Linear Regression, Logistic Regression, Naive Bayes, Neural Network, Sequence Clustering, and Time Series algorithms.<\/p>\n<h2>Compatibility warning<\/h2>\n<p>Microsoft states SSAS data mining was deprecated in SQL Server 2017 and discontinued in SQL Server 2022. Treat older DMX, plug-in, and Excel add-in walkthroughs as historical learning material rather than current installation instructions.<\/p>\n<h2>Modern alternatives<\/h2>\n<p>Extract curated training datasets with T-SQL and use maintained machine-learning libraries or supported analytical services. Validate performance with appropriate train\/validation\/test splits, leakage checks, and monitoring.<\/p>\n<hr\/>\n<p><strong>AI content and reuse notice:<\/strong> Written using AI based on <a href=\"https:\/\/bangla.sitestree.com\/?p=23012\">this site&#8217;s earlier post (23012)<\/a>, with added explanations and examples. The newly generated text may be reused, edited, or republished with or without attribution. Third-party works and trademarks remain subject to their own rights. <strong>AI can make mistakes.<\/strong> Check all code, version-specific features, and operational decisions against current vendor documentation before production use.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>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.<\/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-78955","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":14810,"url":"http:\/\/bangla.sitestree.com\/?p=14810","url_meta":{"origin":78955,"position":0},"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":78970,"url":"http:\/\/bangla.sitestree.com\/?p=78970","url_meta":{"origin":78955,"position":1},"title":"SQL Server Analysis Services Data Mining Algorithms: Historical Survey","author":"Sayed","date":"November 10, 2026","format":false,"excerpt":"Earlier SQL Server Analysis Services editions supported data mining algorithms for classification, regression, clustering, association discovery and time-series modelling.","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":23012,"url":"http:\/\/bangla.sitestree.com\/?p=23012","url_meta":{"origin":78955,"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":78217,"url":"http:\/\/bangla.sitestree.com\/?p=78217","url_meta":{"origin":78955,"position":3},"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":78927,"url":"http:\/\/bangla.sitestree.com\/?p=78927","url_meta":{"origin":78955,"position":4},"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":14889,"url":"http:\/\/bangla.sitestree.com\/?p=14889","url_meta":{"origin":78955,"position":5},"title":"Prediction: Bayesian: Regression: Concepts\/Example Projects","author":"Sayed","date":"July 7, 2019","format":false,"excerpt":"Insurance HealthCare Costs: https:\/\/github.com\/techshot25\/HealthCare Linear and Bayesian modeling in R: Predicting movie popularity https:\/\/towardsdatascience.com\/linear-and-bayesian-modelling-in-r-predicting-movie-popularity-6c8ef0a44184 Bayesian-Stock-Price-Prediction https:\/\/github.com\/lschlessinger1\/Bayesian-Stock-Price-Prediction Bayesian Prediction: Well (Oil) Production https:\/\/github.com\/jpgrana\/bayesian-approach-predicting-well-production Binary Classification on Stock Market (S&P 500) using Naive Bayes and Logistic Regression https:\/\/github.com\/NeilPrabhu\/Stock-Prediction Naive Bayes Weather Prediction https:\/\/github.com\/husnainfareed\/simple-naive-bayes-weather-prediction\/blob\/master\/bayes.py Regression Predict Fuel Efficiency: https:\/\/www.tensorflow.org\/tutorials\/keras\/basic_regression Regression-Example-Predicting-House-Prices https:\/\/github.com\/andersy005\/deep-learning\/blob\/master\/keras\/04-A-Regression-Example-Predicting-House-Prices.ipynb Stock Price\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":[]}],"jetpack_featured_media_url":"","_links":{"self":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/78955","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=78955"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/78955\/revisions"}],"predecessor-version":[{"id":79017,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/78955\/revisions\/79017"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=78955"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=78955"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=78955"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}