AI prompts for data analysis
Prompts to analyse spreadsheets and CSVs, design KPI dashboards and surveys, write SQL and pandas scripts, forecast trends and plan A/B tests. Works with ChatGPT, Claude and Gemini.
- 100% free, no sign-up
- One-click copy
- Open directly in ChatGPT or Claude
Analyse a spreadsheet or CSV
Works with: ChatGPT, Claude, Gemini
I am uploading a dataset about [topic]. First describe the columns, data types and any quality issues (missing values, duplicates, outliers). Then find the 5 most important insights for [business question], create suitable charts, and summarise the findings in plain language for a non-technical manager.
KPI dashboard designer
Works with: ChatGPT, Claude
Design a KPI dashboard for [team / business] whose goal is [goal]. List 8 to 12 metrics with definitions and formulas, data sources, target and alert thresholds, the best chart type for each, and a layout from most to least important. Note which metrics are leading vs lagging.
Survey design
Works with: ChatGPT, Claude, Gemini
Design a survey to learn [research goal] from [audience]. Write 12 to 15 unbiased questions mixing multiple choice, rating scales and 2 open-ended questions. Order them logically, avoid leading wording, estimate completion time, and explain how to analyse the results.
SQL from plain English
Works with: ChatGPT, Claude, Gemini
Tables: [paste table names and columns] Write SQL to answer: [business question in plain English]. Then explain the query in simple terms, show what the output columns mean, and suggest one follow-up query that would give deeper insight.
Forecast from historical data
Works with: ChatGPT, Claude, Gemini
Here is my monthly [sales / traffic / sign-ups] data for the last [number] months: [paste data]. Identify the trend and seasonality, forecast the next 6 months with a best, expected and worst case, explain the method in plain language, and list the assumptions that could break the forecast.
A/B test planner and analyser
Works with: ChatGPT, Claude
I want to test [change] on [page / email / app screen]. Current conversion rate: [rate]. Traffic: [visitors per week]. Write the hypothesis, primary and guardrail metrics, required sample size for a meaningful result, test duration, and how to read the result. If I paste results later, tell me whether the difference is statistically significant.
Python data cleaning script
Works with: ChatGPT, Claude, Gemini
Write a Python pandas script that loads [file], cleans it by [handling missing values, fixing data types, removing duplicates, standardising text in columns X and Y], creates [new columns], and saves a clean file. Add comments, a summary of rows changed, and checks that fail loudly if the data looks wrong.
Explain a chart or report to my boss
Works with: ChatGPT, Claude, Gemini
Here is a chart / table: [paste or upload]. Explain what it shows in 3 sentences, the single most important takeaway, what might be causing it, what we should do next, and one question my manager is likely to ask with a prepared answer.
No prompts match your search. Try another keyword, or search the full library.
Data and Analysis prompts: FAQ
Can ChatGPT analyse my Excel or CSV file?
Yes. ChatGPT, Claude and Gemini can read uploaded files, describe the data, find patterns and create charts. Check important numbers against the source.
Can AI write SQL queries?
Yes, if you give it your table names and columns. Ask it to explain the query and test it on a small sample before using it in production.
Are these prompts free to use?
Yes. Every prompt in the Softsols AI prompt library is free to copy, edit and use for personal or commercial work.
How do I customise a prompt?
Replace everything in [square brackets] with your own details. The more specific your context, audience and desired format, the better the result.
More AI prompt categories
Browse 160 free prompts across 14 categories, or search the full library.
Business and Strategy prompts
Copy-ready prompts for founders, managers and consultants.
12 prompts →Marketing and SEO prompts
Prompts for SEO outlines, AI Overview optimisation, landing pages, Google Ads, personas, newsletters, case studies and full campaign plans.
13 prompts →Sales and Email prompts
Prompts for cold emails, follow-ups, LinkedIn outreach, discovery calls, objection handling, proposals, battlecards and WhatsApp sales messages.
12 prompts →Coding and Dev prompts
Prompts for code review, debugging, tests, refactoring, API design, security audits, SQL, Docker and CI pipelines, plus specs for AI coding agents.
13 prompts →Writing and Content prompts
Prompts to write in your own voice, sound human, repurpose content, polish emails, write press releases, product descriptions, speeches and course outlines.
12 prompts →Social Media prompts
Prompts for content calendars, viral hooks, LinkedIn posts, carousels, captions, YouTube scripts, bios, trend adaptations and community replies.
12 prompts →Image Generation prompts
Viral and practical image prompts.
15 prompts →AI Video prompts
Text-to-video prompts and scripts for product ads, travel reels, UGC-style ads, explainers, storyboards, photo animation and podcast clips.
9 prompts →Productivity prompts
Prompts to plan your week, clear your inbox, summarise documents, write formulas, make decisions, budget, plan trips and meals, and build habits.
11 prompts →Career and Resume prompts
Prompts for ATS-friendly resumes, cover letters, mock interviews, salary negotiation, LinkedIn profiles, freelance proposals and career change plans.
12 prompts →Learning and Study prompts
Prompts to explain any topic, build learning roadmaps, get Socratic tutoring, make flashcards, summarise papers, practise languages and debate.
11 prompts →AI Agents and Automation prompts
Prompts to design AI agents, write system prompts, plan RAG chatbots, design MCP tools, build no-code automations and evaluate AI output.
12 prompts →E-commerce prompts
Prompts for product listings, abandoned cart emails, review replies, returns policies, sale campaigns, bundles and upsells, support macros and niche research.
8 prompts →Want a custom AI assistant trained on your business?
We design, build and deploy AI chatbots, copilots and agents for companies in the US, UK, Singapore and Pakistan.