Data Analysis · IT & Software

Analyse a dataset and find key insights for IT & Software

Use this when you have data but no clear picture of what it says. Written for a software company that ships a SaaS product.

Your prompt is ready 3 brackets to fill
You are a senior data analyst, working with engineering leads, developers and IT buyers at a software company that ships a SaaS product.

## Goal
Explore a dataset and explain the most useful findings in plain language.

## What matters in IT & Software
- Numbers that matter: deployment frequency; lead time for changes; change failure rate; mean time to recovery; uptime against SLA; MRR/ARR; net revenue retention; logo churn.
- Tools commonly used: GitHub or GitLab; Jira; Slack; AWS, Azure or GCP; Datadog or Grafana; PostgreSQL or MySQL.
- Rules and standards that usually apply: data-protection law (GDPR in the EU, the DPDP Act 2023 in India, CCPA in California); SOC 2 or ISO 27001 security audits; OWASP secure-coding practice; open-source licence terms; the uptime and support promises in customer SLAs.
- Rules differ by country. If I have not said where I work, ask me, and do not present one country's law as if it applied everywhere.

## What I will give you
- The data: [PASTE DATA OR DESCRIBE COLUMNS]
- Business question: [WHAT YOU WANT TO KNOW]
- Tool: [Excel, Google Sheets, Python, SQL]

## What to do
1. Describe the data: rows, columns, types and quality problems.
2. Clean the data and list what you changed.
3. Answer the business question with numbers.
4. Find 3 to 5 other notable patterns or outliers.
5. Recommend actions and what to analyse next.

## What to deliver
- Data quality summary
- Findings with numbers
- Suggested charts
- Recommendations
- Formulas or code used

## Rules
- Keep uptime, security and data-protection requirements in mind throughout, and point out anything in my plan that would break them.
- Where it fits, connect your recommendations to deployment frequency and uptime.
- Use plain language and short sentences. Use headings and tables where they make the answer easier to scan.
- Do not invent figures, laws, sources or quotes. Mark anything you had to assume with "Assumption:".
- If something important is missing, ask me up to 3 short questions before you start.

## Before you answer
Check your draft against this list and fix anything that fails:
- Every number comes from my data or is marked as an assumption, and correlation is never presented as cause.
- It is written for a software company that ships a SaaS product; nothing in it would read the same for any other business.
- Every item under "What to deliver" is included.
Open in ChatGPT Claude Perplexity

How to use this prompt

  1. Copy the prompt. Press Copy prompt and the full text goes to your clipboard.
  2. Fill the brackets. Use the form above, or replace [PASTE DATA OR DESCRIBE COLUMNS], [WHAT YOU WANT TO KNOW], [Excel, Google Sheets, Python, SQL] with your own details.
  3. Paste and send. Paste it into ChatGPT, Claude, Gemini and DeepSeek and send. Ask follow-up questions to refine the answer.

Why this prompt works

The “Analyse a dataset and find key insights” prompt tells the assistant exactly what to hand back: data quality summary; findings with numbers; suggested charts; recommendations; and formulas or code used. It makes the assistant work through 5 steps in order, starting with "describe the data: rows, columns, types and quality problems", instead of jumping straight to an answer. Before replying, the assistant checks its draft against 3 tests and fixes anything that fails.

This version is written for a software company that ships a SaaS product, so the assistant keeps uptime, security and data-protection requirements in mind and judges the result by deployment frequency and uptime. If an important detail is missing, it asks you up to 3 short questions before it starts.

How to get the best answer

  1. Fill every bracket with real detail: [PASTE DATA OR DESCRIBE COLUMNS], [WHAT YOU WANT TO KNOW], [Excel, Google Sheets, Python, SQL] should hold real names, numbers and dates, not placeholders.
  2. Paste real material: where the prompt asks for notes, data or text, paste the actual content rather than a summary.
  3. Refine in the same chat: ask "make it shorter", "turn it into a table" or "add more detail on step 2".
  4. Check the result: review it against what you know about deployment frequency and uptime before you share it.

Other industries

Same prompt for other industries

The same analyse a dataset and find key insights prompt, rewritten for each industry.

FAQ

Frequently asked questions

Which AI assistant works best with the “Analyse a dataset and find key insights” prompt?

The “Analyse a dataset and find key insights” prompt works in any chat assistant and suits ChatGPT, Claude, Gemini and DeepSeek best. Paste it in, send it, and ask follow-up questions in the same chat to refine the answer.

What do I fill in before sending the “Analyse a dataset and find key insights” prompt?

Replace the 3 highlighted brackets – [PASTE DATA OR DESCRIBE COLUMNS], [WHAT YOU WANT TO KNOW], [Excel, Google Sheets, Python, SQL] – with your own details. The more specific you are, the better the answer.

Is the “Analyse a dataset and find key insights” prompt only for IT & Software?

No. This version is written for a software company that ships a SaaS product, and the same prompt is also written for 15 other industries, listed on this page.

Is the “Analyse a dataset and find key insights” prompt free to use?

Yes. First AI Prompt prompts are free to copy and use in personal and business work, with no sign-up, no account and no daily limit.

Can I trust the answer the “Analyse a dataset and find key insights” prompt gives?

Treat it as a strong first draft: the prompt tells the assistant not to invent facts and to mark its assumptions, but check figures yourself, especially anything with legal, financial or safety consequences.

Keep exploring

Browse more IT & Software prompts