When I started working with monitoring lending products application scorecards in 2003, I grappled with understanding and presenting the complex decision trees. After some deliberation, paper and pencil I proposed a waterfall style diagram which evolved into different styles as we went along.
As an update or an improvement Tree Maps do seem an ideal step up from the old waterfall style diagrams mainly because they illustrate hierarchy, relative size and scorecard decisions may be color coded.
Firstly here is a link again to where you can download the Add-in for MS Excel which is called Tree Map. It is quite straightforward to install using the Help function if necessary.
Link to Excel Add-in Tree Map
Secondly here is a sample data file with dummy data from a lending product application scorecard monthly cycle. Sample Application Scorecard Data
I have presented both styles in this data file waterfall style and the TreeMapp style.
Select the data in the Sample file to create a Tree Map as below. You will notice how I have spent time on setting up the data such that the hiearchy is created from Scoring to Policy to Decision. Color coding was based upon shades of Green for accept and shades of Red for decline.
Here if the JPEG format output of the TreeMap below.
As an update or an improvement Tree Maps do seem an ideal step up from the old waterfall style diagrams mainly because they illustrate hierarchy, relative size and scorecard decisions may be color coded.
Firstly here is a link again to where you can download the Add-in for MS Excel which is called Tree Map. It is quite straightforward to install using the Help function if necessary.
Link to Excel Add-in Tree Map
Secondly here is a sample data file with dummy data from a lending product application scorecard monthly cycle. Sample Application Scorecard Data
I have presented both styles in this data file waterfall style and the TreeMapp style.
Select the data in the Sample file to create a Tree Map as below. You will notice how I have spent time on setting up the data such that the hiearchy is created from Scoring to Policy to Decision. Color coding was based upon shades of Green for accept and shades of Red for decline.
Here if the JPEG format output of the TreeMap below.
No comments:
Post a Comment