Data AnalystVisualizationIntermediateSingle prompt

Executive KPI Dashboard AI Prompt

Executive KPI Dashboard 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 an executive-ready KPI dashboard for this dataset.

1. Identify the 4–6 most important business metrics from the column names and data context
2. For each metric, create a time-series line chart with:
   - A trend line (7-day rolling average)
   - An annotation marking the most significant change point
   - Clear title, axis labels, and current value callout
3. Add a summary row at the top showing: current value, % change vs prior period, and a directional arrow (▲▼)
4. Use a consistent color palette — brand-neutral (blues and grays)
5. Layout should be presentation-ready (16:9 aspect ratio)

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 Executive KPI Dashboard 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?+

Executive KPI Dashboard 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.