Page 174 - DCAP606_BUSINESS_INTELLIGENCE

Unit 12: Understanding Data Mining Tools

Create propositions and content queries against existing mining models. Build one-off Notes
queries, or set up queries to develop propositions for whole benches of external data.

12.1.3 SQL Server Management Studio

After you create and deploy mining forms to a server, you can use SQL Server administration
Studio to organise the Analysis Services database that hosts the data mining items. You can also
continue to continue jobs that use the model, such as exploring the models, processing new data,
and creating propositions.

Notes Management Studio also comprises query editors that you can use to design and
execute Data Mining Extensions (DMX) queries.

12.1.4 Integration Services Data Mining Tasks and Transformations

SQL Server Integration Services provides many components that support data mining.
Some tools in Integration Services are designed to help automate common data mining tasks
such as prediction, model building, and processing.

Example:

Create an Integration Services package that automatically updates the model every
time the addition of new customers updates the dataset.
Perform custom sampling of case records.

Generate models passed on parameters automatically.
You can also use data mining in a package workflow, as an input to other processes.

Example:

To weight score for text mining use probability values generated by the model.
Automatically generate predictions based on prior data and use those values to
assess the validity of new data.

To segment incoming customers by risk use logistic regression.
Self Assessment

Fill in the blanks:
1. Model viewers are supplied in both SQL Server administrations Studio and
..................................................
2. The .................................. is provided in both SQL Server administrations Studio and SQL
Server Data Tools (SSDT)

3. The ................................. in Microsoft SQL Server Analysis Services starts every time when
you add a new mining structure to a data mining project.
4. .................................... Services provides many components that support data mining.

LOVELY PROFESSIONAL UNIVERSITY 169