Design data dashboards with KPI selection, layout, and visualization best practices.
## Dashboard Design & KPI Framework Design a dashboard for [DEPARTMENT/FUNCTION]: **Department:** [DEPARTMENT — Sales/Marketing/Product/Finance/Operations/Support] **Audience:** [AUDIENCE — executive/manager/analyst/all-hands] **Tool:** [TOOL — Tableau/Power BI/Looker/Metabase/Google Data Studio] **Update Frequency:** [FREQUENCY — real-time/hourly/daily/weekly] **Dashboard Framework:** ### 1. KPI Selection (5-7 key metrics) **North Star Metric:** [NORTH_STAR — the single most important metric] **Supporting KPIs:** | KPI | Definition | Target | Source | Update Freq | |---|---|---|---|---| | [KPI_1] | [DEFINITION] | [TARGET] | [TABLE/API] | [FREQ] | | [KPI_2] | [DEFINITION] | [TARGET] | [TABLE/API] | [FREQ] | | [KPI_3] | [DEFINITION] | [TARGET] | [TABLE/API] | [FREQ] | ### 2. Layout Design (F-pattern reading) ``` ┌─────────────────────────────────────┐ │ Title │ Date Filter │ Segment │ ├─────────────────────────────────────┤ │ KPI 1 │ KPI 2 │ KPI 3 │ KPI 4 │ ← Summary cards ├────────────────────┬────────────────┤ │ │ │ │ Primary Chart │ Secondary │ ← Trend + breakdown │ (Time series) │ (Pie/bar) │ ├────────────────────┴────────────────┤ │ Detail Table / Heatmap │ ← Drill-down data ├─────────────────────────────────────┤ │ Annotations / Insights │ ← Context └─────────────────────────────────────┘ ``` ### 3. Visualization Selection | Data Type | Recommended Chart | Why | |---|---|---| | Trend over time | Line chart | Shows direction and seasonality | | Part of whole | Donut/pie (≤5 segments) | Easy proportional comparison | | Comparison | Horizontal bar | Easy to read labels | | Distribution | Histogram/box plot | Shows spread and outliers | | Correlation | Scatter plot | Reveals relationships | | Geographic | Map/choropleth | Spatial patterns | ### 4. Interactivity - Filters: Date range, segment, region, product - Drill-down: Click KPI card → detail view - Tooltips: Hover for additional context - Alerts: Conditional formatting for thresholds **Variables:** Replace [DEPARTMENT], [AUDIENCE], [TOOL], [FREQUENCY].
Free to copy and use. Compatible with Claude 4 Opus, Gemini 2.5 Pro.
Replace all [BRACKETED] variables with your specific data and requirements.
Initial release
Sign in and download this prompt to leave a review.