100 Best Gemini KPI and Dashboard Prompts for Banks

Direct Answer

The best Gemini prompts for KPI and dashboard for banks are a curated set of precise prompts that cover data modeling, dashboard design, risk, liquidity, profitability, customer experience, operations, and compliance. Use them to build bank dashboards that reveal actionable insights and drive decision making. Note: tailor placeholders to your institution and verify outputs with data owners before deployment.

Introduction

This page provides a practical prompt library for building KPI dashboards in banking with Gemini prompts. It is intended for analysts, BI engineers, and leaders who design and monitor financial performance dashboards.

Readers can adapt the prompts to retail, corporate, and digital banking segments while preserving governance, privacy, and data quality.

How to Use These Gemini Prompts

• Replace placeholders like [industry], [audience], [product], [constraints], [data], [tone], and [format] with your specifics.
• Add constraints on data freshness, privacy, and role-based views to ensure relevance and safety.
• Request outputs in clearly named sections or formats to ease integration with BI tools.
• Copy prompts as-is or adapt them for your data model, ensuring alignment with data sources and governance.
• Validate outputs by cross-checking with source systems and stakeholder reviews.
• When needed, ask Gemini to generate follow-up prompts for deeper drill-downs or alternative scenarios.

100 Best Gemini KPI and Dashboard Prompts for Banks

