Skip to content

Dashboard templates

Financial services · Data & analytics

A consumer finance company whose data team loads loan applications, credit scores, CIC (credit bureau) lookups, collections and outstanding balances into the warehouse and builds reports for departments. A key credit KPI board (applications, approval rate, disbursements, collections, outstanding balance, bad debt) plus pipeline reliability, data quality, analysis requests, dashboard usage and loans whose dealer code does not match the dealer list.

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

For data teams at consumer finance companies, where loan applications, credit scores, collections and balances come from many systems. The "KPI board" dashboard brings together the key credit metrics (applications, approval rate, disbursements, collections, bad debt) and adds one dedicated check: disbursements with dealer codes that do not match the dealer list. The "Data reliability" and "Requests and usage" dashboards measure run success rate, test pass rate, freshness violations, request delivery time and dashboard views. Needs branch, loan product, loan and pipeline run log data.

Use this template to

  • Report credit KPIs to leadership together with how reliable that month's data is.
  • Find and fix loans recorded with dealer codes missing from the dealer list before commissions are calculated.
  • Fix the pipelines that fail most often first, and measure delivery time for analysis requests.

3 ready-made dashboards

KPI board

Key credit KPIs of the finance company next to the reliability of the data behind them.

  • Disbursed amount
  • Loans disbursed
  • Approval rate
  • Collection rate
  • NPL ratio
  • Portfolio at risk 30+ days (PAR30)
  • Average outstanding balance
  • Run success rate
  • Check pass rate
  • Freshness breaches

Data reliability

Are pipelines running reliably, is data as fresh as promised, and how many quality checks pass.

  • Run success rate
  • Freshness breaches
  • Check pass rate
  • Average run duration (minutes)
  • By data table
  • Weekly failed runs by domain
  • Failed checks by type

Requests and usage

How many analysis requests departments send, how fast the data team delivers, and how often dashboards are viewed.

  • Analysis requests
  • Average request lead time (days)
  • Dashboard views
  • Departments viewing dashboards
  • By department
  • Views by dashboard
  • Weekly new analysis requests

Ask Si as soon as the build finishes

  • “How did disbursements with unmatched dealer code change compared with last month?”
  • “What is driving loans with unmatched dealer code this quarter?”
  • “Show unmatched dealer code disbursement share by month for the last six months.”
  • “Where is departments viewing dashboards highest this month, and why?”

28 defined metrics

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

MetricDefinitionUnit
Disbursements with unmatched dealer codeTotal principal disbursed in the period for loans whose dealer code is not in the dealer list.Currency
Loans with unmatched dealer codeLoans disbursed in the period (by disbursement date) whose dealer code is not in the dealer list. A data quality check on joining contracts to dealers; these loans still count in disbursements but drop out when viewed by dealer.Count
Unmatched dealer code disbursement shareDisbursements whose dealer code does not match the dealer list divided by total disbursement value in the period.= Disbursements with unmatched dealer code / Disbursed amountRatio (%)
Departments viewing dashboardsNumber of distinct departments with at least one dashboard view in the period.Count
Average request lead time (days)Average days from when a department submits a request to when the data team delivers it, for requests delivered in the period.= da_request_lead_days_total / Delivered requestsNumber
Average run duration (minutes)Average minutes from start to finish of successful runs in the period.= da_run_minutes_total / da_successful_runsNumber
Check pass ratePassed checks divided by all data quality checks in the period.= (Data quality checks - Failed checks) / Data quality checksRatio (%)
Dashboard viewsTotal dashboard views by users across departments in the period.Count
Delivered requestsDelivered requests with a delivery date in the period (by delivery date).Count
Failed checksData quality checks with a standardized result of fail in the period.Count
Failed runsPipeline runs with a standardized status of failed (including errors and timeouts), by start date.Count
Freshness breachesSuccessful runs where the gap since the previous successful load of the same table exceeds that table's freshness commitment (freshness_sla_hours).Count
Pipeline runsData loading pipeline runs started in the period, including successful, failed and skipped runs.Count
Data quality checksData quality checks run in the period (freshness, completeness, uniqueness, validity).Count
Analysis requestsAnalysis and report requests that departments submitted to the data team in the period (by submission date).Count
Run success rateSuccessful runs divided by runs with an outcome (successful plus failed). Skipped runs are excluded.= da_successful_runs / (da_successful_runs + Failed runs)Ratio (%)
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 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
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
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, da_pipeline_run

Add if you have it (unlocks more metrics)

dealer, borrower, loan_application, repayment, loan_balance_monthly, da_dataset, da_quality_check, da_request, da_dashboard_view

Three steps to this dashboard

  1. 1

    Connect your data

    Upload an Excel file or connect a source with: branch, loan_product, loan, da_pipeline_run.

  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 3 dashboards and 28 metrics; ask Si anytime.

Related templates

Build Financial services · Data & analytics with your own data

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