Dashboards and reports

Overview

The dashboards visible in the HES LoanBox BackOffice Analytics area are not stored in the HES LoanBox source code. They live entirely inside the Metabase instance that an environment is connected to, and the list is fetched live every time a user opens the Analytics area. As a result, the only authoritative way to enumerate the dashboards available in HES LoanBox is to log in to the Analytics area on that environment (or to the connected Metabase) and read the list directly.

The list of available Reports and Dashboards:

The “Loan Applications” section:

• “Total Number of Loan Applications”,
• “Average Approved Loan Amount”,
• “Requested vs. Approved Amount Rate”,
• “Application Approval Rate”,
• “Loan Application Status Overview”.

The “Deeper Dive into Loan Applications” section:

• “Total Number of Loan Applications Over Time”,
• “Application Approval Rate over Time”,
• “Requested vs. Approved Amount Rate over Time”,
• “Average Approved Loan Amount over Time”,
• “Loan Application Funnel”.

The “Loans” section:

• “Total Number of Loans”,
• “Loans Fully Repaid”,
• “Average Loan Term in Weeks”,
• “Average Loan Term in Months”,
• “Pull-Through Rate”,
• “Loan Status Overview”.

The “Deeper Dive into Loans” section:

• “Total Number of Loans Over Time”,
• “Total Number of Fully Repaid Loans Over Time”,
• “Pull-Through Rate Over Time”,
• “Total Disbursement Amount by Loan Product Over Time”.

The following filters are supported:

• “Loan Product”,
• “Created At”.

Loan Application Insights

The following charts are presented on this tab:

The “General Insights” section:

• “Average Loan Application Stage Duration in Minutes”,
• “Average Loan Application Stage Duration”.

The “Underwriting Insights” section:

• “Number of Applications by Underwriter”,
• “Average Underwriting Duration in Minutes”,
• “Average Number of Loan Applications per Day”,
• “Approved vs. Declined Loan Applications by Borrower’s Age”,
• “Decline Reasons”,
• “Cancellation Reasons”.

The following filters are supported:

• “Loan Product”,
• “Created At”.

Ongoing Portfolio Health

The following charts are presented on this tab:

The “Active Loans Balance” section:

• “Active Loans”,
• “Total Principal Balance”,
• “Total Interest Balance”,
• “Total Overdue Amount”,
• “Total Principal, Interest & Overdue Balances Over Time”,
• “Total Disbursement Amount vs. Total Number of Active Loans Over Time”.

The following filters are supported:

• “Loan Product”,
• “Activation Date”.

Portfolio Risks

The following charts are presented on this tab:

The “Risks Overview” section:

• “PAR > 30”,
• “PAR > 60”,
• “PAR > 90”,
• “Portfolio Risk Concentration by Borrower’s Industry”,
• “Portfolio Concentration by Loan Product”.

Borrower Demographics

The following charts are presented on this tab:

The “Deeper Dive into Borrower Demographics” section:

• “Total Number of Borrowers”,
• “New Borrowers to Date”,
• “Number of Borrowers by Age”,
• “Number of Borrowers by Marital Status”,
• “Number of Borrowers by Monthly Income”,
• “Number of Borrowers by Education”,
• “Number of Borrowers by Length of Employment”.

The following filters are supported:

• “Created At”.