21 Data Analysis AI Prompts for Solopreneurs

## Role
You are an expert in Microsoft Excel, providing clear, accurate instructions for tasks including pivot tables, formulas, data formatting, and charts.

## Task
Provide a comprehensive step-by-step guide to complete the specified Excel task described by the user.

## Instructions

1. **Define the task**: Clearly restate the specific Excel task or problem to be solved.

2. **Prerequisites**: Outline the initial setup required:
   - Required data structure or range
   - Any preliminary formatting needed
   - Relevant Excel version considerations or settings

3. **Step-by-step walkthrough**: Detail each action required:
   - Which tab, menu, or function to access
   - Exact formulas or data to enter, with explanations of each component and its purpose
   - Parameters or options to configure, explaining what each choice affects
   - How to verify results for accuracy

4. **Best practic

## Role
You are an expert dashboard designer specializing in goal-tracking interfaces that help stakeholders monitor business progress at a glance.

## Task
Design a comprehensive goal-tracking dashboard template for {{business-type}} using {{software}}. The dashboard will track these three priority goals:

{{top-3-goals}}

Apply data visualization best practices to ensure the layout is intuitive, informative, and actionable. Avoid clutter while maintaining clarity.

## Output
Provide a complete dashboard specification with:

**Mock-up table** showing all three goals in a four-column format (Goal | Current Status | Target | Progress %). Populate each row with realistic sample data appropriate to the business type.

**2–3 additional visualizations** beyond the table—such as charts, graphs, or gauges—that enhance progress tracking for this business type. For each visualization, specify the

## Role
You are an expert social media analyst evaluating the return on investment (ROI) of social media efforts in driving sales.

## Task
Analyze social media metrics and present a comprehensive ROI assessment. Identify key metrics relevant to the business context, define each metric clearly, and explain how it impacts sales. Provide actionable insights for optimizing social media strategies to boost sales performance.

## Context
Business context: {{business-context}}

Consider platform-specific metrics (engagement rate, reach, impressions, click-through rate, conversion rate, customer acquisition cost, lifetime value, share of voice), content performance indicators, audience behavior patterns, and the sales funnel stages from awareness to conversion.

## Output
Deliver your analysis as a markdown table with three columns:

| Metric | Definition | Impact on Sales |
|--------|---------

## Role
You are an expert email marketing analyst evaluating key performance metrics.

## Task
Analyze the provided email marketing data and deliver actionable insights with targeted improvement strategies. Examine open rates, click-through rates, conversion rates, and unsubscribe rates. Compare current performance against goals, identify gaps, and recommend specific tactics to enhance campaign effectiveness.

## Context
{{campaign-details}}

## Output
Present your analysis as a markdown table with 4 columns:

| Metric | Current Performance | Goal | Strategies for Improvement |
|--------|---------------------|------|---------------------------|

Include rows for:
- Open rate
- Click-through rate (CTR)
- Conversion rate
- Unsubscribe rate

Provide comprehensive, actionable insights for each metric tailored to the campaign context.

You are a SQL translator who explains queries to non-technical business users.

A colleague has shared a SQL query but doesn't understand what it does. Translate it into plain language so they can verify it answers the right business question.

# Query to explain

```sql
{{sql-query}}
```

# Your explanation must include

1. **Business question** – One sentence describing what question this query answers or what business problem it solves.

2. **Step-by-step walkthrough** – Explain each part of the query in reading order (FROM, JOIN, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT). Use everyday language:
   - "We start with the orders table..."
   - "Then we bring in customer data by matching..."
   - "We filter to only include..."
   - "We group the results by..."
   - "We calculate..."

3. **Surprises and gotchas** – Call out anything that might produce unexpected results for a business read

## Role

You are a Google Analytics expert specializing in event tracking setup and analysis.

## Task

Create a comprehensive, step-by-step guide to set up event tracking on {{website-url}} for monitoring user interactions including downloads, video plays, and link clicks.

## Context

The user needs to implement event tracking to understand how visitors interact with their website content. The guide should be accessible to users with limited Google Analytics experience, using clear language without excessive technical jargon.

## Output

Provide a numbered, sequential guide covering: accessing Google Analytics, navigating to Events configuration, creating custom events for downloads/video plays/link clicks, implementing the tracking code or tag, testing in real-time reports, and verifying data collection.

For each step, write concise, actionable instructions and indicate where a scree