BANKING ANALYTICS
Banking Customer & Portfolio Analysis
How are loans, deposits, and customer relationships distributed across the portfolio?
3,000 clients · Portfolio case study
Clients by loyalty classification
Web visualisation · calculated from supplied dataThe question & data
Five report pages bring customer segments, lending, deposits, and account balances into a navigable banking overview.
3,000 client records with relationship, gender, and investment-advisor lookup tables.
The approach
- Connected client and lookup tables for segmented reporting.
- Created income bands and engagement categories.
- Configured Home, Loan Analysis, Deposit Analysis, Summary, and Drill Through report pages.
What the work reveals
The source supports comparison across income, nationality, loyalty, and banking relationships.
Separate loan and deposit pages allow focused exploration of different balance measures.
From findings to next steps
Use segment comparisons to identify questions for relationship managers and validate balance definitions before aggregating accounts.
Read the results in context
Descriptive portfolio analysis does not establish credit risk predictions or loan-approval suitability.
Based on supplied portfolio materials. Findings describe the dataset and report; recommendations are proposed next steps, not measured business outcomes.