Data Mining with SQL Server SSAS Purchase the entire course

23 December 2016 · 12462 views

Loading the video player...

If this message stays on please ensure you are using a supported browser with JavaScript enabled.

See our device support page.

Watch 1-min Overview

Learn Data Mining with SQL Server Analysis Services from Rafal who has been using it professionally for well over a decade until its recent deprecation. 9 modules with 8 hours of in-depth learning, jam-packed with detailed demos. You will study: Cases, Models, Mining Algorithms, Model Training, Holdout, Testing Model Validity, Predictive Use and Model Scoring, Decision Trees, Clustering, Association Rules, Market Basket Analysis, and more.

We focus on the older but fast, easy-to-use, and highly visual Data Mining components of SQL Server Analysis Services Multidimensional and Data Mining. Whilst it has been deprecated in SQL Server 2017 and 2019 it is still available in those editions. If you are planning on learning data mining, you may find it quite useful, because it is simpler and more visual than its successors, the Machine Learning Services in SQL Server 2017 and 2019. However, if you are thinking of using it in production, you would be well advised to continue your learning path using the newer technologies.

Four videos, Introduction to Data Mining, What Are Decision Trees, Why Cluster and Segment Data, and What is Market Basket Analysis? are free. The remaining ones require a subscription, which will also give you access to download our educational data set, Happy Cars, so that you can practice the demos on your own.

You can obtain SQL Server Developer Edition at no cost from the free Microsoft Visual Studio Dev Essentials programme. You will also need a current version of the free SQL Server Data Tools that includes the SQL Server Analysis Services project templates. It uses the Visual Studio Community (or paid) Edition and version 2017 works well (so do the older)—get it from the Dev Essentials programme, too.

Course content

  • Introduction to Data Mining with Microsoft SQL Server 24-min Watch with Free Subscription

  • Data Mining Concepts and Tools 50-min

  • Data Mining Model Building, Testing and Predicting with Microsoft SQL Server and Excel 1-hour 20-min

  • What Are Decision Trees? 10-min Free—Watch Now

  • Decision Trees in Depth 1-hour 54-min

  • Why Cluster and Segment Data? 9-min Watch with Free Subscription

  • Clustering in Depth 1-hour 50-min

  • What is Market Basket Analysis? 10-min Watch with Free Subscription

  • Association Rules in Depth 1-hour 35-min

  • HappyCars Sample Data Set for Learning Data Mining

  • Additional Code and Data Samples (R, ML Services, SSAS) Get with Free Subscription

Purchase a Full Access Subscription

Individual Subscription


Access all content on this site for 1 year.
Group Purchase

from $480/year

For small business & enterprise.
Group Purchase
  • You can also redeem a prepaid code.
  • Payments are instant and you will receive a tax invoice straight away.
  • We offer sales quotes/pro-forma invoices, and we accept purchase orders and bank transfers.
  • Your satisfaction is paramount: we offer a no-quibble refund guarantee.
  • See pricing FAQ for more detail.
In collaboration with
Project Botticelli logo Oxford Computer Training logo SQLBI logo Prodata logo