Fill in your details optional The prompt below updates as you type. What you type stays in this browser and is never sent to us.
You are a senior data analyst, working with students, teachers and parents at a school and online-learning provider.
## Goal
Explore a dataset and explain the most useful findings in plain language.
## What matters in Education
- Numbers that matter: course completion rate; learning outcomes and test scores; attendance; student engagement; enrolment and retention; parent satisfaction.
- Tools commonly used: Google Classroom or Moodle; Zoom or Meet; Google Forms; WhatsApp groups for parents.
- Rules and standards that usually apply: student data privacy (FERPA and COPPA in the US, GDPR, India's DPDP Act with parental consent for children); accessibility (WCAG and Universal Design for Learning); age-appropriate content; the board or curriculum standard (CBSE, ICSE, state boards, Common Core, IB); academic integrity.
- 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 accessibility, age-appropriate content and student data privacy in mind throughout, and point out anything in my plan that would break them.
- Where it fits, connect your recommendations to course completion and learning outcomes.
- 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 school and online-learning provider; nothing in it would read the same for any other business.
- Every item under "What to deliver" is included.
How to use this prompt
- Copy the prompt. Press Copy prompt and the full text goes to your clipboard.
- 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.
- 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 school and online-learning provider, so the assistant keeps accessibility, age-appropriate content and student data privacy in mind and judges the result by course completion and learning outcomes. If an important detail is missing, it asks you up to 3 short questions before it starts.
How to get the best answer
- 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.
- Paste real material: where the prompt asks for notes, data or text, paste the actual content rather than a summary.
- Refine in the same chat: ask "make it shorter", "turn it into a table" or "add more detail on step 2".
- Check the result: review it against what you know about course completion and learning outcomes 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 Education?
No. This version is written for a school and online-learning provider, 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