Browsing Models in Excel (SQL Server Data Mining Add-ins)
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).
.gif "Browse Model button in Data Mining ribbon")
Visually exploring the model is usually the fastest and easiest way to get an understanding of the rules and relationships discovered by analysis. By using the Data Mining Client for Excel, you can browse both temporary models created during the current Excel session, and models stored in an instance of Analysis Services.
To browse a model, you select a model and its associated structure from a list of available models, and the add-in automatically picks the viewer that is appropriate for that data mining algorithm. You can drill into the most interesting trends, filter the completed data mining model, and copy graphs and data to Excel or to Visio.
Using the Browse Model Wizard
Click the Data Mining tab.
In the Model Usage group, click Browse.
In the Select Model dialog box, choose a mining model from the list, and click Next.
The wizard opens a Browse window that is appropriate for the type of model that you selected.
List of Data Mining Viewers
Depending on the data mining algorithm that you used when you created the model, the Browse window will look a bit different. It can include graphs to help interpret the results, legends that contain additional detail, and controls for interacting with the data.
The following topics provide guidance in how to use each of the viewers, including tips on interpreting the complex graphs, and how to change, copy, or work with the results.
Browsing an Association Rules Model
Browsing a Decision Trees Model
Browsing a Neural Network Model