Design a [TYPE] dashboard for [AUDIENCE/ROLE].
Type: [EXECUTIVE / OPERATIONAL / ANALYTICAL / STRATEGIC]
Tool: [TABLEAU / POWER BI / LOOKER / GOOGLE DATA STUDIO / METABASE]
Data sources: [DESCRIBE]
Provide:
1. **Dashboard Purpose**: One sentence — what decision does this help make?
2. **Layout Wireframe**: Placement of charts, filters, KPIs (top-down hierarchy)
3. **KPI Cards**: Top 4-6 headline metrics with sparklines and comparison periods
4. **Chart Selection**: For each data story, which chart type and why (bar vs line vs scatter etc.)
5. **Filter Design**: Which filters, where to place them, default values
6. **Interactivity**: Drill-downs, cross-filtering, tooltips
7. **Color Strategy**: Consistent meaning (green = good, red = alert), accessibility
8. **Refresh Cadence**: How often data updates and how to communicate "as of" time
9. **Mobile Considerations**: How it adapts for phone/tablet viewing
10. **SQL Queries**: The key queries powering each chart
Design a [TYPE] dashboard for [AUDIENCE/ROLE].
Type: [EXECUTIVE / OPERATIONAL / ANALYTICAL / STRATEGIC]
Tool: [TABLEAU / POWER BI / LOOKER / GOOGLE DATA STUDIO / METABASE]
Data sources: [DESCRIBE]
Provide:
1. **Dashboard Purpose**: One sentence — what decision does this help make?
2. **Layout Wireframe**: Placement of charts, filters, KPIs (top-down hierarchy)
3. **KPI Cards**: Top 4-6 headline metrics with sparklines and comparison periods
4. **Chart Selection**: For each data story, which chart type and why (bar vs line vs scatter etc.)
5. **Filter Design**: Which filters, where to place them, default values
6. **Interactivity**: Drill-downs, cross-filtering, tooltips
7. **Color Strategy**: Consistent meaning (green = good, red = alert), accessibility
8. **Refresh Cadence**: How often data updates and how to communicate "as of" time
9. **Mobile Considerations**: How it adapts for phone/tablet viewing
10. **SQL Queries**: The key queries powering each chart
How to use this prompt
Copy the prompt above and paste it into ChatGPT, Claude, Gemini, or any AI assistant. Replace the bracketed placeholders with your specific details.
Leave a Review
Tried this prompt? Let us know how it worked — your reviews help other users find the best prompts.