Data Mining Model Viewers
Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
After you train a data mining model in Microsoft SQL Server Analysis Services, you can explore the model to look for interesting trends. Because the results of mining models are complex and can be difficult to understand in a raw format, visually investigating the data is often the easiest way to understand the rules and relationships that algorithms discover within the data.
Each algorithm that you use to build a model returns a different type of results. Therefore, Analysis Services provides a separate viewer for each algorithm. When you browse a mining model in SQL Server Data Tools (SSDT), the model is displayed on the Mining Model Viewer tab of Data Mining Designer, using the appropriate viewer for the model.
First you select the mining model and then you select a viewer. Each model always has two viewers available: a custom viewer, which can include multiple tabs, and the generic viewer.
Depending on the type of the model that you selected, you will see very different options for exploring the model. The custom viewers associated with each model type are tailored to the algorithm that you used to create the selected data mining model. Each custom viewer has a variety of tools and dialog boxes for helping you explore the statistics and patterns in the model, view charts, or interactively work with probability thresholds or filter out items by name.
The following diagram illustrates the difference when you choose a custom viewer and the generic viewer for the same model.
First, you see the custom viewer that is displayed when you select a mining model based on the Microsoft Time Series algorithm.
This particular custom viewer automatically creates a graph of the time series and provides five predictions.
Next, you see the same model, displayed using the Microsoft Generic Content Tree Viewer.
On the left, the generic viewer displays a list of the nodes in the model. You can click a node to view its contents in the right-hand pane.
Each model can also be viewed using the Microsoft Generic Content Tree Viewer (Data Mining). This viewer presents the contents of the mining model according to a standard HTML table format. However, the arrangement of the nodes and the content of each node will differ greatly depending on the algorithm used to generate the results.
Whereas the custom viewers are designed for exploring and understanding the model, the generic viewer is more useful when you already understand the model and want to extract statistics or rules from a specific node. For example, you would use the generic viewer when you want to view detailed information about the patterns and statistics that Analysis Services captured during analysis, such as the probability of a node, or a regression formula.
You can also write content queries using DMX to get all of the information that is presented in this viewer. For more information, see Content Queries (Data Mining).