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
What You Will Learn
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.
Requirements
Make sure that the following are installed:
- Microsoft SQL Server 2005
- Microsoft SQL Server 2005 Analysis Services (SSAS)
- SQL Server 2005 with the AdventureWorks database. By default, the sample databases are not installed, to enhance security. For information about how to install the sample databases, see Running Setup to Install AdventureWorks Sample Databases and Samples.
Note
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.
See Also
Other Resources
Data Mining Concepts
Working with Data Mining How-to Topics
Working with Data Mining