Page 181 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence

Notes
Questions:
1. How Python made it possible for Journyx to produce a flexible, feature-rich product
for multiple platforms in less time?
2. Explain how Python becomes an important competitive advantage for Journyx
Timesheet (tm)?
Source: http://www.python.org/about/success/journyx/
12.4 Summary

The Data Mining Wizard in SQL Server Data Tools (SSDT) makes it very simple to create
mining structures and mining models, using either relational data or multidimensional
data in cubes.
The Data Mining Wizard in Microsoft SQL Server Analysis Services starts every time
when you add a new mining structure to a data mining project.
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.
The mining structure defines the data from which mining models are constructed: it
specifies the source data outlook, the number and kind of columns, and an optional partition
into training and testing groups.

You can change the parameters supplied with the algorithms that you use to construct data
mining models to customize the results of the model.
On the Mining Models tab of Data Mining Designer in SQL Server Data Tools (SSDT),
right-click the algorithm type and select Set Algorithm Parameters.

12.5 Keywords

Data Mining Extensions (DMX): Data Mining Extensions (DMX) is a language that you can use
to create and work with data mining models in Microsoft SQL Server Analysis Services.

Data Mining Wizard: The Data Mining Wizard in Microsoft SQL Server 2005 Analysis Services
(SSAS) starts every time that you add a new mining structure to a data mining project.
Mining structure: It defines the data from which mining models are constructed; it specifies the
source data outlook, the number and kind of columns, and an optional partition into training
and testing groups.

SQL Server Data Tools: SQL Server Data Tools (SSDT) transforms database development by
introducing a ubiquitous, declarative model that spans all the phases of database development
and maintenance/update inside Visual Studio.

12.6 Review Questions

1. What tools does Microsoft SQL Server Analysis Services provides to create data mining
solutions?

2. What is Data Mining Wizard? Discuss the process in starting the Data Mining Wizard.
3. What are the features of Data Mining Wizard?

176 LOVELY PROFESSIONAL UNIVERSITY