Designing an analytics dashboard powering loan disbursals of ₹10L+ daily

Overview
Team
1 product manager
1 product designer
2 engineers
Duration
2 month
My role
End to end design and handoff of the feature
Impact
Improved internal team efficiency by 10%
Lower TAT for custom metrics
Contributed to NPS of 8.2 for FY25
About the product
Users Involved

The problem
OLD EXPERIENCE
# Problem 1
Time to action was very high - with users having to make more than 6-7 interactions aftering finding a gap in their numbers
CLIENT REQUESTS FOR CUSTOM ANALYTICS
# Problem 2
Each client would want to see numbers in a different way - causing multiple custom requests
Why solve this?
#1
#2
The goal
The messy middle i.e the process
Insights from client visits, wireframes, going through other analytics platforms, documenting user scenarios, user flows and many dicsussions



🔴 Approach 1 - Overview Redesign
I tried redesigning the existing dashboards by combining related metrics together
This approach would prove to not very scalable.
Introduction of new metrics would mean new designs.
Back to the drawing board —>
🔴 Approach 2 - Getting closer
Breaking metrics into funnels across various steps.
On discussion with my developers - there were certain constraints with the graphs I had designed.
But we were getting closer to the final solution
Iterating with funnels and firming up the layout …
The solution

Ability to analyse user ID's for each metric
A common behaviour for the operation managers was to analyse individual cases to figure out what went wrong - we replicated that behaviour with filtered user ID's at each step
BEFORE
AFTER
The new solution reduced the required interactions for customer ID flow from 5-6 clicks and users having to recall steps to 2 interactions. Reducing time to action by 3-4 seconds
Enabling configurable graphs
We set up "building blocks" these were pre-made graphs components where our support teams could configure custom graphs for clients via events
DOCUMENTING COMPONENTS AND BEHAVIOUR OF GRAPHS
Impact
On a daily basis, clients like SBIC process loans of upto 10lakhs a day - with more insightful analytics, Operations managers were able to spot issues faster and increase loan disbursals
Improving internal effeciency by freeing up bandwidth of dev teams
Reduction in interaction cost and time to action by reducing 4-5 clicks to 2 clicks and making and time to action from 8s to 3s.
My learnings & Reflections
I would spend a lot more time prototyping the graphs to get a feel for interactions.
Learnt to consider responsiveness and scalability in design
Using interaction design to distill complex data points to insightful metrics




