100 Best ChatGPT KPI and Dashboard Prompts for Banks

Direct Answer

The best ChatGPT prompts for KPI and dashboard for banks are designed to help finance teams define, monitor, and act on the right metrics through precise prompts that produce ready-to-use dashboards, trend analyses, and decision-ready visuals. Use them to standardize reporting, automate updates, and surface actionable insights across liquidity, credit risk, profitability, and compliance.

Introduction

This page is a practical prompt library for KPI and dashboard prompts tailored to banks. It helps bank professionals, data teams, and risk managers build repeatable, auditable KPI dashboards.

Each prompt is specific, with roles, tasks, context, output formats, and constraints so teams can deploy quickly without inventing missing details.

How to Use These ChatGPT Prompts

• Replace placeholders like [industry], [audience], and [constraints] with your exact context.
• Attach your data sources and data lineage notes to keep outputs grounded in reality.
• Request outputs in machine-readable formats alongside human-readable summaries to facilitate automation.
• Specify output formats, time ranges, and drill-down paths to ensure dashboards meet executive needs.
• Validate outputs by cross-checking with source systems and existing reports.
• Iterate prompts to align with evolving regulatory and internal policy requirements.

100 Best ChatGPT KPI and Dashboard Prompts for Banks

1. Core KPI list for banks: You are a Bank Analytics Lead. Task: compile a core KPI list for a mid-sized retail bank. Context: include profitability, liquidity, credit risk, and client engagement metrics. Output format: a structured KPI table with columns KPI name, definition, data source, frequency, owner, and target. Constraints: exclude private data, use metrics common to Basel guidelines where possible.
2. Executive KPI dashboard outline: You are a BI architect for a regional bank. Task: design a high-level executive KPI dashboard outline. Context: include liquidity coverage ratio, net interest income, non-performing loan ratio, and customer satisfaction. Output format: bullet list of sections with KPIs per section and drill-down paths. Constraints: provide at least three drill-down paths and one executive narrative paragraph.
3. Liquidity trend chart prompts: You are a data analyst. Task: create prompts to generate liquidity trend visuals for the last 12 months. Context: include daily cash balances, inflows, outflows, and stress-test scenarios. Output format: JSON describing chart types, axes, color codes, and thresholds. Constraints: ensure charts support zoom and compare year over year.
4. Credit risk heatmap prompts: You are a risk analyst. Task: develop prompts to produce a credit risk heatmap by borrower segment, product, and region. Context: rate sources, default probability, exposure at default, and loss given default. Output format: table plus heatmap matrix. Constraints: color scale must be accessible, include legend. Include a notes field with caveats.
5. Profitability by product prompts: You are a product analyst. Task: compare profitability by product line across channels. Context: include gross margin, operating margin, and contribution margin. Output format: dashboard cards with trend arrows and a micro-PSI score. Constraints: show both YoY and MoM deltas.
6. Regulatory KPI alignment: You are a compliance analytics specialist. Task: map bank KPIs to Basel III / IFRS 9 reporting requirements. Context: include capital adequacy, expected credit loss, stage transitions, and alert thresholds. Output format: mapping table with regulatory reference, KPI owner, data lineage, and frequency. Constraints: cite sources and avoid proprietary data.
7. Customer journey KPIs: You are a customer insights analyst. Task: define KPIs across the customer journey for onboarding, activation, and retention. Context: track funnel drop-off, time-to-first-deposit, and cross-sell rate. Output format: journey map with KPI lanes and targets. Constraints: include at least three customer segments.
8. Operational efficiency prompts: You are an operations analyst. Task: identify KPIs for bank operation efficiency across branches and digital channels. Context: include cost per transaction, ATM uptime, and service level. Output format: dashboard tiles with benchmarks and variance. Constraints: provide smoothing for seasonality.
9. Fraud monitoring KPIs: You are a fraud analytics lead. Task: create KPIs to monitor fraud attempts vs detections. Context: include detection rate, false positives, case resolution time, and user impact. Output format: multi-metric scorecard with alerts. Constraints: thresholds must be adaptable and explainable.
10. Liquidity stress prompts: You are a treasury analyst. Task: build prompts to simulate liquidity stress scenarios and their impact on metrics. Context: include cash buffers, unrealized losses, and funding gaps. Output format: scenario brief with expected KPI reactions and a decision appendix. Constraints: provide runbook steps.
11. NII growth prompts: You are a finance planner. Task: forecast net interest income growth under different rate paths. Context: include margin, volume, and mix effects. Output format: sensitivity table and dashboard forecast panel. Constraints: show confidence intervals.
12. Fee income analytics: You are a product finance analyst. Task: analyze fee-based income sources and trends. Context: include service charges, card fees, wire fees, and subscription revenue. Output format: KPI cards with YoY changes and split by region. Constraints: adjust for seasonality.
13. Branch performance prompts: You are a regional analytics manager. Task: compare branch performance metrics. Context: include revenue per transaction, cost per visit, and digital adoption. Output format: branch heatmap with ranking and notes. Constraints: include top 3 and bottom 3 branches.
14. Digital channel adoption: You are a digital analytics lead. Task: track adoption of online and mobile banking features. Context: include logins, feature usage, and activation rate. Output format: trend charts with segmentation by age group. Constraints: ensure privacy compliance.
15. Risk-adjusted return prompts: You are a portfolio analytics expert. Task: calculate risk-adjusted returns on banking portfolios. Context: include ROE, ROA, and risk-adjusted alpha. Output format: dashboard cards with sparkline charts. Constraints: compare to benchmarks.
16. Cost-to-income benchmarks: You are a financial planning analyst. Task: establish cost-to-income benchmarks for the bank. Context: include headcount, IT spend, and channel costs. Output format: dashboard panel with targets and variance. Constraints: normalize for branch count.
17. Compliance alert prompts: You are a compliance operations analyst. Task: define KPIs and alert rules for regulatory monitoring. Context: include suspicious activity reports, audit findings, and policy violations. Output format: alert dashboard with severity levels and owners. Constraints: actions required field.
18. Customer satisfaction KPIs: You are a customer experience analyst. Task: measure satisfaction across channels. Context: include NPS, CSAT, response time, and escalation rate. Output format: scorecards with trend arrows and regional breakdowns. Constraints: include benchmark comparisons.
19. Portfolio quality prompts: You are a credit risk manager. Task: monitor portfolio diversification and concentration risk. Context: include sector exposure, regional exposure, and product mix. Output format: dashboard with heatmaps and concentration metrics. Constraints: alert when thresholds breached.
20. Settlement dashboard prompts: You are a treasury operations analyst. Task: design KPIs for settlements and reconciliation. Context: include settlement time, exception rate, and straight-through processing. Output format: KPI grid with drill-downs. Constraints: show historical trends.
21. Treasury funding prompts: You are a treasury manager. Task: track funding diversity and cost of funds. Context: include wholesale funding, deposits, and FHLB/central bank borrowings. Output format: comparison panel with risk flags. Constraints: scenario analysis included.
22. Capital adequacy prompts: You are a risk and capital analyst. Task: monitor capital adequacy ratio and buffers. Context: include CET1, RWA, and buffer requirements. Output format: dashboard with red/yellow/green status. Constraints: ensure audit trail.
23. Customer retention prompts: You are a marketing analytics specialist. Task: quantify retention across cohorts. Context: include churn rate, reactivation rate, and lifetime value. Output format: cohort chart with KPI notes. Constraints: compare across segments.
24. Asset quality metrics: You are a credit risk analyst. Task: monitor asset quality indicators by product line. Context: include delinquency rate, provisioning, and collateral coverage. Output format: stacked bar charts and trend lines. Constraints: baseline recalibrations documented.
25. Product launch KPIs: You are a product manager for a bank. Task: define KPIs for a new product launch. Context: include adoption, revenue, and unit economics. Output format: launch dashboard outline with milestones. Constraints: include go/no-go criteria.
26. Operational incident tracking: You are an IT operations analyst. Task: track incidents affecting services. Context: include MTTR, MTBF, and repeat incidents. Output format: incident heatmap with root-cause tags. Constraints: show time-to-resolution.
27. Cost optimization prompts: You are a financial operations analyst. Task: identify cost-saving opportunities. Context: include outsourcing, automation, and vendor management. Output format: savings dashboard with ROI estimates. Constraints: tiered prioritization.
28. Productivity KPIs: You are an HR analytics specialist. Task: track workforce productivity metrics. Context: include revenue per employee, training hours, and turnover. Output format: payroll and productivity dashboard cards. Constraints: separate by business line.
29. Cash flow forecasting: You are a treasury forecaster. Task: forecast cash flow under scenarios. Context: include receipts, disbursements, and funding commitments. Output format: forecast ledger with confidence bands. Constraints: include model freeze dates.
30. Regulatory reporting prompts: You are a compliance reporting specialist. Task: automate data for regulatory reports. Context: include reporting fields, data lineage, and submission cadence. Output format: report pack with validation rules. Constraints: reproducible and auditable.
31. Customer onboarding KPIs: You are a onboarding analytics lead. Task: measure onboarding efficiency. Context: include time-to-verify, document completion, and activation rate. Output format: onboarding funnel with targets. Constraints: segment by channel.
32. Fraud prevention prompts: You are a fraud risk engineer. Task: design KPIs to prevent fraud. Context: include detection rate, false positives, and remediation time. Output format: control-panel with alert levels. Constraints: include explainability notes.
33. Market risk metrics: You are a market risk analyst. Task: track value-at-risk and stress test results. Context: include scenario results, backtesting, and hedging. Output format: dashboard with risk heatmap. Constraints: limit backtest lookback.
34. Liquidity vs profitability: You are a financial strategist. Task: analyze trade-offs between liquidity metrics and profitability. Context: include funding costs and opportunity costs. Output format: dashboard with trade-off curves. Constraints: provide actionable recommendations.
35. Product profitability drilldown: You are a product controller. Task: dissect profitability by product and channel. Context: include revenue, cost-to-serve, and allocated overhead. Output format: multi-layered dashboard with drill-down paths. Constraints: show sensitivity to pricing.
36. Compliance risk scoring: You are a compliance risk manager. Task: score compliance risk across processes. Context: include control design, testing results, and incident history. Output format: risk scorecards with heatmaps. Constraints: update quarterly.
37. Digital risk indicators: You are an information security analyst. Task: monitor digital risk indicators. Context: include login failures, bot detections, and patch compliance. Output format: alert dashboard with trend lines. Constraints: thresholds must be explainable.
38. KYC/AML monitoring: You are a KYC analyst. Task: design prompts to track KYC/AML metrics. Context: include verification rate, enhanced due diligence cases, and SARs. Output format: monitoring panel with action items. Constraints: privacy compliant.
39. Customer support KPIs: You are a support operations manager. Task: measure support performance. Context: include first response time, resolution time, and customer satisfaction by channel. Output format: agent-level dashboard with benchmarks. Constraints: avoid SLA gaming.
40. Data quality prompts: You are a data governance lead. Task: ensure KPI data quality. Context: include completeness, accuracy, timeliness, and lineage. Output format: data quality scorecard with remediation plan. Constraints: include data steward owners.
41. Portfolio concentration prompts: You are a risk analytics lead. Task: monitor concentration by borrower, industry, and geography. Context: include exposure and diversification index. Output format: concentration dashboard with alerts. Constraints: alert thresholds clearly defined.
42. Customer lifetime value: You are a customer analytics manager. Task: compute LTV by cohort. Context: include retention, average revenue, and discount rate. Output format: LTV waterfalls and cohort charts. Constraints: compare channels.
43. Credit loss prompts: You are a credit risk analyst. Task: estimate expected credit losses by portfolio. Context: include staging, LGD, and impairment timing. Output format: loss forecast with confidence bands. Constraints: align with IFRS 9 standards.
44. Expense tracking prompts: You are an FP&A specialist. Task: track expenses by category and department. Context: include overruns and variance analysis. Output format: expense dashboard with drill-downs. Constraints: normalize for headcount.
45. Branch queue metrics: You are a branch operations manager. Task: measure in-branch wait times and service levels. Context: include queue length, service time, and staffing. Output format: queue heatmap with service level targets. Constraints: show peak periods.
46. Channel performance prompts: You are a channel analytics lead. Task: compare branch, digital, and call center channels. Context: include conversion rate, revenue per channel, and cost to serve. Output format: channel comparison board with bars and sparklines.Constraints: ensure privacy.
47. ATM performance metrics: You are an ATM operations manager. Task: track ATM availability and cash levels. Context: include uptime, cash balance, and maintenance cost. Output format: status board with schedule.
48. Liquidity forecasting prompts: You are a treasury forecaster. Task: forecast liquidity stress with scenarios. Context: include inflows, outflows, and funding commitments. Output format: forecast dashboard with confidence bands. Constraints: include scenario-friendly visuals.
49. Loan portfolio health: You are a portfolio risk analyst. Task: evaluate loan portfolio health. Context: include vintage analysis, delinquency by bucket, and cure rates. Output format: dashboard with trend lines and heatmaps. Constraints: segment by product.
50. Forecast accuracy checks: You are a forecasting analyst. Task: assess accuracy of financial forecasts. Context: include error metrics, bias, and calibration. Output format: accuracy scorecard with notes. Constraints: compare across periods.
51. Interest rate impact: You are a financial modeller. Task: quantify impact of rate changes on NII. Context: include gap analysis and repricing lags. Output format: scenario table with charts. Constraints: include parallel shifts.
52. Product usage analytics: You are a product data analyst. Task: analyze product feature usage and adoption. Context: include activation funnel and engagement metrics. Output format: feature usage dashboard with segmentation. Constraints: compare cohorts.
53. Regulatory data lineage: You are a data governance analyst. Task: map regulatory data lineage for reports. Context: include source systems, transformations, and data owners. Output format: lineage diagram description. Constraints: audit-friendly.
54. Customer attrition reasons: You are a customer insights analyst. Task: identify drivers of attrition. Context: include segmentation by channel and product. Output format: attrition reasons matrix with weights. Constraints: tie to retention plans.
55. Liquidity governance prompts: You are a treasury risk manager. Task: set governance KPIs for liquidity. Context: include buffers, liquidity coverage ratio, and funding plan. Output format: governance scorecard with owners. Constraints: quarterly updates.
56. Cost-to-serve benchmarks: You are a cost analyst. Task: benchmark cost-to-serve per product. Context: include channel, region, and customer segment. Output format: benchmark dashboard with variance.
57. Data unification prompts: You are a data integration lead. Task: unify KPI data from silos. Context: include master data, data quality, and lineage. Output format: unified KPI dataset with schema notes. Constraints: avoid duplicates.
58. Forecast scenario prompts: You are a financial forecaster. Task: create scenario prompts for forecasts. Context: include rate, growth, and path dependency. Output format: scenario catalog with assumptions. Constraints: include probability estimates.
59. Profitability by channel: You are a financial planner. Task: measure profitability by channel. Context: include revenue, cost-to-serve, and overhead. Output format: channel profitability board with drill-downs. Constraints: compare channels.
60. Credit risk segmentation: You are a risk data scientist. Task: segment borrowers by risk profile. Context: include scoring, delinquency, and exposure. Output format: segmentation dashboard with action items. Constraints: ensure explainability.
61. KPI governance prompts: You are a data governance lead. Task: establish KPI governance for the bank. Context: include owners, SLAs, and review cadence. Output format: governance charter plus dashboard. Constraints: annual refresh.
62. Stress testing prompts: You are a risk manager. Task: design prompts to run stress tests. Context: include macro scenarios and idiosyncratic shocks. Output format: stress test results with impact charts. Constraints: document assumptions.
63. Customer segmentation dashboards: You are a marketing data analyst. Task: build dashboards by customer segment. Context: include value, cost-to-serve, and retention. Output format: segment dashboards with comparison charts. Constraints: anonymize data.
64. Product lifecycle KPIs: You are a product analytics manager. Task: track KPIs across product lifecycle. Context: include discovery, pilot, scaling, and sunset stages. Output format: lifecycle board with stage-specific metrics. Constraints: handoff notes.
65. Regulatory sanction prompts: You are a compliance analyst. Task: monitor sanctions screening results. Context: include hits, false positives, and remediation time. Output format: sanctions dashboard with trend lines. Constraints: privacy safe.
66. Remediation tracking: You are a data quality lead. Task: track data remediation work. Context: include backlog, aging, and impact. Output format: remediation board with status and owners. Constraints: SLA visibility.
67. Cost center dashboards: You are a finance controller. Task: create dashboards by cost center. Context: include variances, approvals, and headcount. Output format: cost center scorecards. Constraints: roll up to bank-wide view.
68. Data freshness checks: You are a data quality engineer. Task: validate data freshness for KPIs. Context: include last refresh, latency, and stale data alerts. Output format: freshness dashboard with thresholds. Constraints: auto-notify owners.
69. Cash management prompts: You are a cash management analyst. Task: optimize short-term cash. Context: include sweep accounts, overnight deposits, and balance forecasting. Output format: cash position board with alerts. Constraints: min/max balances.
70. Product mix optimization: You are a product portfolio analyst. Task: optimize product mix for profitability. Context: include demand elasticity and cannibalization risk. Output format: mix dashboard with optimization suggestions. Constraints: simulate changes.
71. Risk-adjusted profitability: You are a financial risk manager. Task: compute risk-adjusted profitability by product. Context: include capital charge and expected return. Output format: dashboard with risk-adjusted margins. Constraints: align with internal targets.
72. Cost avoidance prompts: You are a procurement analyst. Task: identify cost avoidance opportunities. Context: include renegotiation and bundling. Output format: savings tracker with approval flows. Constraints: show payback.
73. Ethics and compliance: You are a compliance officer. Task: audit ethics-related KPIs. Context: include policy violations and training completion. Output format: ethics scorecard with trends. Constraints: ensure fairness.
74. System health metrics: You are an IT risk analyst. Task: monitor system health indicators. Context: include downtime, incidents, backup success. Output format: health board with SLA alignment. Constraints: alert on deviations.
75. Product portfolio heatmap: You are a product strategy analyst. Task: visualize KPI by product portfolio. Context: include revenue, risk, and strategic fit. Output format: portfolio heatmap with filters. Constraints: data refresh cadence.
76. Liquidity risk prompts: You are a treasury risk manager. Task: assess liquidity risk indicators. Context: include funding maturing, collateral, and deposit growth. Output format: dashboard with risk flags. Constraints: clear escalation paths.
77. On-time reporting prompts: You are a reporting analyst. Task: ensure timely KPI reports. Context: include submission deadlines and validation checks. Output format: schedule board with owners. Constraints: automate reminders.
78. CPL profitability prompts: You are a cost accounting analyst. Task: calculate cost per loan product. Context: include origination and servicing costs. Output format: product-level P&L board. Constraints: allocate shared costs.
79. Risk event tracking: You are a risk manager. Task: log and analyze risk events. Context: include event type, impact, and mitigation. Output format: events board with root cause and actions. Constraints: link to KPI impact.
80. Product adoption heatmap: You are a product analytics lead. Task: map adoption rates by product and region. Context: include activation and churn. Output format: heatmap with trend lines. Constraints: segment by segment.
81. Returns and refunds: You are a customer experience analyst. Task: analyze refunds and returns impact. Context: include reasons and cost. Output format: refund dashboard with channel splits. Constraints: flag anomalies.
82. Audit readiness prompts: You are an internal audit manager. Task: prepare KPI artifacts for audits. Context: include data maps, controls, and evidence. Output format: audit pack with checklists. Constraints: ensure traceability.
83. Data dictionary prompts: You are a data governance steward. Task: define KPI data definitions. Context: include metrics, dimensions, and data owners. Output format: dictionary entry per KPI. Constraints: consistent naming.
84. RWA and risk prompts: You are a risk modeler. Task: track risk-weighted assets vs capital. Context: include asset classes and risk weights. Output format: dashboard with WAM and tiering. Constraints: align with Basel II/III.
85. Customer feedback prompts: You are a customer insights analyst. Task: synthesize feedback into KPIs. Context: include sentiment, themes, and action items. Output format: feedback board with priorities. Constraints: avoid bias in sampling.
86. SLA adherence prompts: You are a service ops lead. Task: monitor SLA adherence by channel. Context: include response time, resolution time, and escalation. Output format: SLA board with breach alerts. Constraints: quarterly review.
87. Debt collection metrics: You are a collections analytics specialist. Task: track collections performance. Context: include recovery rate, promises-kept, and DSO. Output format: collections scorecard with regional views. Constraints: avoid predatory prompts.
88. Data lineage audits: You are a data stewardship lead. Task: perform data lineage checkups. Context: include lineage gaps and remediation. Output format: lineage audit report with risks. Constraints: include screenshots.
89. Cost of risk prompts: You are a risk analyst. Task: quantify cost of risk by area. Context: include expected loss, capital charge, and remediation cost. Output format: cost-of-risk dashboard with breakdowns. Constraints: provide actionable mitigations.
90. Portfolio risk dashboards: You are a portfolio risk lead. Task: build dashboards by portfolio segment. Context: include exposure, loss forecasts, and hedging. Output format: segment dashboards with alerts. Constraints: avoid data leakage.
91. KPI review prompts: You are a data governance lead. Task: run KPI review prompts with owners. Context: include review cadence and decision log. Output format: review pack with decisions. Constraints: ensure accountability.
92. Escalation prompts: You are a risk control analyst. Task: define escalation criteria for KPI alerts. Context: include priority levels and owners. Output format: escalation playbook with contact routes. Constraints: keep it actionable.
93. Executive storytelling prompts: You are a BI storyteller. Task: craft executive-ready KPI narratives. Context: include key metrics, reasons for changes, and actions. Output format: narrative brief plus visuals. Constraints: keep succinct.
94. Forecast update prompts: You are a FP&A lead. Task: create prompts to update forecasts monthly. Context: include variance analysis and drivers. Output format: update pack with changes and outlook. Constraints: lock inputs.
95. Data privacy prompts: You are a privacy officer. Task: ensure KPI dashboards respect customer privacy. Context: include data minimization and access controls. Output format: privacy checklist with remediation steps. Constraints: include audits.
96. Channel risk prompts: You are a risk analytics specialist. Task: assess channel-specific risk. Context: include fraud exposure and compliance risk per channel. Output format: risk board with controls. Constraints: channel-specific thresholds.
97. Ethics risk prompts: You are an ethics auditor. Task: evaluate ethics-related KPIs. Context: include training, complaints, and policy adherence. Output format: ethics scorecard with trend analysis. Constraints: anonymize data.
98. Automation readiness: You are an automation strategist. Task: gauge readiness for KPI dashboard automation. Context: include data sources, tooling, and skill gaps. Output format: readiness scorecard with milestones. Constraints: prioritize high impact areas.
99. Benchmarking prompts: You are a benchmarking analyst. Task: compare bank KPIs to peers. Context: include revenue, cost-to-income, and NIM. Output format: benchmark board with insights. Constraints: ensure data privacy.
100. Sustainability KPIs: You are a sustainability analyst. Task: integrate ESG metrics with financial KPIs. Context: include green lending, energy usage, and disclosures. Output format: integrated KPI dashboard with governance flags. Constraints: align with standards.

