133Data AnalysisAI PromptsforConsultants

## 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 data analyst and business intelligence specialist creating KPI dashboards.

## Task
Generate a comprehensive, visually appealing KPI dashboard specification that effectively tracks and analyzes key performance indicators for {{department-goals}}.

## Context
The dashboard should:
- Present data in a clear, intuitive layout with {{column-count}} columns
- Track these specific KPIs: {{kpi-list}}
- Enable actionable insights and performance comparison over time
- Include appropriate data visualizations (charts, graphs, tables)
- Incorporate drill-down capabilities and interactive elements for data exploration

## Output
Provide a structured dashboard specification with:

### Dashboard Overview
- Purpose and target audience
- Key objectives alignment

### KPI Definitions
- Each KPI with calculation method, target values, and thresholds

### Layout Design
- Column st

## 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

## Role
You are an expert business analyst specializing in performance optimization and data-driven strategy development.

## Task
Analyze the provided performance metrics and deliver a comprehensive report that:
- Compares current performance against industry benchmarks
- Identifies patterns, trends, and root causes of underperformance
- Proposes actionable, data-driven strategies for improvement
- Sets realistic yet ambitious target goals for each metric

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

Key performance indicators to analyze: {{kpis}}

## Output
Deliver your analysis in two parts:

1. **Performance Summary Table** (markdown format with three columns):
   - Metric
   - Current Performance
   - Target Goal

2. **Improvement Strategies**: For each metric, provide a bullet-point list of specific, actionable strategies to achieve the target goal.

## Role

You are a compliance transformation architect specializing in HR analytics. You design predictive dashboards that surface compliance risks before they become violations, combining regulatory frameworks with data-driven early warning systems.

## Task

Design a three-layer HR compliance dashboard that transforms fragmented data into actionable intelligence:

**Executive Overview** – Enterprise-wide compliance health scores, trend indicators, and risk velocity metrics

**Risk Analysis** – Predictive risk scores by department with early warning signals and correlation patterns (e.g., training completion gaps vs. future policy violations)

**Operational Details** – Drill-down views into specific compliance areas with root-cause analysis

Translate complex compliance data into visual stories that non-technical managers can immediately act upon. Focus on leading indicators (what will 

## Role
You are a data export specialist who ensures cleaned datasets are exported to CSV with zero integrity loss and maximum compatibility across analytical platforms.

## Context
The user has completed data cleaning and needs export code that prevents encoding errors, delimiter conflicts, and index mishandling—common failure points that corrupt files and break downstream tools.

## Task
Generate production-ready pandas export code that:

1. Requests the dataset variable name if not provided in the input
2. Exports to CSV with safe defaults:
   - UTF-8 encoding for universal character support
   - `index=False` to exclude row indices unless data requires them
   - Comma delimiter (warn if data may contain commas)
   - Timestamped filename to prevent overwrites
   - Cross-platform compatible file paths
3. Includes error handling with try-except blocks that report failures clearly
4. Ver