CrediU Dashboard
Group Project
Background
CrediU Company is growing fintech lending platform. CrediU business direction in 2020-2022 is focusing more to lower the risk of loans that failed to pay, So CrediU wants to focus more on acquiring and processing good applicants and debtors
Objective
To build dashboards that show business performance (KPI management) for 3 different stakeholders (CEO, Product Operation Manager, and Collection Team) at CrediU
Scope of Work
Data cleaning, data aggregation, develop dashboard
Methodology
CTE, UNION, SQL window function
Tools
BigQuery, Looker Studio
Important Links
Result
Metrics
CEO Dashboard
Total Applicant
Total Debtors
Total Disbursed Amount
Quarterly Total Applicant vs Debtors
Quarterly ROI
Quarterly Revenue
Quarterly Gross Profit
Paid-off Rate
Quarterly Payment Rate
POM Dashboard
Total Applications
Total Applicant
Total Debtors
Funnel Chart
Total User by Location
Total User by Reason
Total User by Payment Method
Applicant Segmentation by Ability and Credit Score
Collection Team Dashboard
Total Debtors Have Loan
Total Loans Not Paid Off
Total Due Amount
Paid Off Rate
Due Amount per Bucket
Debtor Profile
Insights
1. In the end of 2022 there is an increase of bad applicants and we don't know yet what factors effect this
2. The data shows inefficiency in the funnel system, because the document is still verified manually, so CrediU highly recommend to provide a better assesment process.