{"id":78973,"date":"2026-11-10T19:53:07","date_gmt":"2026-11-10T19:53:07","guid":{"rendered":"http:\/\/bangla.sitestree.com\/?p=78973"},"modified":"2026-11-10T19:57:11","modified_gmt":"2026-11-10T19:57:11","slug":"rewritten-sql-server-6213","status":"publish","type":"post","link":"http:\/\/bangla.sitestree.com\/?p=78973","title":{"rendered":"\u098f\u0995\u09cd\u09b8\u09c7\u09b2 \u0993 SQL Server \u09a6\u09bf\u09df\u09c7 Data Analysis: Legacy Data Mining and Modern Workflow"},"content":{"rendered":"

Excel and SQL Server can be combined to inspect business data, transform it, and prepare features for analysis. \u09aa\u09c1\u09b0\u09cb\u09a8\u09cb SQL Server Data Mining \u099f\u09c1\u09b2\u09c7\u09b0 \u09b8\u0999\u09cd\u0997\u09c7 \u0986\u09a7\u09c1\u09a8\u09bf\u0995 \u09ac\u09bf\u09b6\u09cd\u09b2\u09c7\u09b7\u09a3 \u09aa\u09a6\u09cd\u09a7\u09a4\u09bf\u09b0 \u09aa\u09be\u09b0\u09cd\u09a5\u0995\u09cd\u09af \u09ac\u09cb\u099d\u09be \u099c\u09b0\u09c1\u09b0\u09bf\u0964<\/p>\n

Concept and purpose<\/h2>\n

A typical pipeline starts with SQL queries that join and clean data; Excel pivot tables help explore totals and categories; modern machine-learning tools can train predictive models from governed extracts.<\/p>\n

Example or practical exercise<\/h2>\n

For an order dataset, calculate total order value, number of purchases, and last-purchase date per customer. Export the results to a protected spreadsheet and verify that totals match the database before modelling.<\/p>\n

Good practices<\/h2>\n

Document business definitions and missing-value handling. Avoid evaluating a predictive model only on its training examples. Use a separate test set, especially for temporal data.<\/p>\n

Version and compatibility notes<\/h2>\n

SQL Server Analysis Services data mining was deprecated in SQL Server 2017 and discontinued in SQL Server 2022. Older Excel add-ins are historical, not a recommended current deployment.<\/p>\n\n

AI content disclosure:<\/strong> This article is AI-generated, based on an existing Open Education article (original post 6213)<\/a>. New explanations and examples may be included; it is not necessarily a transcript of any video linked in the original. You may reuse the generated text with or without attribution to this site. Third-party works and trademarks retain their rights. AI can make mistakes<\/strong>, so verify the details against official documentation and test before applying to real databases.<\/p>\n","protected":false},"excerpt":{"rendered":"

Excel and SQL Server can be combined to inspect business data, transform it, and prepare features for analysis. \u09aa\u09c1\u09b0\u09cb\u09a8\u09cb SQL Server Data Mining \u099f\u09c1\u09b2\u09c7\u09b0 \u09b8\u0999\u09cd\u0997\u09c7 \u0986\u09a7\u09c1\u09a8\u09bf\u0995 \u09ac\u09bf\u09b6\u09cd\u09b2\u09c7\u09b7\u09a3 \u09aa\u09a6\u09cd\u09a7\u09a4\u09bf\u09b0 \u09aa\u09be\u09b0\u09cd\u09a5\u0995\u09cd\u09af \u09ac\u09cb\u099d\u09be \u099c\u09b0\u09c1\u09b0\u09bf\u0964<\/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-78973","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":78968,"url":"http:\/\/bangla.sitestree.com\/?p=78968","url_meta":{"origin":78973,"position":0},"title":"Excel and SQL Server Data Mining: A Historical Workflow and Current Alternatives","author":"Sayed","date":"November 10, 2026","format":false,"excerpt":"Excel and SQL Server can work together to inspect and prepare datasets. Some older tutorials used the former SQL Server Analysis Services data-mining features and Excel add-ins.","rel":"","context":"In "Information Technology"","block_context":{"text":"Information Technology","link":"http:\/\/bangla.sitestree.com\/?cat=20"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":78970,"url":"http:\/\/bangla.sitestree.com\/?p=78970","url_meta":{"origin":78973,"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 "Information Technology"","block_context":{"text":"Information Technology","link":"http:\/\/bangla.sitestree.com\/?cat=20"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":78927,"url":"http:\/\/bangla.sitestree.com\/?p=78927","url_meta":{"origin":78973,"position":2},"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 "Information Technology"","block_context":{"text":"Information Technology","link":"http:\/\/bangla.sitestree.com\/?cat=20"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":78955,"url":"http:\/\/bangla.sitestree.com\/?p=78955","url_meta":{"origin":78973,"position":3},"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 "Information Technology"","block_context":{"text":"Information Technology","link":"http:\/\/bangla.sitestree.com\/?cat=20"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":22243,"url":"http:\/\/bangla.sitestree.com\/?p=22243","url_meta":{"origin":78973,"position":4},"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 "FromSitesTree.com"","block_context":{"text":"FromSitesTree.com","link":"http:\/\/bangla.sitestree.com\/?cat=1917"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":14810,"url":"http:\/\/bangla.sitestree.com\/?p=14810","url_meta":{"origin":78973,"position":5},"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 "AI ML DS RL DL NN NLP Data Mining Optimization"","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\/78973","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=78973"}],"version-history":[{"count":1,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/78973\/revisions"}],"predecessor-version":[{"id":79035,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=\/wp\/v2\/posts\/78973\/revisions\/79035"}],"wp:attachment":[{"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=78973"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=78973"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bangla.sitestree.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=78973"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}