1. KPI data model design: You are a KPI Architect. Your task is to design a data model for bank KPIs, including facts, dimensions, and hierarchies. Context: bank-wide metrics across retail, corporate, and digital channels. Output: a detailed data model diagram description in plain text with entity relationships and sample table schemas. Constraint: include at least five core KPI domains and date granularity by day, week, month, and quarter.
2. Executive KPI dashboard mock: You are a dashboard designer. Create an executive KPI dashboard blueprint for a bank. Context: role is Chief Analytics Officer; audience is C-suite. Output: a list of dashboard panels with objective, metrics, data sources, refresh cadence, and an example screenshot sketch in plain text. Constraint: show at least four focus areas: profitability, liquidity, risk, and customer experience.
3. Retail KPI drilldown: Act as a data strategist. Build a drilldown flow for retail banking KPIs from overall profitability to product-level margins. Context: needs segmentation by region and channel. Output: a step-by-step drill path, with target metrics and sample SQL snippets for each level. Constraint: ensure guardrails for privacy and data freshness.
4. Credit risk metrics list: You are a risk analytics lead. Compile a KPI list for credit risk monitoring in a bank. Context: include probability of default, loss given default, exposure at default, and stress-test overlays. Output: a table-like plain text list with definitions, calculation formulas, data sources, and alert thresholds. Constraint: cover retail and SME portfolios.
5. Liquidity dash overview: You are a liquidity analytics specialist. Create an overview of liquidity KPIs for dashboards. Context: cover LCR, NSFR, intraday liquidity, cash buffers. Output: concise definitions, data sources, acceptable thresholds, and a 2-line example chart description per metric.
6. Net interest margin view: Role: financial metrics analyst. Task: present NIM performance prompts for dashboards. Context: compare by product, region, and funding source. Output: a table of NIM components, data lineage, and a suggested visualization style for each component.
7. Customer experience KPIs: You are a CX analytics consultant. List customer experience KPIs relevant to banks such as NPS, CSAT, first contact resolution, and digital adoption. Output: definitions, data sources, calculation rules, and a recommended visualization palette. Constraint: include latency of data updates.
8. Sales conversion KPIs: Role: sales analytics lead. Task: KPI prompts for funnel performance in banking products. Context: retail and business banking. Output: funnel stages, conversion rates, and delta vs prior period; specify data joins and filters.
9. Channel performance metrics: Act as a channel analytics lead. Build a KPI list for channels (online, branch, mobile). Output: per-channel metrics, attribution method, and visualization suggestions. Constraint: support pivot by region.
10. Product profitability prompts: You are a product analytics manager. Generate KPIs for product-level profitability in banking. Context: include cost-to-serve, yield, and cross-sell impact. Output: product taxonomy, metric definitions, and dashboard widgets.
11. Fraud monitoring KPIs: Role: fraud analytics lead. Provide KPI prompts for fraud detection and mitigation dashboards. Context: real-time alerts, false positives, and incident severity. Output: metric list, data sources, alert thresholds, and example alert rules.
12. Operational efficiency metrics: You are an operations analytics expert. List KPIs for back-office efficiency in a bank. Context: processes like account opening and settlements. Output: cycle times, throughput, error rates, and automation impact with sample visuals.
13. Compliance KPI prompts: Role: compliance analytics lead. Build KPIs to monitor regulatory adherence. Context: AML, KYC, reporting timeliness. Output: definitions, data lineage, and dashboards with compliance heatmaps.
14. Cost-to-income prompts: You are a finance data scientist. Create prompts to track cost-to-income ratio by segment. Context: comparebusiness lines and cost centers. Output: calculation method, data sources, and a sample visualization layout.
15. Budget vs actual prompts: Role: finance planner. Task: prompts to compare budgeted vs actual revenue and expenses. Context: monthly and quarterly horizons. Output: variance analysis steps, data sources, and recommended charts.
16. Stress testing KPIs: You are a risk modeler. Provide KPI prompts for stress-test dashboards. Context: macro scenarios, asset quality, and capital adequacy. Output: scenario definitions, expected impact metrics, and alert thresholds.
17. ATM network KPIs: Role: ops analytics. Build KPIs for ATM network performance. Context: uptime, cash availability, outages by region. Output: per-ATM metrics, aggregation rules, and map-based visual prompts.
18. Digital onboarding metrics: You are a digital analytics lead. KPIs for onboarding funnel in digital channels. Context: mobile app and web. Output: funnel steps, drop-off reasons, and optimization suggestions.
19. Customer lifetime value: Role: customer analytics. Define CLV/prompts for banking products. Context: cross-sell opportunities and retention. Output: CLV formula, data sources, segmentation, and dashboard widgets.
20. churn metrics: You are a customer analytics specialist. Create KPIs for churn in banking customers. Context: by product and channel. Output: churn rate definitions, data sources, and retention programs impact.
21. Product mix dashboards: Role: product analytics lead. KPI prompts for product mix and margins. Context: portfolio diversification. Output: mix metrics, visualization plan, and data lineage.
22. Operational risk metrics: You are an operational risk analyst. Build KPIs for incident tracking and control effectiveness. Output: risk indicators, data sources, and escalation rules.
23. Pricing competitiveness: Role: pricing analyst. Prompts to monitor price competitiveness across products. Context: rate cards, fees, and promotions. Output: benchmark definitions, data sources, and alert thresholds.
24. Cash flow forecasting: You are a treasury analyst. KPIs for cash flow forecasting accuracy. Context: funding, disbursements, and inflows. Output: forecast accuracy metrics, data sources, and visualization ideas.
25. Loan portfolio health: Role: portfolio analytics. Define KPIs for loan portfolio health. Context: delinquency, prepayments, seasoning. Output: metric list, aggregation logic, and dashboard widgets.
26. Deposit growth metrics: You are a banking analytics lead. KPIs for deposit growth trends. Output: growth rates, rate sensitivity, and channel contributions with chart ideas.
27. Credit utilization prompts: Role: credit analytics. KPI prompts for utilization metrics. Context: revolving lines, limits, and utilization rates. Output: calculation rules, data sources, and alerts.
28. Market risk indicators: You are a market risk analyst. KPIs for value at risk, stress loss, and exposures. Output: data sources, horizon, and visualization ideas.
29. Liquidity stress dashboards: Role: liquidity risk manager. Provide prompts for stress-test dashboards focusing on liquidity gaps. Output: gap metrics, thresholds, and example chart layouts.
30. Regulatory reporting prompts: You are a regulatory reporting expert. KPIs for timeliness and accuracy of reports. Output: required fields, data lineage, and validation steps.
31. Branch performance metrics: Role: branch analytics. KPIs by branch network. Output: footfall, conversion, and channel mix with bar and heatmap ideas.
32. Remittance KPIs: You are a payments analytics lead. KPIs for remittance volumes, fees, and SLA adherence. Output: source attribution, reconciliation steps, and dashboard layout.
33. Cross-sell effectiveness: Role: marketing analytics. KPIs for cross-sell success across products. Output: uplift metrics, attribution model, and segmentation cues.
34. Digital funnel insights: You are a digital analytics specialist. Provide prompts for funnel insights in digital onboarding and lending. Output: funnel stages, conversion lift, and data quality checks.
35. Satisfaction vs effort: Role: CX analytics. KPIs comparing customer satisfaction vs effort required. Output: metric definitions, data sources, and visualization approach.
36. Portfolio diversification: You are a portfolio risk analyst. KPIs for diversification across asset classes. Output: concentration thresholds, data sources, and alert rules.
37. Fraud containment metrics: Role: fraud operations. KPIs for containment speed and case resolution. Output: lifecycle stages, time-to-detection, and impact scoring.
38. Vendor risk indicators: You are a third-party risk analyst. KPIs for vendor performance and risk. Output: SLA adherence, incident rates, and dashboard sections.
39. Compliance training metrics: Role: compliance program manager. KPIs for training completion, assessment results, and policy adherence. Output: cohorts, pass rates, and trends.
40. Cyber security prompts: You are a cybersecurity analytics lead. KPIs for threat detections and incident response. Output: alert counts by type, MTTR, and patch compliance.
41. ATM cash optimization: Role: operations analyst. KPIs for cash optimization and replenishment. Output: cash level targets, depletion rates, and replenishment schedules.
42. Chargeback indicators: You are a payments risk analyst. KPIs for chargebacks and dispute resolution. Output: rate by channel, aging, and win rate.
43. Cost allocation prompts: Role: finance analytics. KPIs for internal cost allocation accuracy. Output: allocation rules, data lineage, and variance checks.
44. Customer segmentation KPIs: You are a customer analytics lead. KPIs for segment profitability and retention. Output: segment definitions, lifetime value, and dashboard widgets.
45. Product launch metrics: Role: product analytics. KPIs for new product performance. Output: adoption rate, revenue impact, and feedback loops.
46. Forecast bias checks: You are a forecasting analyst. KPIs to detect bias in financial forecasts. Output: error metrics, backtesting steps, and model explanations.
47. Portfolio risk heatmaps: Role: risk reporting. KPIs for visual heatmaps of risk across portfolios. Output: color scale, legend, and data sources.
48. Operational backlog metrics: You are an operations analytics lead. KPIs for backlog and throughput. Output: aging, priority distribution, and workflow visualization.
49. Interest rate sensitivity: Role: treasury strategist. KPIs for rate sensitivity of assets and liabilities. Output: duration gap, scenario prompts, and chart suggestions.
50. Productivity dashboards: You are a BI engineer. KPIs for analyst productivity and automation ROI. Output: metrics, data sources, and dashboard layout.
51. Asset quality indicators: Role: credit risk analyst. KPIs for asset quality, delinquencies, and cures. Output: definitions, data lineage, and alert thresholds.
52. Delinquency trends: You are a credit analytics expert. KPIs for delinquency rates by product. Output: cohort analysis, aging buckets, and visualization ideas.
53. Branch queue metrics: Role: branch operations. KPIs for wait times and service levels. Output: queue length, service level targets, and heatmaps.
54. Operational cost savings: You are a cost optimization analyst. KPIs for savings from process improvements. Output: project impact, ROI, and visualization prompts.
55. Remediation tracking: Role: risk remediation. KPIs for issue closure and control effectiveness. Output: remediation timelines, owners, and status dashboards.
56. Data quality health: You are a data governance lead. KPIs for data quality across domains. Output: accuracy, completeness, timeliness, and data lineage visuals.
57. Ledger integrity checks: Role: financial data steward. KPIs for ledger reconciliations. Output: reconciliation success rate, exception reasons, and cadence.
58. Regulatory readiness: You are a compliance strategist. KPIs for regulatory readiness posture. Output: control coverage, gap counts, and remediation plan visuals.
59. Customer activation metrics: Role: customer growth. KPIs for new customer activation and onboarding completion. Output: activation rate, time to activate, and cohort trends.
60. Credit line utilization: You are a credit risk analyst. KPIs for credit line utilization across products. Output: utilization distribution, risk-adjusted limits, and alerts.
61. Post-offer conversion: Role: product marketing. KPIs for post-offer conversions in lending. Output: conversion rate by channel, attribution, and follow-ups.
62. Digital adoption rate: You are a digital growth strategist. KPIs for digital channel adoption. Output: monthly active users, feature adoption, and funnel impact.
63. Cost per loan: Role: lending operations. KPIs for cost per loan origination. Output: cost components, normalization, and trend visuals.
64. Liquidity coverage trends: You are a liquidity analytics lead. KPIs for LCR trend analysis. Output: rolling LCR, drivers, and alert thresholds.
65. Capital adequacy prompts: Role: capital analytics. KPIs for capital adequacy ratios and buffers. Output: risk-weighted assets, CAR, and stress buffers.
66. Fintech partnerships: You are a partnerships analytics lead. KPIs for fintech collaboration impact. Output: revenue lift, cost savings, and partner performance dashboards.
67. Settlement accuracy: Role: settlements ops. KPIs for settlement timeliness and errors. Output: SLA adherence, error types, and reconciliation visuals.
68. SLA compliance prompts: You are an operations manager. KPIs for service level agreement adherence across teams. Output: targets, breach counts, and trend charts.
69. Voice of customer: Role: CX data scientist. KPIs from customer feedback. Output: sentiment scores, theme counts, and actionable insights.
70. Portfolio yield analysis: You are a portfolio analytics lead. KPIs for yield by asset class and product. Output: yield curves, risk-adjusted yield, and visualization ideas.
71. Client profitability: Role: relationship manager analytics. KPIs for client-level profitability. Output: revenue, costs, and margin by client with dashboard prompts.
72. Audit trail completeness: You are a governance officer. KPIs for audit trail quality. Output: completeness, tamper resistance, and reporting visuals.
73. Customer retention: Role: marketing analytics. KPIs for retention rates by cohort. Output: churn prevention metrics, and reactivation opportunities.
74. Fee income metrics: You are a pricing and revenue analytics lead. KPIs for fee-based income. Output: forecasted vs actual, per product, with visuals.
75. Account opening metrics: Role: onboarding analytics. KPIs for new account openings. Output: conversion journey, time to open, and source mix.
76. Agent performance metrics: You are a call center analytics lead. KPIs for agent productivity and quality. Output: handle time, first contact resolution, and customer satisfaction per agent.
77. Customer wait times: Role: branch and contact center ops. KPIs for wait times by channel. Output: median wait, service level, and improvement actions.
78. Product lifecycle KPIs: You are a product lifecycle analyst. KPIs for stages from ideation to sunset. Output: stage gates, time-in-stage, and go/no-go criteria.
79. Data latency metrics: Role: data engineering. KPIs for data freshness and latency. Output: ping times, pipeline delays, and impact visualization.
80. Regulatory change impact: You are a regulatory analytics lead. KPIs for change management impact. Output: impact scores, compliance risk, and roll-out plan visuals.
81. Capital market indicators: Role: treasury desk. KPIs for capital market movements affecting portfolios. Output: spreads, vol, and hedging effectiveness visuals.
82. Credit quality scorecards: You are a credit risk analyst. KPIs for scorecard performance. Output: calibration, holdout tests, and performance by segment.
83. Portfolio concentration: Role: risk portfolio manager. KPIs for concentration risk. Output: concentration metrics, diversification triggers, and dashboards.
84. KYC/AML health: You are a compliance analytics lead. KPIs for KYC and AML screening quality. Output: hit rate, false positives, and case aging.
85. Payment risk prompts: Role: payments risk analyst. KPIs for payment failures and fraud risk. Output: failure rate, investigation time, and remediation actions.
86. Client onboarding quality: You are a onboarding QA analyst. KPIs for onboarding data quality and process accuracy. Output: defect rates, rectification time, and audit trails.
87. Vendor SLA tracking: Role: vendor management. KPIs for third-party SLAs and performance. Output: SLA attainment, incident response, and vendor scorecards.
88. Product cross-sell scoring: You are a marketing analytics lead. KPI prompts to score cross-sell probability. Output: model inputs, risk checks, and recommended actions.
89. Transaction anomaly prompts: Role: fraud data scientist. KPIs for anomaly detection in transactions. Output: detection rate, false positives, and review queue KPIs.
90. Sustainability metrics: You are a sustainability analytics lead. KPIs linking ESG metrics to banking products. Output: scope, data sources, and visualization ideas.
91. Customer feedback loop: Role: CX operations. KPIs for closing the feedback loop with customers. Output: response time, issue resolution rate, and follow-up surveys.
92. Treasury risk dashboards: You are a treasury risk analyst. KPIs for treasury risk exposure and mitigations. Output: risk limits, exposure plots, and alert rules.
93. Liquidity forecast accuracy: Role: liquidity planning. KPIs for forecast accuracy by horizon. Output: MAE, MAPE, and forecast revision notes.
94. Digital channel efficiency: You are a digital operations lead. KPIs for digital channel efficiency and uptime. Output: outage duration, mean time to recover, and user impact.
95. Credit line approvals: Role: credit ops. KPIs for approval turnaround times. Output: time-to-approve, rejection reasons, and workload by underwriter.
96. Portfolio beta metrics: You are a risk analytics lead. KPIs for beta by portfolio to market movements. Output: beta estimates, confidence, and dashboard visuals.
97. Customer journey heatmap: Role: marketing data scientist. KPIs for journey heatmaps across touchpoints. Output: touchpoint counts, drop-offs, and improvement actions.
98. Fee waivers impact: You are a pricing analytics lead. KPIs for impact of fee waivers on revenue. Output: revenue, usage, and profitability effect.
99. Early warning indicators: Role: risk analyst. KPIs for early warning signals of portfolio stress. Output: trigger rules, data signals, and alert flows.
100. Dashboard governance prompts: You are a BI governance lead. KPIs for dashboard quality, discoverability, and version control. Output: catalog metadata, labeling standards, and adoption metrics.

