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
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.
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.
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.
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.
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.
This section provides task-specific procedures for working with Data Mining Designer in BI Dev Studio, such as
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.
This section provides detailed information about how to set up data sources for use in data mining.
This section provides detailed information about how to create and customize data source by creating named calculations, custom queries, and so forth.