Using aggregate to write cluster centers to Excel for conditional formatting
In nearly all organizations, the Modeler practitioners and model builders are reporting to a management team that either does not have day to day access to Modeler or is unfamiliar with the tool. Therefore, during the evaluation phase, if the analyst is to break away from the constraints of a purely technical judging of models, then he or she needs to give management the ability to join into the evaluation of models. One rarely exports raw data to Excel. The size limitation would almost always be a factor, and there is rarely any good reason to do it. However, Excel is a great way to send, discuss, and report on summary information.
In this recipe, we will take the summary information about a handful of clusters and prepare it in a form that a modeler can easily share with their colleagues. The idea of a cluster center is simple; it is the average value on a series of fields that were used when the clusters were...