How to Use Prompts for Data Analysis: Simple Guide

To use prompts for data analysis, write clear, specific instructions describing the data and the analysis you want. Use structured prompts that include the data context, the question, and the expected output format to get accurate results.

Syntax

A prompt for data analysis usually has three parts:

• Data description: Briefly explain the dataset or provide sample data.
• Analysis task: Clearly state what you want to find out or compute.
• Output format: Specify how you want the answer (e.g., summary, table, code snippet).

This structure helps the AI understand your request and respond accurately.

text

Prompt example:
"Given the sales data for the last quarter: [data], calculate the total revenue and provide a summary table."

Example

This example shows how to prompt an AI to analyze a small dataset and return a summary.

python

data = [
    {"product": "A", "units_sold": 10, "price": 5},
    {"product": "B", "units_sold": 20, "price": 3},
    {"product": "C", "units_sold": 15, "price": 4}
]

prompt = f"Given the sales data: {data}, calculate total revenue for each product and overall. Return results as a dictionary with product names and revenues, plus total revenue."

# Simulated AI response function (for demonstration)
def ai_data_analysis(prompt):
    # Calculate revenues
    revenues = {item['product']: item['units_sold'] * item['price'] for item in data}
    total_revenue = sum(revenues.values())
    return {"revenues": revenues, "total_revenue": total_revenue}

result = ai_data_analysis(prompt)
print(result)

Output

{"revenues": {"A": 50, "B": 60, "C": 60}, "total_revenue": 170}

Common Pitfalls

Common mistakes when using prompts for data analysis include:

• Being too vague about the data or task, causing unclear answers.
• Not specifying the output format, leading to inconsistent results.
• Providing incomplete or incorrect data context.

Always be clear, specific, and structured in your prompt.

text

Wrong prompt:
"Analyze this data and tell me something interesting."

Right prompt:
"Given the dataset of monthly sales: [data], calculate the average sales per month and identify the month with highest sales. Provide results as a list."

Quick Reference

Prompt Part	Description	Example
Data Description	Briefly describe or provide sample data	"Sales data for Q1: [...]"
Analysis Task	Clearly state what to analyze or compute	"Calculate total revenue"
Output Format	Specify how you want the answer	"Return a summary table"

Key Takeaways

Write clear and specific prompts including data context and analysis goals.

Always specify the desired output format to get consistent results.

Avoid vague or incomplete prompts to prevent unclear answers.

Use structured prompts with data description, task, and output format.

Test and refine prompts to improve AI data analysis accuracy.