Skip to content

Dashboard templates

Financial services · IT

Consumer finance company running credit scoring, the lending app, loan origination and core lending, and the collection gateway. Applications, disbursements and bad debt, plus support tickets, incidents, MTTR, SLA, changes, availability and the estimated applications and disbursements affected when systems go down.

Free plan with no time limit · No card required · Sample workspace ready in minutes

For IT heads at consumer finance companies running credit scoring, the lending app, core lending and payment collection gateways. The "IT and lending" dashboard estimates how many loan applications and disbursements are affected when systems go down, plus IT tickets per 100 loan applications. The "IT incidents and support" and "Availability and changes" dashboards cover incidents, P1 incidents, time to resolve, SLA breaches, change failure rate and availability. Needs branch, loan product, loan application, loan, IT service catalog and IT ticket data.

Use this template to

  • Tell leadership how many disbursements a credit scoring outage affected.
  • Prioritize investment in the systems with the longest downtime in the quarter.
  • Lower the change failure rate by seeing which change types often get rolled back.

6 ready-made dashboards

IT and lending

Loan applications and disbursements estimated to be affected by system outages, and IT workload relative to applications.

  • Estimated disbursements affected by IT outages
  • Estimated loan applications affected by IT outages
  • IT tickets per 100 loan applications
  • Service availability
  • Estimated affected disbursements by service
  • Weekly IT tickets per 100 applications

IT incidents and support

Tickets, P1 incidents, response and resolution times, and SLA breach rate by service and resolver team.

  • Incidents
  • P1 incidents
  • Mean time to resolve (MTTR, hours)
  • SLA breach rate
  • By service
  • SLA breach rate by work type
  • Response time by resolver team
  • Weekly tickets

Availability and changes

Availability, outage time and change failure rate for each IT service.

  • Service availability
  • Outage minutes
  • Changes deployed
  • Change failure rate
  • Availability by service
  • Outage minutes by criticality
  • Weekly outage minutes

Credit overview

Company-wide disbursements, approval rate, outstanding balance and bad debt by branch and product.

  • Disbursed amount
  • Approval rate
  • Average outstanding balance
  • NPL ratio
  • Weekly disbursements by product group
  • Disbursements by branch
  • Results by branch

Applications and disbursements

Loan applications by acquisition channel, approval rate, and disbursements by product and partner dealer.

  • Loan applications
  • Approval rate
  • Loans disbursed
  • Average loan size
  • Weekly approval rate
  • Approval rate by acquisition channel
  • Disbursements by loan product
  • Disbursements via partner dealers

Portfolio quality and collections

Outstanding balance by risk group, NPL ratio, PAR30, collection rate and interest income.

  • NPL ratio
  • Portfolio at risk 30+ days (PAR30)
  • Collection rate
  • Interest income collected
  • Outstanding balance by risk group
  • Monthly NPL ratio by product group
  • NPL ratio by branch
  • Monthly collection rate by product group

Ask Si as soon as the build finishes

  • “How did estimated loan applications affected by IT outages change compared with last month?”
  • “What is driving estimated disbursements affected by IT outages this quarter?”
  • “Show IT tickets per 100 loan applications by month for the last six months.”
  • “Where is service availability highest this month, and why?”

31 defined metrics

Versioned definitions, shared by dashboards, Si, reports and MCP.

