Collections Dashboard & Data Visualization

Designed and launched an internal dashboard for the collections team, enabling real-time visibility into payment trends and delinquency. The tool improved team efficiency by 70% through actionable, data-driven insights.

Overview

The Collections User Group relies on this dashboard to strategically plan their day based on the payment status of the borrower. This dashboard seamlessly tracks the real-time payment statuses and also provides the portfolio performance metrics and so the collection specialist understands the actionable insights to strategically plan their day.
Role: Product designer
Team: PM, Devs , Design manager, QA, Compliance
Tools: Figma, Lucid chart , Jira,  Hey Marvin - a qualitative user research platform, Slack

The problem

The collections team lacked a centralized way to monitor borrower payment activity. Agents relied on outdated spreadsheets and manual tracking to understand account status, making prioritizing outreach, spotting trends, or performance reports difficult.

We were tasked with designing a real-time dashboard that surfaces delinquency rates, payment statuses, and borrower-level insights — all in a format that’s easy to scan, actionable, and directly supports collection strategies.

Project goals

The goal was to empower the collections team with a real-time, data-rich dashboard that could help them take faster, more informed action. Our focus was on clarity, usability, and surfacing the most relevant insights all while reducing time spent navigating disconnected systems.

Key objectives

Design process

1. Stakeholder Interviews & Workflow Mapping

Collaborated with agents and managers to understand daily tasks, reporting needs, and decision-making bottlenecks. Mapped out how collections were tracked manually and what insights were missing.

2. Pain Point Synthesis & Opportunity Framing

Clustered findings into themes such as: “Unclear task ownership,” “Too many disconnected steps,” and “Lack of visibility.” These themes informed our UX opportunities and product scope.

3. Dashboard Architecture & Wireframes

Created wireframes exploring multiple layouts cards vs. tables, filters vs. tabs. Introduced a visual hierarchy that allowed agents to quickly scan for problem accounts and take action.

4. High-Fidelity Prototyping & Agent Testing

Developed prototypes with real data samples. Conducted feedback sessions with agents to validate flow, sorting logic, and responsiveness. Iterated on chart types and color usage for clarity.

5. Dev Handoff & Data QA

Documented UI components and collaborated with devs to ensure charts, filters, and data logic aligned. Supported QA with user scenarios and interactive states to validate behavior in production.

Discovery

Methods and research insights

Methods : User interviews, user shadowing
Insights : Based on the research the user pain points are:

  • Payment statuses are not readily visible; users must click into each account for updates.
  • Collections agents rely on multiple tools for portfolio summaries, leading to inefficiencies.
  • Duplication of tasks across various platforms makes the collections process cumbersome.
  • Lack of readily available actionable insights hinders strategic daily planning.
  • High stress levels among agents due to inefficient workflows contribute to increased attrition.

Business goal : Reduce attrition and make the tool SaaS ready.

How might we?

How might we streamline the collections process by centralizing data, providing real-time payment status visibility, and delivering actionable insights to help agents strategically plan their day and reduce stress?

Ideation

Cross functional team brainstorming session

Conducted a cross functional team brainstorming session involving front -end devs, back-end devs, PMs to determine the feasibility of changes and means to collect the listed metrics for display on the dashboard and also to determine the product roadmap as it involved changes to the already existing collections table.

Dashboard Anatomy Diagram

Design and user testing

Key features and description

Real-time Payment Status Indicators

Allow agents to quickly identify overdue, upcoming, or successful payments with visual tags

Portfolio Summary Panel

Gives managers at-a-glance insights into payment trends, reversals, and extension activity

Account Table with Filters

Lets agents prioritize by state, days overdue, or payment status for faster outreach

Last Worked Tracker

Helps prevent duplicate contact and keeps agents accountable

Impact and outcome

The dashboard launch brought immediate clarity and measurable improvements to the collections process. Agents were able to prioritize accounts more efficiently, managers gained visibility into real-time metrics, and redundant communication efforts were reduced.By surfacing the right data at the right time, the tool enabled smarter decision-making and increased trust in the operational workflow.

Key Results

  • 65% increase in user satisfaction based on internal surveys and feedback.
  • Reduction in tool-switching by 70%, allowing agents to access all necessary insights within a single dashboard.
  • Improved portfolio monitoring, leading to a 40% reduction in missed follow-ups and a 25% increase in successful collections.
  • Reduction in agent stress levels, contributing to lower attrition rates and a more engaged workforce.