Export (0) Print
Expand All
9 out of 29 rated this helpful - Rate this topic

Data Mining Tutorial

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:

ms167167.note(en-US,SQL.90).gifNote:
When you review tutorials, we recommend that you add Next topic and Previous topic buttons to the document viewer toolbar. For more information, see Adding Next and Previous Buttons to Help.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.