Lesson 4: Exploring the Targeted Mailing Models (Basic Data Mining Tutorial)


Applies To: SQL Server 2016 Preview

After the models in your project have been processed, you can explore them to look for interesting trends. Because patterns can be complex and difficult simply by looking at numbers, SQL Server Data Mining provides some visual tools that help you investigate the data and understand the rules and relationships that the algorithms have discovered within the data. You can also use a variety of accuracy tests to validate your dataset or discover which model performs best before you deploy it.

When you use SQL Server Data Tools (SSDT) to explore your models, each model you created is listed in the Mining Model Viewer tab in Data Mining Designer. You can use the viewers to explore the models. These viewers are also available in SQL Server Management Studio.

Each algorithm that you used to build a model in Analysis Services returns a different type of result. Therefore, Analysis Services provides custom viewers for each type of machine learning model.

If you want to get into details, Analysis Services also provides an HTML viewer, called the Generic Content Tree Viewer, that displays detailed information about the model data and any patterns that were found, in a semi-tabular format. For more information, see Browse a Model Using the Microsoft Generic Content Tree Viewer.

In this lesson you will look at the results from your three models. Each model type is based on a different algorithm and provides different insights into the data.

  • The Decision Tree model tells you about factors that influence bike buying.

  • The Clustering model groups your customers by attributes that include their bike buying behavior and other selected attributes.

  • The Naive Bayes model enables you to explore the relationship between different attributes.

See the following topics to learn more about each of the mining model viewers.

All three models can be viewed using the Generic Content Tree Viewer, to extract formulas, data values, and so forth.

First Task in Lesson

Exploring the Decision Tree Model (Basic Data Mining Tutorial)

Previous Lesson

Lesson 3: Adding and Processing Models

Next Lesson

Lesson 5: Testing Models (Basic Data Mining Tutorial)

See Also

Mining Model Viewer Tasks and How-tos
Data Mining Model Viewers