Back to guide/Research & Analysis

Dashboard Design Spec

Defining the key questions the dashboard must answer at a glance prevents scope creep and ensures every widget earns its space. Specifying the audience expertise level calibrates complexity.

chatgpt-prompts-for-data-analysisdashboard_purposetarget_usersdata_sources

Edit View

Prompt

Design a dashboard for {{dashboard_purpose}} used by {{target_users}}.

Data sources available: {{data_sources}}
Key metrics to track: {{key_metrics}}
Update frequency: {{update_frequency}}
Tool: {{dashboard_tool}}

Provide:
1. Dashboard layout (which charts go where, with wireframe description)
2. For each chart/widget:
   - Metric shown
   - Chart type and why
   - Filters or drill-down capability needed
   - Thresholds or conditional formatting rules
3. Global filters (date range, {{filter_dimensions}})
4. A "north star" KPI that should be the most prominent element
5. Mobile considerations if applicable

Design for a {{expertise_level}} audience — choose complexity accordingly. The dashboard should answer these questions at a glance: {{key_questions}}

Variables to customize

{{dashboard_purpose}}{{target_users}}{{data_sources}}{{key_metrics}}{{update_frequency}}{{dashboard_tool}}{{filter_dimensions}}{{expertise_level}}{{key_questions}}

Why this prompt works

Defining the key questions the dashboard must answer at a glance prevents scope creep and ensures every widget earns its space. Specifying the audience expertise level calibrates complexity.

Save this prompt to your library

Organize, version, and access your best prompts across ChatGPT, Claude, and Cursor.

Related prompts

SQL Query Writer

Providing the full schema and relationships eliminates guesswork. Asking for comments and assumption flags makes the output reviewable and trustworthy before running against production.

Data Cleaning Script

Requiring before/after logging and a summary report turns a cleaning script into an auditable process. Flagging rows for manual review prevents silent data loss.

Visualization Recommendation

Starting from the insight rather than the chart type ensures the visualization serves the story. Asking for common mistakes prevents the most frequent data viz errors.

Statistical Analysis Guide

Listing confounders and asking for assumption checks prevents the common mistake of running a test on data that violates its assumptions. The plain-English interpretation ensures you understand the results.