How Do I Find Tutorials (Analysis Services - Data Mining)

Microsoft SQL Server provides an integrated environment for you to create and work with data mining models. 

In addition to reviewing SQL Server Analysis Services tutorials that are specific to data mining and multidimensional data, you may find it valuable to review the tutorials for SQL Server Reporting Services and SQL Server Integration Services. Reporting Services enables you to publish the results of your analyses. Integration Services provides a variety of tools for integrating data mining with your OLTP database or your data warehouse.

Data Mining Tutorials

Basic Data Mining Tutorial

In this tutorial, you learn how to create an Analysis Services project and prepare the data required for data mining. You also learn how to create several data mining models. You learn to explore the models, understand the patterns in the model content, and test model accuracy using charts. You create a related mining model based on filtered data, and then create predictions using the models.

Intermediate Data Mining Tutorial (Analysis Services - Data Mining)

This tutorial contains a collection of independent lessons, each introducing a different type of algorithm. Each lesson walks you through a business scenario that is suited to data mining, and to the use of that particular algorithm.

You learn how to create a specific type of model, explore each model in detail to better understand the insights that the data mining model provides in the business scenario, and then build custom prediction queries. For some models, you also learn to use nested tables or work with custom data source views and named queries,

DMX Tutorials

In these tutorials, you learn how to create, train, and explore mining models by using the Data Mining Extensions (DMX) query language.

Bike Buyer DMX Tutorial

You create several mining models based on a single mining structure. You use these mining models to create predictions that determine whether a customer will purchase a bicycle.

Market Basket DMX Tutorial

In this tutorial, you learn how to create and train an association mining model that includes nested tables. You explore the mining model and then use it to create predictions that describe which products tend to be purchased at the same time.

Time Series Prediction DMX Tutorial

In this tutorial, you learn how to create a mining model and automatically generate its underlying mining structure by using the CREATE MODEL (DMX) statement. You then add models and customize the time series algorithm for each model. Finally, you add data to the model and create forecasts based on the updated data.

Analysis Services Tutorials

Adventure Works Sample Data Warehouse

The AdventureWorksDW2008R2 sample data warehouse is used in SQL Server Books Online to demonstrate the business intelligence features that are available in SQL Server. The data in the data warehouse has been designed to support both data mining and Online Analytical Processing (OLAP) scenarios.

Integration Services Tutorials

Designing and Implementing Packages Tutorials

Typical uses of Integration Services packages for data mining are to clean or stage data, or to update models and run prediction queries. In these tutorials, you will learn the necessary skills for using Integration Services packages to:

  • Create a basic data transfer package by using the SQL Server Import and Export Wizard.

  • Perform a lookup in a reference table, and write the data to a table in the AdventureWorksDW2008R2 sample database.

  • Deploy packages.

Reporting Services Tutorials

Tutorials (SSRS)

You can use the following tutorials to learn about ad hoc reporting features in Reporting Services. The tutorials can help you learn necessary skills for creating reports based on models.

Tutorial: Creating a Report Model Based on an Analysis Services Cube

In this tutorial, you will learn how to create an Analysis Services cube-based model using Report Manager and SQL Server Management Studio. For the purposes of this tutorial, you will create two report models based on an Analysis Services cube; however, you can follow these same steps, with the modifications noted, to create a model based on a SQL Server database.