Best Practices

• Keep prompts focused on a single KPI domain per prompt to maintain clarity.
• Define data lineage and sources within prompts to ease data integration.
• Use role-based prompts to align outputs with audience needs and governance.
• Incorporate data quality checks and privacy constraints in the prompts.
• Reuse prompts by cloning with updated data sources and thresholds while preserving structure.

Common Mistakes to Avoid

• Asking for too many metrics in one prompt, creating crowded dashboards that are hard to read.
• Neglecting data provenance, leading to trust issues in outputs.
• Using vague terms or missing placeholders, causing ambiguous results.
• Failing to specify audience, update cadence, or visualization preferences.
• Ignoring data privacy, stale data, or regulatory constraints in prompts.

FAQ

What is the purpose of KPI prompts for banks with Gemini?

They guide the creation of bank-specific KPIs and dashboards that reflect performance, risk, and customer experience.

How should I tailor prompts to my bank?

Replace placeholders with your institution's data domains, product lines, regions, and governance rules.

Can prompts cover regulatory metrics?

Yes, include data sources, thresholds, and validation steps to ensure compliance visibility.

How often should dashboards refresh?

Set a sensible cadence based on data source latency, typically daily or hourly for critical metrics.

Are these prompts safe for production use?

Yes, but validate outputs with data owners and implement access controls and data masking where needed.

How can I extend the prompts for new requirements?

Clone existing prompts and update scopes, data sources, and thresholds to fit new use cases.