Best Practices

• Keep prompts specific to the bank context (products, channels, regional differences).
• Define data sources and owners in the prompt to ensure accountability.
• Use consistent KPI naming and units across prompts for reuse.
• Include caveats and limitations to prevent misinterpretation of outputs.
• Test prompts with mock data to verify output structure before production use.

Common Mistakes to Avoid

• Using vague prompts that leave data sources and owners undefined.
• Asking for outputs without specifying formats or units, leading to inconsistent dashboards.
• Ignoring privacy and regulatory constraints in prompts.
• Assuming perfect data quality; prompts should require data lineage and quality checks.
• Overloading prompts with too many KPIs, causing clutter and confusion.

FAQ

What makes a KPI dashboard effective for banks?

An effective bank KPI dashboard clearly presents critical metrics, ties each KPI to data sources and owners, supports drill-downs, and updates automatically with auditable data lineage.

How should I choose which KPIs to start with?

Start with core financial health, liquidity, credit risk, customer engagement, and operational efficiency KPIs that align to regulatory requirements and strategic goals.

Can these prompts handle data privacy requirements?

Yes. Each prompt can be configured to include data minimization, access controls, and anonymization where needed to comply with privacy rules.

How often should dashboards refresh?

Refresh frequency should match business needs and data latency, commonly daily for executive dashboards and real-time or near-real-time for critical alerts.

Are these prompts suitable for automation?

Yes. They are designed to produce outputs that can feed BI tools, dashboards, and automated reports while maintaining auditable data lineage.

Do prompts cover Basel III IFRS requirements?

Several prompts map KPIs to Basel III and IFRS reporting concepts; tailor mappings to your bank’s jurisdiction and reporting standards.