Gemini Data Analysis advanced

KPI Dashboard Designer

Added Apr 2, 2026

You are a business intelligence consultant specializing in KPI framework design and dashboard architecture. Help me design a comprehensive KPI dashboard. Business type: [BUSINESS_TYPE] Department or function: [DEPARTMENT] Primary business goals: [BUSINESS_GOALS] Current data sources available: [DATA_SOURCES] Please design a complete dashboard specification: 1. Identify the 8-12 most critical KPIs for this context, organized into a hierarchy of leading and lagging indicators 2. For each KPI, define: the exact calculation formula, data source, refresh frequency, target or benchmark, and red/yellow/green threshold values 3. Design the dashboard layout with specific widget placement, specifying which KPIs should be scorecards, trend lines, gauges, or comparison charts 4. Create a visual hierarchy that puts the most actionable metrics above the fold and detailed breakdowns below 5. Define drill-down paths showing how each top-level metric can be decomposed for root cause analysis 6. Recommend alert rules for metrics that need proactive notification when they deviate from targets 7. Include a suggested filter panel with the most useful dimension slicers for this business context 8. Specify the ideal dashboard refresh cadence and any real-time requirements

Try in Gemini

About This Prompt

This prompt generates a complete KPI dashboard specification including metric selection, calculation formulas, layout design, and drill-down architecture. Instead of guessing which metrics matter, you get a structured framework built on business intelligence best practices. It covers everything from choosing the right leading and lagging indicators to defining alert thresholds and filter panels. The output is detailed enough to hand directly to a BI developer or implement yourself in tools like Tableau, Power BI, or Looker. It is ideal for operations leaders, startup founders, and analysts who need to build dashboards that drive action rather than just display numbers.

Variables to Customize


[BUSINESS_TYPE]

The type of business or industry

Example: B2B SaaS company with $5M ARR, 200 customers


[DEPARTMENT]

The team or function this dashboard serves

Example: Customer Success team


[BUSINESS_GOALS]

The primary objectives this dashboard should track

Example: Reduce churn from 8% to 4% annually, increase NRR to 115%, improve time-to-value for new customers


[DATA_SOURCES]

Available data systems and tools

Example: Salesforce CRM, Stripe billing, Intercom support tickets, Mixpanel product analytics, PostgreSQL data warehouse

Tips for Best Results

Include your current pain points so the dashboard design prioritizes metrics that address real gaps
Mention who will view this dashboard daily versus weekly since it affects layout and detail level
Specify if you need mobile-friendly layouts since this constrains the number of widgets per row

Example Output

**Dashboard: Customer Success Command Center**

**Row 1 - Health Overview (above the fold):**
- Large scorecard: Net Revenue Retention (NRR) - Current: 108%, Target: 115%, Status: Yellow
- Gauge: Monthly Churn Rate - Current: 0.7%, Threshold: Green <0.33%, Yellow 0.33-0.67%, Red >0.67%
- Trend line: Customer Health Score distribution over 12 months

**KPI #1: Net Revenue Retention**
- Formula: (Starting MRR + Expansion - Contraction - Churn) / Starting MRR
- Source: Stripe billing API
- Refresh: Daily...

kpi dashboard business-intelligence metrics reporting

Also Featured In

Best Gemini Prompts for Data Analysis AI Prompts for Data Analysts Best Gemini Prompts