• +234 (0) 7062274671
  • training@talentdigit.com
  • Log in
  • Register
Logo
  • About
  • Reviews
  • Portfolios
  • Programmes
    • Self-Paced Courses
    • Free Courses
    • Instructor-led Programmes
    • Training Centre (Hybrid)
    • Corporate Training
  • Free Resources
Avatar
Ismail
Portfolios (4)

Royal Bank Loan Analysis

October 14, 2026 (0) comments
Product
Product
Product
Product
Project related images. Click to view
Product
Product
Product
Product

Loan Portfolio Dashboard: Turning 38,576 Loans into Clear Business Insight

Banks lend money every day, but leadership needs to see at a glance whether that lending is paying off and where the risk sits. For this project, I built an interactive loan portfolio dashboard for Royal Bank that answers those questions in one place.

I started with a raw loan dataset and used Excel to validate and clean the data and build PivotTables to explore it. I then moved to Power BI, where I created DAX measures for the key metrics and designed a four-page report: Executive View, Loan Performance, Credit Risk Analysis, and Customer Analysis. Navigation buttons let a user move between pages easily.

The Executive View gives leadership the headline numbers right away. The portfolio covers 38,576 loans worth $435.76M, and total payments received came to $473.07M, a net return of about $37M. The average interest rate is 12%. The portfolio’s main risk is also clear: the charged-off rate is 15%, with charged-off loans totaling $65.53M.

Together, these figures show a portfolio that is profitable overall, with credit risk as the main area to manage. The remaining pages let decision-makers look into the drivers behind these numbers, including loan performance over time, risk by borrower profile, and customer segments.

Skills demonstrated: data cleaning and validation, PivotTable analysis, DAX, dashboard design, KPI development, and communicating financial insights.


Comment (0)

Leave your thought here

Other projects by Ismail

Blog

K-Square Store Sales Summary

Blog

K-Square Store Sales Summary

Blog

K-Square Store Sales Dashboard

Logo
  • Home
  • About
  • Reviews
  • Portfolios
  • Blog
  • Programmes
    • Self-Paced Courses
    • Free Courses
    • Instructor-led Programmes
    • Training Centre (Hybrid)
    • Corporate Training
  • Free Resources
    Log In
    Sign Up
Logo

Talentdigit Resources Limited is a digital training and consulting firm that equips individuals and organizations with digital skills training.

Quick Links

  • About
  • Reviews
  • Portfolios
  • Corporate Training
  • Blog
  • Refer a student and Earn
  • Verify Certificate
  • Login
  • Register

Programmes

  • Self-Paced Courses
  • Free Courses
  • Instructor-led Programmes
  • Hybrid Learning
  • Corporate Training
  • Free Resources

Sign Up for Our Newsletter

Receive weekly newsletter with educational materials, popular books and much more!

  • Terms of Use
  • Privacy Policy

© 2023 (c) All right reserve

Login

Don't have an account yet?

Forgot your password?

or Log-in with

  • Gacebook
  • Google
Sign Up

Already have an account?

Home
Home
Home
Home
Home
Home
Home
Home
Home