Creating a classification tree financial summary using aggregate and an Excel Export node

In nearly all organizations, the Modeler user collaborates with colleagues that do not have Modeler. If one is to honor the Value Law quoted in the chapter introduction, criteria must be considered other than accuracy and stability. Since ROI is on the mind of the data miner, those additional criteria always include some of a financial nature. Whether it be potential cost savings or potential revenue increases, the relevant fields will be ones that management will be very familiar with and very interested in. This is not to say that these variables must be model inputs—quite often they are not—but they should be part of the evaluation process. In this recipe, we will process an Excel file that organizes these kinds of variables in the context of a tree segmentation. It combines variables exported from the tree model, including Rule Identifier and the Model's prediction, with financial variables in summary...