Alerting & Anomaly Rules — Finance & FP&A
Design alerts that fire when it matters and stay silent otherwise. Purpose-built for finance & fp&a contexts.
A structured data analyst prompt for dashboards & visualization: design alerts that fire when it matters and stay silent otherwise, tailored to revenue, cost, and budget data where the numbers must reconcile. It walks the model through a proven process with an explicit quality bar, and delivers an alert spec.
The prompt
Variables to fill in: {{audience_decisions}}{{data_available}}{{tool}}
You are a data visualization specialist who builds dashboards people check voluntarily. I need your help in the context of revenue, cost, and budget data where the numbers must reconcile.
TASK: Design alerts that fire when it matters and stay silent otherwise.
DELIVERABLE: Produce an alert spec: which metrics deserve alerts, threshold logic (fixed, relative, seasonality-aware) per metric, the alert message content, and the noise-review cadence.
PROCESS:
1. Review the inputs below. If anything critical is missing or ambiguous, ask me up to three clarifying questions before producing the deliverable.
2. Start from the decisions the audience makes from the inputs; every element must serve one.
3. Choose chart forms by the comparison being made, not by what looks impressive.
4. Design the reading order: the answer first, the drill-down beneath, the caveats visible.
5. Produce the deliverable in a clean, skimmable format I can use directly.
QUALITY BAR:
- Every chart could be titled with the takeaway it shows.
- Honest axes, honest baselines, uncertainty shown where it matters.
- A first-time viewer knows what's good news vs. bad news without asking.
INPUTS:
- Who uses this and what decisions/questions it serves: {{audience_decisions}}
- The metrics and dimensions available, and their update cadence: {{data_available}}
- The BI tool in use: Tableau, Looker, Power BI, Metabase, etc.: {{tool}}Try it out
Open in Playground →Run this prompt on a real model without leaving the page. Every run is saved to your history for this prompt.
Fill in the variables
How to use
- 1Fill in the {{audience_decisions}}, {{data_available}}, {{tool}} variables with your real details — specifics in, specifics out.
- 2Paste the prompt into ChatGPT, Claude, Gemini, or any capable model.
- 3Answer the clarifying questions it asks; that step is what makes the output fit your situation.
- 4Iterate on the deliverable: ask for alternatives, tighter versions, or a different angle on any section.
Pro tips
- If the output feels generic, add more concrete detail to the inputs — names, numbers, and constraints sharpen everything.
- Works well in a thread: keep the conversation going to refine an alert spec.