Dashboard Performance Optimization Auditor
Diagnoses slow dashboards and prescribes query, model, and rendering optimizations ranked by impact.
Prompt
You are a BI performance engineer who makes slow dashboards fast. CONTEXT: The dashboard on [TOOL_NAME] loads in [CURRENT_LOAD_TIME] against [DATA_VOLUME] rows. Symptoms are [PERF_SYMPTOMS] such as slow filters and spinning visuals. The backend is [DATA_BACKEND]. TASK STEPS: 1. Enumerate the likely bottleneck layers: query, data model, visual count, and rendering. 2. For each layer, list concrete diagnostics to confirm where time is spent. 3. Prescribe optimizations (aggregations, extracts, indexing, reducing visuals, query folding) ranked by expected speedup. 4. Identify any anti-patterns present and the safest fix order. 5. Define a target load time and how to verify the improvement. OUTPUT FORMAT: Bottleneck Map, Diagnostics Checklist, Optimization Plan (table: Fix | Layer | Effort | Expected Gain), Anti-Patterns Found, and Verification Plan. CONSTRAINTS: Order fixes by impact-to-effort ratio; never recommend changes that alter metric definitions; preserve data freshness requirement [FRESHNESS_SLA]; quantify expected gains where possible.
How to use this prompt
- 1
Copy the prompt above and paste it into ChatGPT, Claude, or Gemini — or open it in the visual Studio to edit each part on a canvas and run it with your own key.
- 2
Replace any bracketed placeholders with your specifics. The more concrete your context and constraints, the sharper the result — see the 5-part prompt structure.
- 3
Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.
Techniques in this prompt
Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.
Learn this techniqueForces explicit intermediate reasoning instead of jumping to a conclusion, which improves accuracy on hard tasks.
Learn this techniqueRecommended models
Build on this prompt
Open it in the visual Studio to wire it into a full workflow with your own API key — or learn the craft behind prompts like this.
More in Data Visualization & BI Dashboards
Executive KPI Dashboard Blueprint Architect
Designs a single-screen executive KPI dashboard layout with metric hierarchy, chart selection, and drill-down logic.
Chart Type Selection Decision Tree
Reasons step by step from data shape and analytic intent to the optimal chart type with ranked alternatives.
SQL-to-Dashboard Metric Layer Definer
Translates raw tables into a governed semantic metric layer with definitions, grains, and reusable measures.
Dashboard Redesign Critique and Rework
Critiques an existing dashboard against visualization best practices, then prescribes a concrete redesign.