Page 171 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence Sartaj Singh, Lovely Professional University

Notes Unit 12: Understanding Data Mining Tools

CONTENTS
Objectives

Introduction
12.1 Data Mining Tools in SQL Server

12.1.1 Data Mining Wizard
12.1.2 Data Mining Designer
12.1.3 SQL Server Management Studio

12.1.4 Integration Services Data Mining Tasks and Transformations
12.2 Mining Structure
12.2.1 Defining a Mining Structure

12.3 Configuring Algorithm Parameters
12.3.1 Change an Algorithm Parameter
12.3.2 View the Parameters

12.4 Summary
12.5 Keywords

12.6 Review Questions
12.7 Further Readings

Objectives

After studying this unit, you will be able to:

Identify the data mining tools in SQL server
Discuss about the mining structure
Explain the configuring algorithm parameters

Introduction

Data mining is the process of analysing data from different perspectives and summarizing it
into useful information. This information can be used to increase revenue, cuts costs, or both.
Data mining software analyses relationships and patterns in stored transaction data depending
on the open-ended user queries. In this Unit, you will learn about data mining tools. Data
mining tools in SQL server will be discussed. Also the unit covers mining structure and models
of mining structure. Finally, configuration algorithm parameters will be defined.

12.1 Data Mining Tools in SQL Server

Microsoft SQL Server Analysis Services provides the following tools to create data mining
solutions:

166 LOVELY PROFESSIONAL UNIVERSITY