Microsoft SQL Server provides an integrated environment for creating and working with data mining models. This tutorial walks you through scenarios for targeted mailing, forecasting, market basket analysis, and sequence clustering, to demonstrate how to use the data mining algorithms, mining model viewers, and data mining tools that are included in Microsoft SQL Server 2005 Analysis Services (SSAS).
For More Information
Data Mining Concepts, Using the Data Mining Tools, Working with Data Mining
This tutorial teaches you how to create and work with several different types of data mining models.
This tutorial is divided into the following lessons:
-
Lesson 1: Preparing the Analysis Services Database
-
In this lesson, you will learn how to create a new Analysis Services database, add a data source and data source view, and prepare the new database to be used with data mining.
-
Lesson 2: Building a Targeted Mailing Scenario
-
In this lesson, you will learn how to create mining models that can be used as part of a targeted mailing scenario. You will also learn how to explore mining models, compare mining models, and create predictions from mining models that are built with the following algorithms:
-
Microsoft Decision Trees
-
Microsoft Clustering
-
Microsoft Naive Bayes
-
Lesson 3: Building the Forecasting Scenario
-
In this lesson, you will learn how to create a mining model that can be used as part of a forecasting scenario. You will also learn how to explore mining models that are built with the Microsoft Time Series algorithm.
-
Lesson 4: Building the Market Basket Scenario
-
In this lesson, you will learn how to create a mining model that can be used as part of a market basket scenario. You will also learn how to explore mining models that are built with the Microsoft Association algorithm.
-
Lesson 5: Building the Sequence Clustering Scenario
-
In this lesson, you will learn how to create a mining model that can be used as part of a sequence clustering scenario. You will also learn how to explore mining models that are built with the Microsoft Sequence Clustering algorithm.
Make sure that the following are installed:
Other Resources
Data Mining Concepts
Working with Data Mining How-to Topics
Working with Data Mining
Help and Information
Getting SQL Server 2005 Assistance