• Article

Hands On Lab: Building Your First Data Mining Model with SQL Server 2008 R2 Analysis Services

Version: 1.0

Description

This Hands On Lab will show you how to build your first data mining model with SQL Server 2008 R2 Analysis Services to identify patterns showing which products are commonly purchased together.

Overview

This lab will create a data mining model that uses the Microsoft Association Rules algorithm to identify patterns about models commonly purchased together. The data mining model will be used to provide relevant purchasing suggestions to online customers.

Objectives

The objectives of this exercise are to:

  • Create a data source view
  • Create a Microsoft Association Rules data mining model
  • View the mining model content
  • Query the mining model
  • Embed the mining model query results into a Web application

System Requirements

You must have installed the following items to complete this lab:

  • Microsoft SQL Server 2008 R2:
    • Database Engine
    • Analysis Services
    • SQL Server Business Intelligence Development Studio
  • SQL Server AdventureWorks2008 R2 sample databases
    • AdventureWorks2008R2
    • AdventureWorksDW2008R2
  • Microsoft Visual Studio 2010 SP1
    • Visual Basic
    • Visual Web Developer

Setup

All the requisites for this lab are verified using the Configuration Wizard. To make sure that everything is correctly configured, follow these steps.

Note:
To perform the setup steps you need to run the scripts in a command window with administrator privileges.

  1. Launch the Configuration Wizard for this lab by double-clicking the Dependencies.dep file located under the Source\Setup folder of this lab. Install any pre-requisites that are missing (rescanning if necessary) and complete the wizard.

Cleanup

  1. There is no need to cleanup if you intend to continue the sequence of labs in this training kit.
  2. To restore the original state of the AdventureWorks2008R2 and AdventureWorksDW2008R2 SQL Server databases and remove the Sales Analysis Analysis Services database, execute the Cleanup.cmd script located under the Setup folder in the Source folder of this lab.

Exercises

This Hands-On Lab comprises the following exercise:

  1. Embedding Data Mining Results Into a Custom Application

Estimated time to complete this lab: 30 minutes.

next >

Downloads

Download The Offline Training Kit
Download Hands-on Lab Document (DOCX)
Download Hands-on Lab Source Files

Contents