Loan Disbursement Analysis Power BI Dashboard, insightful dashboard to understand loan disbursement correctly.
- Monthly Disbursements in EUR for the last 6 months. Consider principal_amount_eur as a measure.
- 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)).
- Portfolio at risk. Use KPIs to show the (sum of principal_amount_outstanding_eur) with [overdue days > 30/(sum(principla_amount_outstanding_eur))].
- Add filters to breakdown by branch_key, product and loan_officer.