Data Analysis · Finance & Banking

Build a credit risk scoring model

Build a simple, explainable credit scoring model from historic loan data. An expert, step-by-step prompt with inputs, method, deliverables, rules and a quality check.

Your prompt is ready 5 brackets to fill
You are a credit risk data scientist.
I work in Finance & Banking: a bank offering retail and business accounts. This work matters to retail customers, analysts and compliance officers.

## Goal
Build a simple, explainable credit scoring model from historic loan data.

## What matters in Finance & Banking
- Numbers that matter: customer churn; cost-to-income ratio; net interest margin; NPA or default rate; CASA ratio; customer acquisition cost; fraud loss rate; NPS.
- Tools commonly used: core banking system; CRM; loan origination system; mobile banking app; BI dashboards and Excel.
- Rules and standards that usually apply: KYC and AML/CFT rules; central-bank regulation (RBI in India, the Fed and OCC in the US, the FCA in the UK); fair-lending and consumer-protection rules; PCI DSS for card data; required risk disclosures; never promise guaranteed returns.
- Rules differ by country. If I have not said where I work, ask me, and do not present one country's law as if it applied everywhere.

## What I will give you
- Loan data columns: [APPLICANT FEATURES, LOAN DETAILS, DEFAULT FLAG]
- Number of loans and default rate: [NUMBERS]
- Regulatory context: [COUNTRY]
- Tools: [Python, R]
- Anything else you should know: [EXTRA CONTEXT, or "none"]

## How to work through it
1. Restate the business question in one sentence and the decision it will inform. Say which data is needed to answer it and whether my data can.
2. Define default and the observation window.
3. Clean data and avoid leakage from post-approval information.
4. Explore features and bin them with weight of evidence.
5. Build a logistic regression scorecard.
6. Validate with out-of-time data using AUC, Gini and KS.
7. Check fairness across protected groups.
8. Set cut-off scores and estimate approval and loss rates.
9. State the limits of the analysis: sample size, missing data, bias, and what correlation does not prove.
10. Turn the findings into 3 to 5 recommendations, each with the evidence behind it and the expected impact.

## What to deliver
- Data preparation steps
- Scorecard with points per attribute
- Validation results
- Fairness check
- Cut-off strategy

## Expert rules
- Check data quality before analysing: duplicates, missing values, outliers, units and date ranges.
- Show your working: the formula, SQL or code used, so I can reproduce every number.
- Separate what the data shows from what you infer, and give confidence levels.
- Respect KYC and AML regulation, audit trails and data security. If anything in my plan or inputs conflicts with them, say so plainly and suggest a fix.
- Do not invent facts, figures, laws, sources or quotes. Label anything you had to assume with "Assumption:" and tell me how to check it.

## Format
- Lead with the answer in plain language, then the supporting numbers.
- Use tables for comparisons and describe any chart you recommend (type, axes, what it should show).
- Put code and formulas in fenced code blocks.

## Before you answer
Check your draft against this list and fix anything that fails:
- Every number comes from my data or is marked as an assumption, and correlation is never presented as cause.
- Every item under "What to deliver" is complete, specific to my inputs and usable as it is, with no placeholders left for me to guess.
- Where it applies, it shows the likely effect on customer churn and cost-to-income ratio.

If something essential is missing, ask me up to 3 short questions first. Otherwise, start.
Open in ChatGPT Claude Perplexity

How to use this prompt

  1. Copy the prompt. Press Copy prompt and the full text goes to your clipboard.
  2. Fill the brackets. Use the form above, or replace [APPLICANT FEATURES, LOAN DETAILS, DEFAULT FLAG], [NUMBERS], [COUNTRY], [Python, R], [EXTRA CONTEXT, or "none"] with your own details.
  3. Paste and send. Paste it into ChatGPT, Claude, Gemini and DeepSeek and send. Ask follow-up questions to refine the answer.

Why this prompt works

The “Build a credit risk scoring model” prompt tells the assistant exactly what to hand back: data preparation steps; scorecard with points per attribute; validation results; fairness check; and cut-off strategy. It makes the assistant work through 10 steps in order, starting with "restate the business question in one sentence and the decision it will inform. Say which data is needed to answer it and whether my data can", instead of jumping straight to an answer. Before replying, the assistant checks its draft against 3 tests and fixes anything that fails.

If an important detail is missing, the assistant asks you up to 3 short questions before it starts, so it does not build on guesses.

How to get the best answer

  1. Fill every bracket with real detail: [APPLICANT FEATURES, LOAN DETAILS, DEFAULT FLAG], [NUMBERS], [COUNTRY] and the rest should hold real names, numbers and dates, not placeholders.
  2. Paste real material: where the prompt asks for notes, data or text, paste the actual content rather than a summary.
  3. Refine in the same chat: ask "make it shorter", "turn it into a table" or "add more detail on step 2".
  4. Check the result: test what it builds or writes before you rely on it.

FAQ

Frequently asked questions

Which AI assistant works best with the “Build a credit risk scoring model” prompt?

The “Build a credit risk scoring model” prompt works in any chat assistant and suits ChatGPT, Claude, Gemini and DeepSeek best. Paste it in, send it, and ask follow-up questions in the same chat to refine the answer.

What do I fill in before sending the “Build a credit risk scoring model” prompt?

Replace the 5 highlighted brackets – [APPLICANT FEATURES, LOAN DETAILS, DEFAULT FLAG], [NUMBERS], [COUNTRY], [Python, R], [EXTRA CONTEXT, or "none"] – with your own details. The more specific you are, the better the answer.

Who is the “Build a credit risk scoring model” prompt for?

Anyone who wants a complete, working result from an AI assistant. Replace the brackets with your own project details.

Is the “Build a credit risk scoring model” prompt free to use?

Yes. First AI Prompt prompts are free to copy and use in personal and business work, with no sign-up, no account and no daily limit.

Can I trust the answer the “Build a credit risk scoring model” prompt gives?

Treat it as a strong first draft: the prompt tells the assistant not to invent facts and to mark its assumptions, but check figures yourself, especially anything with legal, financial or safety consequences.

Keep exploring

Browse more Finance & Banking prompts