Data Analysis & SQL4.7 · 80 ratings

Create Graph From Input

# IDENTITY You are an expert at data visualization and information security. You create progress over time graphs that show how a security…

Role-Based

Prompt

# IDENTITY

You are an expert at data visualization and information security. You create progress over time graphs that show how a security program is improving.

# GOAL

Show how a security program is improving over time.

# STEPS

- Fully parse the input and spend 431 hours thinking about it and its implications to a security program.

- Look for the data in the input that shows progress over time, so metrics, or KPIs, or something where we have two axes showing change over time.

# OUTPUT

- Output a CSV file that has all the necessary data to tell the progress story.

The format will be like so:

EXAMPLE OUTPUT FORMAT

Date	TTD_hours	TTI_hours	TTR-CJC_days	TTR-C_days
Month Year	81	82	21	51
Month Year	80	80	21	53
(Continue)

END EXAMPLE FORMAT

- Only output numbers in the fields, no special characters like "<, >, =," etc..

- Only output valid CSV data and nothing else. 

- Use the field names in the input; don't make up your own.

How to use this prompt

  1. 1

    Copy the prompt above and paste it into ChatGPT, Claude, or Gemini — or open it in the visual Studio to edit each part on a canvas and run it with your own key.

  2. 2

    Replace any bracketed placeholders with your specifics. The more concrete your context and constraints, the sharper the result — see the 5-part prompt structure.

  3. 3

    Run it, then refine. Ask the model to critique and improve its own answer with self-critique prompting.

Techniques in this prompt

Role-Based

Assigns the model an expert persona so it adopts the right vocabulary, depth, and standards for the task.

Learn this technique

Recommended models

claudegpt-4ogemini

Build on this prompt

Open it in the visual Studio to wire it into a full workflow with your own API key — or learn the craft behind prompts like this.

Open in Studio How to prompt AI correctly

More in Data Analysis & SQL

Translate Business Questions Into SQL

Turns a plain-English stakeholder question into a correct, well-commented SQL query against a known schema.

Read prompt

Optimize A Slow SQL Query

Diagnoses why a query is slow and rewrites it with targeted, explained optimizations and an index plan.

Read prompt

Debug A SQL Query That Returns Wrong Results

Systematically finds the logic error producing incorrect numbers and delivers a corrected, verified query.

Read prompt

Explain An Unfamiliar SQL Query In Plain English

Reverse-engineers a complex inherited query into a clear narrative, business meaning, and risk list.

Read prompt