• Article

Data Mining Tutorials and How-to Topics

To get started with data mining, use the following tutorials and how-to topics. Microsoft SQL Server provides an integrated environment for creating and working with data mining models that includes both graphical design tools and dialog boxes, and a scripting language for both development and querying.

  • You can create, explore, and query data mining models in a graphical design environment by using Data Mining Designer, in Business Intelligence Development Studio.

  • If you are already familiar with data mining concepts and want to rapidly create and query data mining objects, you can use Data Mining Extensions (DMX).

BI Dev Studio Data Mining Tutorials

Basic Data Mining Tutorial

In this tutorial, you learn how to create an Analysis Services project and prepare the data needed for data mining. You also learn how to create several data mining models.

Intermediate Data Mining Tutorials (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.

DMX Data Mining 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 new models and customize the time series algorithm for each model. Finally, you add new data to the model and create new forecasts based on the updated data.

How-To Topics

Data Mining Designer How-to Topics (Analysis Services - Data Mining)

This section provides task-specific procedures for working with Data Mining Designer in BI Dev Studio, such as

Querying Data Mining Models: How-to Topics (Analysis Services - Data Mining)

This section provides procedures that describe how to create specific kinds of DMX queries, configure the properties of data mining objects, use XML/A for queries, and so forth.

Defining Data Sources with Business Intelligence Development Studio (Analysis Services)

This section provides detailed information about how to set up data sources for use in data mining.

Defining Data Source Views with Business Intelligence Development Studio (Analysis Services)

This section provides detailed information about how to create and customize data source by creating named calculations, custom queries, and so forth.