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.