The Member 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 members of the institution. Three 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 Member Pivot report allows power users go beyond the other standard reports in BankBI Banking Performance to examine the demographics and behaviour of the member base 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
• Age range
• Product class
• Product group
• Product code
• Product description
• New this month?
• Marital status
• By age (table)
• By gender, age (table)
• By gender, marital status (table)
Please sign in to leave a comment.