Open Prompts
Submit a prompt
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.

Prompt
Design a data dashboard for {audience} that tracks {business_area}.

Key metrics to display:
{metrics_list}

User goals: {user_goals}
Data refresh frequency: {refresh_frequency}
Tool: {tool}

Produce:
1. The dashboard layout (placement of each element)
2. Chart type per metric, with reasoning
3. Needed filter and drill-down controls
4. A color scheme and encoding rules (what each color means)
5. Alert thresholds (values that should trigger visual warnings)
6. Mobile/responsive considerations
7. The "glance test": what should a viewer understand within 5 seconds?
Download .md

Variables

Related prompts

Analysis

Plan Visuals For A Business Report

Name the reporting cadence, the business area, and up to four report sections, and this prompt plans an entire recurring report's worth of visuals at once. For each section it recommends 2-3 charts with the exact source columns and encoding, writes a chart title that states the finding rather than just describing the data, and adds a fill-in-the-blank caption template, then generates a rerunnable Python script that builds every chart from one DataFrame and exports consistently styled PNGs each period.

Analysis

Build A Full Data Dictionary

Documents a dataset column by column for a team about to receive it, using its name, source system, refresh frequency, and column list as inputs. - Per column: type, business meaning, source, valid values or range, null handling - Also covers: dependencies, known quality issues, and 3-5 example values - Output: a clean markdown table plus a JSON schema ready for automated validation

Analysis

Create A Reusable KPI Report Template

Builds a fill-in-ready KPI report template for a business area, its KPI list, reporting frequency, and audience, meant to be generated once and reused every period. Includes a header section, a red/yellow/green scorecard, per-KPI detail with trend and variance from target, a commentary section, action items for underperforming metrics, and a data-definitions appendix explaining how each number is calculated.