Data Mining Tutorials (Analysis Services)


Microsoft SQL Server Analysis Services makes it easy to create sophisticated data mining solutions. The tools in Analysis Services help you design, create, and manage data mining models that use either relational or cube data. You can manage client access to data mining models and create prediction queries from multiple clients.

The step-by-step tutorials in the following list will help you learn how to get the most out of Analysis Services, so that you can perform advanced analysis to solve business problems that are beyond the reach of traditional business intelligence methods.

  • Basic Data Mining Tutorial

    This tutorial walks you through a targeted mailing scenario. It demonstrates how to use the data mining algorithms, mining model viewers, and data mining tools that are included in Analysis Services. You will build three data mining models to answer practical business questions while learning data mining concepts and tools.

  • Intermediate Data Mining Tutorial (Analysis Services - Data Mining)

    This tutorial contains a collection of lessons that introduce more advanced data mining concepts and techniques. The scenarios include these model types:

    • forecasting

    • market basket analysis

    • neural networks and logistic regression

    • sequence clustering

    The lessons are independent and can be done in any order, but you should have a basic knowledge of how to build data sources.

    Advanced concepts covered in these lessons include the use of nested tables, cross-prediction, custom data source views and named queries, and filtering in data mining queries. You will also gain proficiency in using the prediction query tools that are included in Analysis Services.

Data Mining Algorithms (Analysis Services - Data Mining)

Data Mining Extensions (DMX) Reference

Data Mining Tools

Logical Architecture (Analysis Services - Data Mining)

Logical Architecture (Analysis Services - Multidimensional Data)

Data Mining Projects

Data Mining Solutions
Microsoft SQL Server Data Mining resources
Creating and Querying Data Mining Models with DMX: Tutorials (Analysis Services - Data Mining)