By Use Case

How to Use AI for Data Analysis

Use AI to interpret data, write SQL, and turn raw numbers into clear business insights.

7 min read

Data analysis has two distinct phases: the technical work of extracting and processing data, and the interpretive work of turning numbers into insight and insight into decisions. AI helps at both stages — writing SQL for the extraction, and helping explain what the results actually mean. For non-technical business people, it lowers the barrier to data access entirely. For data professionals, it accelerates routine query writing and communication.

Writing and Debugging SQL Queries

SQL is often the first barrier between business people and their own data. AI removes it. To get a working query: describe your database tables (table names, relevant column names and types), and the business question you want answered in plain English. Ask AI to write the SQL and explain what each clause does. For example: 'I have a users table (user_id, created_at, plan_type) and an events table (user_id, event_type, occurred_at). Write a query that shows me monthly active users by plan type for the last 12 months — monthly active defined as at least one event in that calendar month.' The more specific your table description and question, the more accurate the query.

Exploratory Data Analysis

When you have a new dataset, the first step is understanding its shape: what patterns exist, what's missing, what outliers are present, and what questions are worth asking. AI can accelerate this exploration when you provide data samples. Paste a subset of your dataset (anonymized where necessary) and ask: 'What patterns do you notice in this data? What are the anomalies? What are the most interesting trends to investigate further?' This doesn't replace statistical analysis, but it helps you figure out which statistical analyses are worth running. Think of it as a fast first pass that guides deeper investigation.

Interpreting Results in Business Context

Numbers don't make decisions — interpretations do. The leap from 'conversion rate dropped 2.3 percentage points' to 'here's what we think is causing it and what we should do' requires someone to connect the data to the business context. AI can help structure this interpretation when you provide both the data and the context. Describe the metric, the trend you're observing, relevant business context (a recent campaign, a product change, a seasonal pattern), and ask: 'What are three plausible explanations for this trend? What additional data would help distinguish between them?' This structured hypothesis generation is faster and more thorough than unstructured brainstorming.

Data Visualization Guidance

Choosing the right visualization for a given dataset and audience is a skill many people skip. AI can give you clear guidance. Describe your data (what you're measuring, how many variables, time-based or categorical), your audience (executives vs. analysts), and your communication goal (show a trend, compare groups, show distribution, show relationships) — ask for the recommended chart type and why, plus any specific formatting considerations for your audience. For code-based visualization: describe the chart you want in natural language and ask AI to write the Python/R/JavaScript code to generate it from your data structure.

Communicating Insights to Non-Technical Audiences

The most common failure mode in data work isn't wrong analysis — it's correct analysis communicated in a way that doesn't drive decisions. A dashboard full of metrics that no one acts on is a waste. AI can help translate analysis into decision-oriented narratives. Provide the key findings and the audience's likely concerns and decision authority — ask AI to write an executive summary that: states the key finding in one sentence, explains the business implication in concrete terms (revenue, retention, efficiency), and recommends one to three specific actions. Data communication is a skill; AI helps structure it faster.

Prompt examples

✗ Weak prompt

Write a SQL query for my data.

No table structure, no database type, no question to answer. AI cannot write useful SQL without knowing what tables exist and what business question to answer.

✓ Strong prompt

Write a PostgreSQL query using these tables: orders (order_id, user_id, created_at, total_amount, status), users (user_id, created_at, acquisition_channel, country). Question: what is the average order value and total orders per acquisition channel for users who signed up in the last 6 months, broken down by month of their first order? Exclude cancelled orders (status = 'cancelled'). Sort by acquisition channel, then by month. Add a comment explaining each JOIN.

Database type specified, table structures with column names and types provided, business question is specific, filter conditions given, sort order defined, and asks for explanatory comments. Produces a working query.

Practical tips

✦Always specify the database type (PostgreSQL, MySQL, BigQuery, Snowflake) — SQL syntax varies and the wrong dialect produces queries that won't run.
✦Describe table schemas with column names and types before asking for queries — AI cannot infer your data structure without it.
✦For exploratory analysis, paste a sample of your data (first 20 rows, anonymized) — grounded pattern identification is more useful than generic observations.
✦Ask AI to suggest 3 hypotheses for any metric movement before committing to an investigation — this expands the search space before narrowing it.
✦For executive communication, specify the decision authority and what they need to act — 'write for a VP of Marketing who controls the ad budget and needs to decide whether to shift spend' produces better copy than 'write an executive summary.'

Continue learning

AI for Finance →AI for Research →Output Format in Prompts →

PromptIt builds data-specific prompts — from SQL queries to executive summaries, structured for your data and audience.

PromptIt applies these prompt engineering principles automatically to build better prompts for your specific task.

✦ Try it free