N. Okoro
← All projects

BANKING ANALYTICS

Banking Customer & Portfolio Analysis

How are loans, deposits, and customer relationships distributed across the portfolio?

Power BI

3,000 clients · Portfolio case study

Clients by loyalty classification

Jade1,331
Silver767
Gold585
Platinum317
Web visualisation · calculated from supplied data

The 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

  1. Connected client and lookup tables for segmented reporting.
  2. Created income bands and engagement categories.
  3. 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.

Next case study HR Workforce Analytics ↗