Share
Explore

Looker Studio Reports

1. Sales Team Report

Purpose: Track application progress and performance metrics.
Key Metrics:
Total Applications Logged (Display the count of all applications logged within the selected date range.)
Total Approved Amount vs. Disbursed Amount (Visual comparison (e.g., bar or line chart) of the total approved and disbursed amounts)
Average Login Creation to Login Completion TAT (Display the average number of days from application login to Login Completion)
Total Applications vs Approved applications in 1 go
Top Retailers/Sellers (based on amount/approval rate)
Dimensions:
Application Status (e.g., In-Process, Approved, Rejected. Visualization: Pie or donut chart to display the percentage of applications in each status)
Product and Program types (Categorization of applications by product and program types. Visualization: Stacked bar chart showing total applications per product or program type)
City, State, Zone (Applications grouped by geographic location. Visualization: Geo map with application distribution by city or region)
Ageing (to track delays)
Filters:
Sales Zones (Filter to view data for specific sales zones (e.g., North, South))
Product Category (Filter by product types (e.g., Retail Loan, Working Capital) or program names)
Application Status (Filter to isolate data for particular statuses, like “In-Process” or “Approved.”)
Date Range
Frequency: Weekly for ongoing monitoring and monthly summaries

2. Credit Team Report

Purpose: Provide insight into application creditworthiness and credit decision efficiency.
Key Metrics:
Total Applications Received
Approval and Rejection Rates
Average Time to Credit Decision
Top Reasons for Rejection
Dimensions:
Credit Analyst
Industry and Product
Stage Type (Login, Sanction, Rejection, etc.)
Filters:
Analyst
Product Type
Application Category and Program
Frequency: Real-time or daily for tracking applications moving through credit checks

3. KYC Team Report

Purpose: Track KYC compliance and completion status.
Key Metrics:
Total Applications with Completed KYC
Average Time for KYC Completion
Pending KYC Cases
Dimensions:
Stage Type (KYC Pending, Completed)
Credit Analyst assigned
KYC Completion Date and Ageing
Filters:
Date Ranges
City, State, and Zone
Frequency: Daily for monitoring compliance progress, and weekly summaries.

4. Operations Team Report

Purpose: Monitor disbursement statuses and operational TATs.
Key Metrics:
Applications Approved & Disbursed
Time from Approval to Disbursement
Operational Delays (due to pending documents, PSD, etc.)
Average Disbursement Amount per Application
Dimensions:
Disbursement Stage (Approved, Pending Disbursement, Disbursed)
Approval Date and Disbursement Date
PF and SD Amount received status
Filters:
Application Category, Program, and Product Type
Disbursement Status
Frequency: Daily updates with a weekly summary for completed disbursements.
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.