Loan Disbursement Analysis Power BI Dashboard

Loan Disbursement Analysis Power BI Dashboard

Loan Disbursement Analysis Power BI Dashboard, insightful dashboard to understand loan disbursement correctly.

 

Client Requirements

  1. Monthly Disbursements in EUR for the last 6 months. Consider principal_amount_eur as a measure. 
  2. Disbursements per loan_officer. Show the count of loans disbursed per each loan officer for the last month. Show the volume of the disbursed loan as well (sum(principal_amount_eur)).
  3. Portfolio at risk. Use KPIs to show the (sum of principal_amount_outstanding_eur) with [overdue days > 30/(sum(principla_amount_outstanding_eur))].
  4. Add filters to breakdown by branch_key, product and loan_officer. 

 

 

 

 

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *