Tutorials
MSAS
Tutorial 68: MSAS - Building a Relational Decision Tree Model
Tutorial 68: MSAS - Building a Relational Decision Tree Model - Page 2
Tutorial 68: MSAS - Building a Relational Decision Tree Model - Page 3
17. We can navigate the nodes and see the various attributes of the nodes until we have a pattern. Let us say we want to see if golden cards are held by persons who are in the higher income bracket. Let us focus on persons with $150K + salaries per annum. Double click on the node.
|
|
18. The node has two sub nodes: Persons who are married and persons who are not married.
|
|
19. There are further levels to the decision tree as indicated by the forked lines. Let us double click on persons who are married.
|
|
20. Under the married persons, persons not in USA node has further levels. Let us double click on that and examine the nodes.
|
|
21. Now we know that the number of persons having account numbers greater than a particular number or less than a particular number have golden membership but the percentage of such members is only 32.26%, Whereas the members who have an Account number greater than 42343243776 or >86 have 88.89% golden membership.


22. A pattern emerges. Persons having high income levels, who are married and not in USA and having an account number over a particular range have golden cards. Now we can examine the attributes of such persons-whether they are educated or reside in a particular geographical area or shop at a particular store etc. The final pattern that emerges can be used to make marketing decisions.
First Page: Tutorial 68: MSAS - Building a Relational Decision Tree Model