Open Prompts
Submit a prompt
Analysis

Write Parameterized Dashboard SQL Queries

List the filter dimensions users can apply, the key metrics shown, the drill-down hierarchy, the comparison periods needed, the database engine, and the relevant tables, and this prompt writes the parameterized SQL query layer behind an interactive dashboard. Each panel's query accepts filter parameters using {{parameter_name}} syntax, returns data shaped for its visualization, is written for sub-second interactive response, and handles edge cases like empty filters meaning "all data" or invalid date ranges.

Prompt
Write parameterized SQL queries for a reporting dashboard.

Dashboard requirements:
- Users can filter by: {filter_dimensions}
- Key metrics shown: {metrics}
- Drill-down levels: {drill_down_levels}
- Comparison periods: {comparison_periods}

For each dashboard panel, write a query that:
- Accepts filter parameters (using {{parameter_name}} syntax)
- Returns data shaped for the visualization
- Performs well for interactive use (sub-second response)
- Handles edge cases (empty filters meaning all data, invalid dates, etc.)

Database: {database_type}
Tables: {tables}
Download .md

Variables

Related prompts

Analysis

Critique And Improve A Chart

Reviews a chart — its type, intended message, underlying data, and any suspected issues — before it goes into a deck or report. - Checks: whether the chart type fits the data relationship, honest visual encoding, data-to-ink ratio - Tests: whether the key insight lands within 5 seconds and holds up in black and white or for colorblind readers - Output: concrete before/after fixes, not just a list of complaints

Analysis

Design A Business Metrics Dashboard

Plans a dashboard for a given audience and business area before it gets built in a BI tool, based on a metrics list, user goals, refresh frequency, and target tool. Specifies the layout, chart type per metric with reasoning, filter and drill-down controls, a color-coding scheme, alert thresholds, and mobile considerations, all built around whether a viewer can pass the 5-second glance test.

Analysis

Design An Interactive Data Visualization

Specifies an interactive exploration tool for a dataset's dimensions and metrics, covering layout, filter and drill-down behavior between named levels, comparison views, hover details, transitions, and the default view a user sees before touching anything. Adds a tool-specific implementation plan and performance notes for the expected row count, plus working Plotly Dash or Streamlit prototype code when the target tool is Python-based.