The Branch/Loan Officer/Product Pivot report emulates some of the Pivot Table and Pivot Chart functions available in Microsoft Excel that may be familiar to power-users, and allows the construction of user-defined charts (graphs), tables and heat maps using any combination of the factors stored related to the loan portfolio. Five versions (saved states) of this report can be selected so that the combination of factors and presentation format do not need to be reset each time.
The Branch/Loan Officer/Product Pivot report allows power users go beyond the other standard reports in BankBI Banking Performance to examine the loan portfolio using any combination of factors. This can be done for single month or time series and can be shown in a wide range of presentation formats. This report is particularly useful in the presentation of analysis findings to peers and managers, to aid planning, show causative factors behind trends, identify opportunities or manage risks.
You can select:-
Whether to present values as counts (e.g. numbers of deposits) or sum (total amounts)
Currency (if relevant)
The number of months of history to include
Value to present
• By product (chart)
• By product (TreeMap)
• By region (chart)
• By region, branch, loan officer (heatmap)
• By region, branch, loan officer (table)