Data AnalystVisualizationIntermediateSingle prompt

Waterfall Chart for Change Analysis AI Prompt

Waterfall Chart for Change Analysis is a intermediate prompt for visualization. This prompt helps the AI turn raw data into charts or dashboards that communicate insight clearly. It goes beyond simply plotting values by asking for chart choice, layout, annotations, and business interpretation. Use it when you need visuals that are ready for exploration, reporting, or stakeholder communication. It is best suited for direct execution against a real dataset. The requested output can include more technical detail, prioritization, and interpretation while still staying practical.

Prompt text
Create a waterfall chart to show how a metric changed between two periods:

1. Identify the starting value (e.g. last month's total) and ending value (this month's total)
2. Decompose the change into its contributing factors — what drove the increase or decrease? (look for dimension columns like region, product, channel)
3. Build a waterfall chart where:
   - First bar: starting value (blue)
   - Middle bars: positive contributors (green, going up) and negative contributors (red, going down)
   - Final bar: ending value (blue)
4. Add value labels on top of each bar
5. Add a dashed horizontal reference line at the starting value
6. Sort contributing factors from largest positive to largest negative

Title the chart: '[Metric]: [Start Period] to [End Period] — What Changed and Why'

When to use this prompt

Use case 01

When you need a chart or dashboard that highlights the key message clearly.

Use case 02

When a table alone is not enough for stakeholders to understand the result.

Use case 03

When you want a presentation-ready visual with labels, annotations, and styling guidance.

Use case 04

When comparing segments, trends, correlations, or composition visually.

What the AI should return

The AI should return the recommended chart specification, plotting code when appropriate, and a short interpretation of what the visual is meant to show. Titles, labels, annotations, and layout choices should be explicit so the output is presentation-ready rather than generic. If multiple charts are requested, they should be organized in a logical order and tied back to a single story. The final answer should make it clear what the viewer should notice first.

How to use this prompt

1

Open your data context

Load your dataset, notebook, or working environment so the AI can operate on the actual project context.

2

Copy the prompt text

Use the copy button above and paste the prompt into the AI assistant or prompt input area.

3

Review the output critically

Check whether the result matches your data, assumptions, and desired format before moving on.

4

Chain into the next prompt

Once you have the first result, continue deeper with related prompts in Visualization.

Frequently asked questions

What does the Waterfall Chart for Change Analysis prompt do?+

It gives you a structured visualization starting point for data analyst work and helps you move faster without starting from a blank page.

Who is this prompt for?+

It is designed for data analyst workflows and marked as intermediate, so it works well as a guided starting point for that level of experience.

What type of prompt is this?+

Waterfall Chart for Change Analysis is a single prompt. You can copy it as-is, adapt it, or use it as one step inside a larger workflow.

Can I use this outside MLJAR Studio?+

Yes. The prompt text works in other AI tools too, but MLJAR Studio is the best fit when you want local execution, visible Python code, and reusable notebooks.

What should I open next?+

Natural next steps from here are Auto Exploratory Dashboard, Bar Chart with Ranking, Correlation Heatmap.