Claude Prompts for Data Analysis: Insights, Reports & Visualizations

AnalystChatGPT

Survey Data Analysis Planner

Designs a complete analysis plan for survey data including cleaning, coding, statistical tests, and visualization strategy.

You are a research analyst planning a survey analysis. Survey: {{survey_name}}. Respondents: {{respondent_count}}. Question types: {{question_types}}. Research objectives: {{research_objectives}}. Design: (1) data cleaning and validation rules, (2) open-ended response coding framework, (3) statistical test recommendations per question type, (4) cross-tabulation and segmentation strategy, (5) visualization plan with chart types, (6) significance and confidence level guidance, (7) reporting struct...

AnalystChatGPT

Cohort Analysis Planner

Design cohort analysis frameworks for measuring user retention, engagement patterns, and lifecycle behavior over time.

You are a data analyst specializing in user behavior and retention analysis. Design a cohort analysis plan for {{product_type}} to analyze {{retention_metric}}. Create a comprehensive cohort analysis framework with: 1. **Cohort Definition**: Define {{cohort_definition}} with: - Cohort grouping criteria (signup date, first purchase, first login, etc.) - Minimum cohort size for statistical validity - Exclusion criteria (test accounts, bots, etc.) 2. **Retention Metric**: Define {{retention_metric}...

EducatorChatGPT

Student Survey Data Analyzer

Analyze student survey or feedback data to identify patterns, surface actionable insights, and recommend instructional adjustments.

You are an education data analyst reviewing student survey or feedback data for a teacher. Analyze the provided data and produce a structured report with these sections: (1) Overall Sentiment Summary — a 2-3 sentence overview of how students feel. (2) Top 3 Strengths — the most frequently positive themes, with approximate percentages if quantitative data is provided. (3) Top 3 Concerns — the most common areas of frustration or difficulty, with specific student quotes if available. (4) Equity Che...

AnalystChatGPT

Executive Summary Writer

Transform data analysis into a clear executive summary with recommendations.

Write an executive summary of this analysis: {{analysis_results}} Audience: {{audience}} Decision to be made: {{decision}} Structure: 1. Key finding (1 sentence, bold) 2. Context (2-3 sentences on why this matters) 3. Top 3 insights with supporting data 4. Recommendations (specific, actionable) 5. Risks of inaction 6. Next steps Rules: - Lead with the "so what" — what should the audience DO? - Use plain language, not technical jargon - Numbers should be rounded and contextualized - Total length:...

EducatorChatGPT

Professional Learning Community Facilitator Guide

Creates a structured facilitation guide for PLC meetings with agendas, discussion protocols, and action item tracking.

You are an instructional coach facilitating a PLC meeting. Team: {{team_description}}. Focus area: {{focus_area}}. Meeting duration: {{meeting_duration}}. Data available: {{data_available}}. Create: (1) a timed agenda with transitions, (2) a data analysis protocol (consultancy, tuning, or evidence-based), (3) discussion questions that move from analysis to action, (4) a collaborative norms reminder, (5) an action item template with owners and deadlines, (6) a follow-up plan between meetings. Inc...

AnalystChatGPT

Churn Analysis Planner

Designs a comprehensive churn analysis plan including signal identification, segmentation strategy, and retention experiment recommendations.

You are a senior growth analyst specializing in retention. Design a churn analysis plan for a {{product_type}} product. Available data: {{data_available}}. Retention goal: {{retention_goal}}. Include: (1) a churn definition with time-based thresholds, (2) a prioritized list of behavioral and demographic churn predictors, (3) a segmentation strategy with at least 3 risk tiers, (4) recommended statistical methods with justification, and (5) two retention experiments targeting the highest-risk segm...

MarketingChatGPT

Cohort Analysis Framework

Design a cohort analysis to understand user retention and lifetime value patterns.

Design a cohort analysis framework for {{product}}. Business model: {{business_model}} Key metric: {{key_metric}} Data available: {{data_sources}} Provide: 1. Cohort definition criteria (by signup date, first purchase, etc.) 2. Time periods to analyze (weekly, monthly, quarterly) 3. Metrics to track per cohort (retention, LTV, feature adoption) 4. Visualization recommendations (charts, dashboards) 5. 3 hypotheses to test with the cohort data 6. Red flags to watch for Make the framework actionabl...

Product ManagerChatGPT

Competitive Analysis Synthesizer

Synthesize competitive analysis from feature comparisons to identify market positioning and strategic opportunities for your product.

You are a senior product strategist specializing in competitive analysis and market positioning. Analyze the competitive landscape for {{product_name}} against the following competitors: {{competitors}}. Produce a structured competitive analysis report with the following sections: 1. **Market Overview**: Summarize the market category, total addressable market size, and key trends shaping the landscape. 2. **Competitor Profiles**: For each competitor, provide: - Company overview and market positi...

AnalystChatGPT

Retention Cohort Analysis Framework

Designs a cohort-based retention analysis framework with definitions, measurements, and visualizations.

Build a retention analysis framework for {{product_type}}. Cohorts by {{cohort_criteria}}, tracking {{retention_metrics}} over {{time_horizon}}. Produce: (1) cohort definition with inclusion/exclusion criteria, (2) SQL/pandas to build cohort table, (3) retention table template with example data, (4) three visualization specs (curve, heatmap, rolling comparison), (5) interpretation guide with actionable insight patterns.

MarketingChatGPT

Competitor Analysis Brief

Generate a structured competitor analysis framework for marketing strategy.

Act as a marketing strategist. Create a competitor analysis brief for {{company}} in the {{industry}} space. Known competitors: {{competitors}} Our differentiator: {{differentiator}} Analyze each competitor across: 1. Positioning statement 2. Target audience overlap 3. Key messaging themes 4. Pricing strategy (if known) 5. Content/social media approach 6. Strengths and weaknesses Then provide: - 3 content gaps we can exploit - 2 messaging angles that differentiate us - 1 counter-positioning reco...

AnalystChatGPT

Data Anomaly Detection Planner

Designs an anomaly detection system with method selection, threshold tuning, and alert routing for a given dataset.

You are a data analyst specializing in anomaly detection. Design an anomaly detection plan for {{metric_name}} in the {{data_domain}} domain. Data characteristics: {{data_characteristics}}. Business context: {{business_context}}. Include: (1) recommended detection method (statistical, ML-based, or hybrid) with justification, (2) threshold strategy with sensitivity tuning, (3) false positive mitigation approach, (4) alert routing with severity tiers and escalation rules, (5) SQL or Python pseudoc...

AnalystChatGPT

Data Insights Report Writer

Synthesizes analysis findings into a structured executive report with narrative, visualizations, and strategic implications.

Write an insights report for {{stakeholder_group}}. Dataset: {{dataset_name}}. Findings: {{key_findings}}. Business impact: {{business_impact}}. Include: (1) executive summary, (2) findings with data/context/implication, (3) recommended visualizations, (4) risks and limitations, (5) prioritized next steps with owners and timelines, (6) appendix outline. Direct, analytical tone.

DeveloperChatGPT

Data Pipeline Specification Writer

Write detailed data pipeline specifications covering sources, transformations, scheduling, monitoring, and error handling for engineering teams.

You are a data engineer specializing in data pipeline architecture. Write a specification for a data pipeline that processes {{data_sources}} with the following requirements: {{transformation_requirements}}. Create a comprehensive pipeline specification with: 1. **Pipeline Overview**: - Purpose and business context - Data flow diagram description (source -> transform -> destination) - Processing frequency and latency requirements 2. **Data Sources**: Detail {{data_sources}}: - Source systems, fo...

AnalystChatGPT

Data Quality Audit Checklist

Generates a structured data quality audit plan for a given dataset, covering completeness, consistency, accuracy, and timeliness checks.

You are a senior data analyst conducting a data quality audit. Analyze the {{data_source}} dataset named {{dataset_name}} covering the {{time_period}} period. Focus on the following key columns: {{key_columns}}. For each column, identify potential quality issues across five dimensions: completeness (nulls, blanks), consistency (format mismatches, conflicting values), accuracy (outliers, impossible ranges), timeliness (staleness, lag), and uniqueness (duplicates). Output a prioritized checklist w...

DeveloperChatGPT

Database Migration Planner

Plans safe database schema migrations with rollback strategies, data integrity checks, and zero-downtime approaches.

Plan a database migration for {{database_engine}}. Current schema: {{current_schema}}. Target changes: {{target_changes}}. Constraints: {{constraints}}. Design: (1) ordered migration steps with forward and rollback scripts, (2) data integrity verification queries, (3) zero-downtime strategy (expand-contract pattern if needed), (4) index creation strategy (online vs blocking), (5) data backfill plan if needed, (6) monitoring and alerting during migration, (7) go/no-go checklist. Estimate duration...

DeveloperChatGPT

Database Migration Script Generator

Generates a safe, reversible database migration script with rollback procedures and data integrity checks.

You are a database engineer writing a migration. Database: {{database_type}}. Change type: {{change_type}}. Current schema: {{current_schema}}. Target: {{target_schema}}. Table size: {{table_size}}. Generate: (1) the migration script (up) with comments, (2) the rollback script (down), (3) pre-migration checks (locks, dependencies, disk space), (4) data integrity verification queries, (5) estimated downtime and locking strategy, (6) step-by-step execution plan with checkpoints. Follow zero-downti...

DeveloperChatGPT

Database Schema Designer

Design a normalized database schema from business requirements.

Design a {{database}} schema for {{application}}. Requirements: {{requirements}} Provide: 1. Entity-relationship description 2. CREATE TABLE statements with proper types, constraints, and indexes 3. Foreign key relationships with ON DELETE behavior 4. Indexes for expected query patterns 5. Migration script 6. Seed data example Use best practices: UUIDs for IDs, created_at/updated_at timestamps, soft deletes where appropriate.

AnalystChatGPT

Python Data Cleaning Script Generator

Generates a production-ready Python data cleaning script tailored to specific data quality issues.

You are a data engineer writing a Python cleaning script using {{library}}. Dataset: {{data_description}}. Known issues: {{issues}}. Output format: {{output_format}}. Write a complete script that: (1) loads data, (2) implements a cleaning pipeline with labeled steps, (3) logs transformations to a summary report, (4) outputs cleaned data, (5) includes assertions to verify cleaning worked. Handle edge cases like empty files and encoding issues.

EducatorChatGPT

Research Paper Data Extractor

Extract structured metadata from unstructured research paper text.

You are an expert at structured data extraction. Extract key information from this research paper. <paper> {{paper_text}} </paper> Extract: { "title": "string", "authors": ["name1", "name2"], "abstract": "string (max 200 words)", "keywords": ["keyword1", "keyword2"], "methodology": "string", "key_findings": ["finding1", "finding2"], "limitations": ["limitation1", "limitation2"], "publication_year": "YYYY or null" } Only extract information that is explicitly stated in the paper. Do not infer or ...

AnalystChatGPT

Executive Summary Writer

Write concise executive summaries from data reports, translating complex findings into actionable business insights for leadership.

You are a senior analyst specializing in executive communications. Write an executive summary for {{report_title}} based on the following findings: {{key_findings}}. Create a compelling executive summary with: 1. **Opening Statement**: Hook the audience with the single most critical insight or finding, framed as a business implication. 2. **Key Findings**: Present {{key_findings}} in order of business impact: - Finding statement (1 sentence) - Supporting data point - Business implication 3. **St...

DeveloperChatGPT

Performance Profiler Analyst

Analyze performance profiling data and recommend optimizations.

Act as a performance engineer. Analyze the following profiling data and recommend optimizations. Application: {{application}} Profiling tool: {{tool}} Profile data: {{data}} Provide: 1. Top 3 bottlenecks identified 2. Root cause analysis for each 3. Specific code changes with before/after 4. Expected improvement estimates 5. Monitoring recommendations 6. Quick wins vs long-term fixes

AnalystChatGPT

Analytics Dashboard Schema Builder

Designs a complete dashboard schema with data model, metric definitions, filters, and visualization layouts.

Design a dashboard schema for {{dashboard_purpose}}. Data sources: {{data_sources}}. User: {{user_role}}. Refresh: {{refresh_frequency}}. Design: (1) star schema with fact/dimension tables, (2) metric definition sheet, (3) filter/cross-filter spec, (4) wireframe layout description, (5) row-level security rules, (6) performance optimization notes.

AnalystChatGPT

Dashboard Design Brief

Design analytics dashboard layouts with KPI definitions, data source specifications, and visualization recommendations.

You are a data visualization expert and analytics consultant. Design an analytics dashboard for {{dashboard_purpose}} targeting {{target_users}}. Create a comprehensive dashboard design brief with: 1. **Dashboard Objectives**: Define the primary goals, key questions the dashboard should answer, and success metrics. 2. **Key Performance Indicators**: Identify and define {{key_metrics}} including: - Metric name and business definition - Data source and calculation method - Benchmark targets and th...

AnalystChatGPT

KPI Dashboard Spec

Design a KPI dashboard with metrics, visualizations, and data source specifications.

Design a KPI dashboard for {{team}} at {{company}}. Business objectives: {{objectives}} Current reporting: {{current_reporting}} Audience: {{audience}} For each KPI: 1. Metric name and definition 2. Data source and calculation formula 3. Visualization type (chart, gauge, table) 4. Target/benchmark 5. Update frequency 6. Drill-down dimensions Organize into logical sections. Include alert thresholds for critical metrics. Make it actionable, not just informational.

Claude prompts for data analysis.