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.