Data Mining Model Viewers
Applies to: SQL Server 2019 and earlier Analysis Services Azure Analysis Services Power BI Premium
Data mining was deprecated in SQL Server 2017 Analysis Services and now discontinued in SQL Server 2022 Analysis Services. Documentation is not updated for deprecated and discontinued features. To learn more, see Analysis Services backward compatibility.
After you train a data mining model in Microsoft SQL Server 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, SQL Server Analysis Services provides a separate viewer for each algorithm. When you browse a mining model in SQL Server Data Tools, the model is displayed on the Mining Model Viewer tab of Data Mining Designer, using the appropriate viewer for the model.
How to Use the Model Viewers
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.
More about the Microsoft Generic Content Tree Viewer
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 SQL Server 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).
In This Section
The following topics describe in more detail each of the viewers, and how to interpret the information in them.
Browse a Model Using the Microsoft Tree Viewer
Describes the Microsoft Tree Viewer. This viewer displays mining models that are built with the Microsoft Decision Trees algorithm and the Microsoft Linear Regression algorithm.
Browse a Model Using the Microsoft Cluster Viewer
Describes the Microsoft Cluster Viewer. This viewer displays mining models that are built with the Microsoft Clustering algorithm.
Browse a Model Using the Microsoft Time Series Viewer
Describes the Microsoft Time Series Viewer. This viewer displays mining models that are built with the Microsoft Time Series algorithm.
Browse a Model Using the Microsoft Naive Bayes Viewer
Describes the Microsoft Naive Bayes viewer. This viewer displays mining models that are built with the Microsoft Naive Bayes algorithm.
Browse a Model Using the Microsoft Sequence Cluster Viewer
Describes the Microsoft Sequence Cluster Viewer. This viewer displays mining models that are built with the Microsoft Sequence Clustering algorithm.
Browse a Model Using the Microsoft Association Rules Viewer
Describes the Microsoft Association Rules Viewer. This viewer displays mining models that are built with the Microsoft Association algorithm.
Browse a Model Using the Microsoft Neural Network Viewer
Describes the Microsoft Neural Network Viewer. This viewer displays mining models that are built with the Microsoft Neural Network algorithm, including models that use the Microsoft Logistic Regression algorithm.
Browse a Model Using the Microsoft Generic Content Tree Viewer
Describes the detailed information that is available in the generic viewer for all data mining models and provides examples of how to interpret the information for each algorithm.