MetricDefinitionUnit
Estimated loan applications affected by IT outagesFor each outage: outage minutes divided by 1,440, times the number of loan applications submitted on the day the outage started, times the share of applications that depend on that service. Summed over all outages in the period.Number
Estimated disbursements affected by IT outagesFor each outage: outage minutes divided by 1,440, times the amount disbursed on the day the outage started, times the share of applications that depend on that service. Summed over all outages in the period.Currency
IT tickets per 100 loan applicationsIT support tickets opened in the period times 100 divided by loan applications submitted in the period; measures IT load relative to lending volume.= IT support tickets * 100 / Loan applicationsNumber
Service availabilityOne minus outage minutes divided by the service's planned operating minutes in the period.= 1 - Outage minutes / it_planned_minutesRatio (%)
Change failure rateFailed changes (failed or rolled back) divided by changes deployed in the period.= Failed changes / Changes deployedRatio (%)
Changes deployedNumber of IT changes deployed in the period, by deployment date.Count
Failed changesNumber of changes deployed in the period with a failed or rolled-back outcome.Count
Average first response time (hours)Average hours from ticket creation to first response, across all tickets opened in the period.= it_response_hours_total / IT support ticketsNumber
IncidentsNumber of incident-type tickets opened in the period, by open date.Count
Mean time to resolve (MTTR, hours)Average hours from open to resolution for incidents resolved in the period.= it_incident_hours_total / Resolved incidentsNumber
Outage minutesTotal minutes a service was down or disrupted, counted on the day the outage started.Number
P1 incidentsNumber of highest-priority incidents (P1, critical) opened in the period.Count
Resolved incidentsNumber of incidents resolved in the period, by resolution date.Count
SLA breach rateTickets breaching SLA divided by tickets opened in the period.= SLA breaches / IT support ticketsRatio (%)
SLA breachesTickets opened in the period that were resolved after the SLA deadline (resolution hours greater than the SLA target).Count
IT support ticketsNumber of IT support tickets (incidents and requests) opened in the period, by open date.Count
Loan applicationsNumber of loan applications submitted in the period (by submission date), across all decisions: approved, rejected, pending review and withdrawn by the customer.Count
Approval rateApproved applications divided by decided applications (approved plus rejected), by submission date. Applications pending review or withdrawn by the customer are excluded.= Approved applications / (Approved applications + Rejected applications)Ratio (%)
Approved applicationsApplications submitted in the period that were approved for a loan (by submission date).Count
Average NPL balanceOutstanding principal in debt groups 3-5, averaged over the month-end snapshots in the period.= fs_npl_outstanding_total / fs_snapshot_countCurrency
Average outstanding balanceOutstanding principal averaged over the month-end snapshots in the period = total outstanding across snapshots / number of snapshots.= fs_outstanding_snapshot_total / fs_snapshot_countCurrency
Average loan sizeDisbursed amount divided by the number of loans disbursed in the period.= Disbursed amount / Loans disbursedCurrency
Collected amountTotal paid by customers (principal and interest) in the period, by payment date.Currency
Collection rateAmount collected on installments falling due in the period divided by the amount due on those installments (by due date, with collections counted up to the data date).= fs_collected_for_due / Amount dueRatio (%)
Disbursed amountTotal principal disbursed for loans in the period (by disbursement date).Currency
Amount dueTotal principal and interest of repayment installments falling due in the period (by due date).Currency
Interest income collectedThe interest portion of customer payments in the period (by payment date). Payments are applied first to the interest of earlier installments, the remainder to principal.Currency
Loans disbursedNumber of loans (credit contracts) disbursed in the period.Count
NPL ratioOutstanding balance in debt groups 3-5 (more than 90 days past due) divided by total outstanding, on the month-end snapshots in the period.= fs_npl_outstanding_total / fs_outstanding_snapshot_totalRatio (%)
Portfolio at risk 30+ days (PAR30)Outstanding principal of loans more than 30 days past due divided by total outstanding, on the month-end snapshots in the period.= fs_par30_outstanding_total / fs_outstanding_snapshot_totalRatio (%)
Rejected applicationsApplications submitted in the period that were declined (by submission date).Count

Data you need

Required

branch, loan_product, loan_application, loan, it_service, it_ticket

Add if you have it (unlocks more metrics)

dealer, borrower, repayment, loan_balance_monthly, it_change, it_outage

Three steps to this dashboard

  1. 1

    Connect your data

    Upload an Excel file or connect a source with: branch, loan_product, loan_application, loan, it_service, it_ticket.

  2. 2

    Approve Si's proposal

    Si proposes how to read your tables and map them to the industry's standard model; you fix anything highlighted and approve.

  3. 3

    Dashboards and Q&A

    The build gives you 6 dashboards and 31 metrics; ask Si anytime.

Data sources for this template

Connectors with a setup guide that feed the entities this template needs. Excel always works.

Related templates

Build Financial services · IT with your own data

Free plan with no time limit · No card required · Sample workspace ready in minutes