Fintech analytics dashboard showing KPIs, credit scores, monthly cash flow, spending categories, customer segmentation, loan health, and savings projections.

Fintech SQL project — analytics overview

Total customers

55

112 accounts

Avg credit score

707

Good range

Total transactions

878

6-month history

Fraud flagged

1

98.2% clean

Monthly cash flow — all customers

Income Expenses
Monthly income and expenses over time across all customers.

Credit score distribution

Credit score band distribution across 55 customers.

Top 8 spending categories

Spending breakdown by category across all customers.

12-month savings projection (3.5% APR)

Alice ($12k) David ($85k) Carol ($500)
Compound interest projections for three customers over 12 months.

Customer segmentation

At risk
44
Stable
6
Churned
5

Loan payment health

On-time paid 111 payments
Overdue 9 payments
Partial 6 payments

87.4% paid on time · 4.7% partial · 7.9% overdue

Credit score factors — Bob Martinez (678)

Bob Martinez credit score factor breakdown across 5 dimensions.

Net worth — top 6 customers

Top 6 customers by assets and liabilities.