This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 Association Rules Viewer in Microsoft SQL Server SQL Server Analysis Services displays mining models that are built with the Microsoft Association algorithm. The Microsoft Association algorithm is an association algorithm for use in creating data mining models that you can use for market basket analysis. For more information about this algorithm, see Microsoft Association Algorithm.
Following are the primary reasons for using the Microsoft Association algorithm:
To find itemsets that describe items that are typically found together in a transaction.
To discover rules that predict the presence of other items in a transaction based on existing items.
Note
To view detailed information about the equations used in the model and the patterns that were discovered, 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).
For a walkthrough of how to create, explore, and use an association mining model, see Lesson 3: Building a Market Basket Scenario (Intermediate Data Mining Tutorial).
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 Association Rules Viewer includes the following tabs:
Each tab contains the Show long name check box, which you can use to show or hide the table from which the itemset originates in the rule or itemset.
The Itemsets tab displays the list of itemsets that the model identified as frequently found together. The tab displays a grid with the following columns: Support, Size, and Itemset. For more information about support, see Microsoft Association Algorithm. The Size column displays the number of items in the itemset. The Itemset column displays the actual itemset that the model discovered. You can control the format of the itemset by using the Show list, which you can set to the following options:
Show attribute name and value
Show attribute value only
Show attribute name only
You can filter the number of itemsets that are displayed in the tab by using Minimum support and Minimum itemset size. You can limit the number of displayed itemsets even more by using Filter Itemset and entering an itemset characteristic that must exist. For example, if you type "Water Bottle = existing", you can limit the itemsets to only those that contain a water bottle. The Filter Itemset option also displays a list of the filters that you have used previously.
You can sort the rows in the grid by clicking a column heading.
The Rules tab displays the rules that the association algorithm discovered. The Rules tab includes a grid that contains the following columns: Probability, Importance, and Rule. The probability describes how likely the result of a rule is to occur. The importance is designed to measure the usefulness of a rule. Although the probability that a rule will occur may be high, the usefulness of the rule may in itself be unimportant. The importance column addresses this. For example, if every itemset contains a specific state of an attribute, a rule that predicts state is trivial, even though the probability is very high. The greater the importance, the more important the rule is.
You can use Minimum probability and Minimum importance to filter the rules, similar to the filtering you can do on the Itemsets tab. You can also use Filter Rule to filter a rule based on the states of the attributes that it contains.
You can sort the rows in the grid by clicking a column heading.
The Dependency Net tab includes a dependency network viewer. Each node in the viewer represents an item, such as "state = WA". The arrow between nodes represents the association between items. The direction of the arrow dictates the association between the items according to the rules that the algorithm discovered. For example, if the viewer contains three items, A, B, and C, and C is predicted by A and B, if you select node C, two arrows point toward node C - A to C and B to C.
The slider at the left of the viewer acts as a filter that is tied to the probability of the rules. Lowering the slider shows only the strongest links.
Microsoft Association Algorithm
Mining Model Viewer Tasks and How-tos
Mining Model Viewer Tasks and How-tos
Data Mining Tools
Data Mining Model Viewers
Training
Learning path
Get started with the Frequently bought together model - Training
Learn how to set up and use the Frequently bought together model in Microsoft Fabric, and explore some of its features.
Certification
Microsoft Certified: Power BI Data Analyst Associate - Certifications
Demonstrate methods and best practices that align with business and technical requirements for modeling, visualizing, and analyzing data with Microsoft Power BI.
Events
Apr 8, 3 PM - May 28, 7 AM
Sharpen your AI skills and enter the sweepstakes to win a free Certification exam
Register now!