Browse a Model Using the Microsoft Neural Network Viewer

Applies to: SQL Server 2019 and earlier Analysis Services Azure Analysis Services Fabric/Power BI Premium

Important

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.

The Microsoft Neural Network Viewer in Microsoft SQL Server SQL Server Analysis Services displays mining models that are built with the Microsoft Neural Network algorithm. The Microsoft Neural Network algorithm creates classification and regression mining models that can analyze multiple inputs and outputs, and is very useful for open-ended analyses and exploration. For more information about this algorithm, see Microsoft Neural Network Algorithm.

When you explore a model using the Microsoft Neural Network Viewer, you typically pick some target attribute and state, and then use the viewer to see how input attributes affect the outcome

For example, suppose you know these facts about a class of potential customers:

  • Middle aged (40 to 50 years old).

  • Owns a home.

  • Has two children who still live at home.

How can you correlate these attributes with the likelihood that the customer will make a purchase?

By building a neural network model using purchasing behavior as the target outcome, you can explore multiple combinations on customer attributes, such as high income, and discover which combination of attributes is most likely to influence purchasing behavior. For example, you might discover that the determining factor is the distance that they commute to work.

If you need to more view detailed information, such as the equations that represent each pattern that was discovered, you can switch views and use the Microsoft Generic Content Tree viewer. For more information, see Browse a Model Using the Microsoft Generic Content Tree Viewer or Microsoft Generic Content Tree Viewer (Data Mining).

Viewer Tabs

When you browse a mining model in SQL Server Analysis Services, the model is displayed on the Mining Model Viewer tab of Data Mining Designer in the appropriate viewer for the model. The Microsoft Neural Network Viewer provides the following tabs for use in exploring neural network mining models:

Inputs

Use the Inputs tab to choose the attributes and values that the model used as inputs. By default, the viewer opens with all attributes included. In this default view, the model chooses which attribute values are the most important to display.

To select an input attribute, click inside the Attribute column of the Input grid, and select an attribute from the drop-down list. (Only attributes that are included in the model are included in the list.)

The first distinct value appears under the Value column. Clicking the default value reveals a list that contains all the possible states of the associated attribute. You can select the state that you want to investigate. You can select as many attributes as you want.

Back to Top

Outputs

Use the Outputs tab to choose the outcome attribute to investigate. You can choose any two outcome states to compare, assuming the columns were defined as predictable attributes when the model was created.

Use the OutputAttribute list to select an attribute. You can then select two states that are associated with the attribute from the Value 1 and Value 2 lists. These two states of the output attribute will be compared in the Variables pane.

Back to Top

Variables

The grid in the Variables tab contains the following columns: Attribute, Value, Favors [value 1], and Favors [value 2]. By default, the columns are sorted by the strength of Favors [value 1]. Clicking a column heading changes the sort order to the selected column.

A bar to the right of the attribute shows which state of the output attribute the specified input attribute state favors. The size of the bar shows how strongly the output state favors the input state.

Back to Top

See Also

Microsoft Neural Network Algorithm
Mining Model Viewer Tasks and How-tos
Mining Model Viewer Tasks and How-tos
Data Mining Tools
Data Mining Model Viewers