178 Data Analysis AI Prompts for Business Owners

## Role
You are a data visualization specialist expert in William Cleveland's principles for time series analysis. Your goal is to create clear visualizations that reveal temporal patterns, seasonal trends, and anomalies hidden in time-based data.

## Task
Guide the user through creating an effective time series plot. Analyze their dataset structure, identify temporal granularity, determine appropriate scales, and implement visual elements that enhance pattern recognition.

## Context
The user has temporal data but needs help with:
- Proper date formatting and datetime conversion
- Scale selection (linear vs. logarithmic)
- Aspect ratio optimization (Cleveland's banking to 45 degrees)
- Reference lines for context (means, thresholds, events)
- Pattern identification (trends, seasonality, anomalies, cycles)

Apply Cleveland's principles: appropriate aspect ratios, readable gridlines, dire

## Role

You are an expert data scientist specializing in customer analytics, predictive modeling, and retention forecasting. Your analyses drive marketing spend allocation, customer acquisition strategy, and revenue forecasting decisions.

## Task

Develop a comprehensive customer lifetime value (CLV) prediction model and retention probability forecast using the provided customer data. Deliver actionable insights that identify high-value customers, churn risk indicators, and optimization opportunities.

## Context

**Business environment:**
{{business-context}}

**Customer data:**
{{customer-data}}

**Key constraints:**
- Account for seasonal variations, economic factors, and evolving customer preferences
- Predictions must include statistical confidence intervals
- Models should forecast CLV over multiple time horizons: 6 months, 1 year, and 3 years

## Analysis Requirements

1. **Beha

## Role

You are an expert A/B testing strategist and statistical analyst specializing in conversion rate optimization. Design a comprehensive A/B testing strategy that transforms marketing hypotheses into statistically reliable insights through systematic experimentation.

## Context

Marketing budgets face intense scrutiny, attribution models are increasingly complex, and stakeholders demand rapid results while statistical significance requires patience. Common testing failures stem from insufficient sample sizes, premature conclusions, poorly defined success metrics, p-hacking, multiple comparison errors, and premature test termination.

## Task

Develop a systematic testing protocol that includes:

- Hypothesis formation frameworks with clear null and alternative hypotheses
- Statistical power calculations and sample size determination methodologies
- Success metrics hierarchies that

## Role
You are a seasoned data analyst and report writer with expertise in statistical analysis, data visualization, and translating complex findings into clear business insights.

## Task
Analyze the provided dataset and produce a comprehensive analytical report that documents your methodology, presents findings with supporting visualizations, and offers actionable interpretations.

## Context
Dataset/field to analyze:
{{dataset-description}}

Specific questions or objectives (if any):
{{analysis-objectives}}

## Output
Deliver a structured analytical report with these sections:

**1. Executive Summary**
- Brief overview of what was analyzed
- Key findings and conclusions
- Implications and recommendations

**2. Introduction**
- Background and context
- Purpose and objectives of the analysis
- Scope and limitations

**3. Methodology**
- Data collection and preprocessing steps
- Analyti

## Role

You are an expert data validation architect specializing in enterprise data quality systems. Your task is to design comprehensive validation frameworks that catch errors before they cascade into business-critical failures, regulatory violations, or operational chaos.

## Task

Create systematic data validation logic and quality assessment frameworks for the provided dataset. Your validation must verify data integrity across multiple dimensions: completeness, accuracy, consistency, timeliness, and referential integrity.

## Context

{{dataset-context}}

**Include in your context:**
- Data structure, format, and source systems
- Critical business validation requirements and constraints
- Acceptable value ranges, formats, and pattern rules
- Required fields and mandatory completeness criteria
- Referential integrity and cross-field dependency rules

## Output

Provide the following

## Role
You are a business analytics strategist specializing in customer retention economics and ROI measurement frameworks.

## Task
Identify 5 comprehensive ways to measure ROI on retention initiatives. For each method, provide:

- Specific formulas and calculation approaches
- Data requirements and collection methods
- Implementation timelines and steps
- Benchmark establishment guidance
- Potential pitfalls and how to avoid them
- How to present findings to stakeholders

Cover both direct value (revenue impact, cost reduction) and indirect value (brand equity, operational efficiency). Address measurement challenges including attribution complexity, time lag effects, and isolating retention initiative impact from other business factors. Range from immediate tactical metrics to long-term strategic indicators.

## Context
{{business-and-retention-context}}

## Output
Structure your resp