Data Mining Tools

Microsoft SQL Server Analysis Services provides the following tools that you can use to create data mining solutions:

The Data Mining Wizard in SQL Server Data Tools (SSDT) makes it easy to create mining structures and mining models, using either relational data sources or multidimensional data in cubes.

In the wizard, you choose data to use, and then apply specific data mining techniques, such as clustering, neural networks, or time series modeling.

Model viewers are provided in both SQL Server Management Studio and SQL Server Data Tools (SSDT), for exploring your mining models after they are created. You can browse models using viewers tailored to each algorithm, or go deeper into analysis by using the model content viewer.

The Prediction Query Builder is provided in both SQL Server Management Studio and SQL Server Data Tools (SSDT) to help you create prediction queries. You can also test the accuracy of models against a holdout data set or external data, or use cross-validation to assess the quality of your data set.

SQL Server Management Studio is the interface where you manage existing data mining solutions that have been deployed to an instance of Analysis Services. You can reprocess structures and models to update the data in them.

SQL Server Integration Services contains tools that you can use to clean data, to automate tasks such as creating predictions and updating models, and to create text mining solutions.

The following sections provide more information about the data mining tools in SQL Server.

Use the Data Mining Wizard to get started creating data mining solutions. The wizard is quick and easy, and guides you through the process of creating a data mining structure and an initial related mining model, and includes the tasks of selecting an algorithm type and a data source, and defining the case data used for analysis.

After you have created a mining structure and mining model by using the Data Mining Wizard, you can use the Data Mining Designer from either SQL Server Data Tools (SSDT) or SQL Server Management Studio to work with existing models and structures.

After you create and deploy mining models to a server, you can use SQL Server Management Studio to manage the Analysis Services database that hosts the data mining objects. You can also continue to perform tasks that use the model, such as exploring the models, processing new data, and creating predictions.

Management Studio also contains query editors that you can use to design and execute Data Mining Extensions (DMX) queries, or ot work with data mining objects by using XMLA.