Analyse tables, dashboards, trends, outliers, survey data, and business metrics.
Related books, audiobooks, and useful resources. Some links may be affiliate links.
Best for: Exploratory analysis
Analyze this dataset summary and suggest what to inspect first. Include likely trends, risks, missing fields, and useful charts. Data: [paste table or columns]Replace the bracketed placeholders with your real details before using it.
Best for: Metrics
Suggest KPIs for [business/process]. Include formula, why it matters, good/bad signals, and dashboard placement.Replace the bracketed placeholders with your real details before using it.
Best for: Anomaly detection
Review this data and identify possible outliers, anomalies, and explanations. Return a table with issue, evidence, and next check. Data: [paste data]Replace the bracketed placeholders with your real details before using it.
Best for: Reporting
Turn these metrics into an executive dashboard narrative. Explain what changed, why it matters, and what action to take. Metrics: [paste metrics]Replace the bracketed placeholders with your real details before using it.
Best for: Qualitative analysis
Analyze these survey responses. Identify themes, sentiment, representative quotes, and recommended actions. Responses: [paste responses]Replace the bracketed placeholders with your real details before using it.
Best for: Visualization
Recommend the best chart types for these questions and data fields. Explain why each chart works and what mistake to avoid. Fields: [paste fields]Replace the bracketed placeholders with your real details before using it.
Best for: Problem solving
Use the 5 Whys method to explore this metric change: [metric/problem]. Include assumptions, evidence needed, and possible causes.Replace the bracketed placeholders with your real details before using it.
Best for: Data prep
Create a data cleaning checklist for this dataset. Include missing values, duplicates, formats, categories, outliers, and validation rules. Data: [paste]Replace the bracketed placeholders with your real details before using it.
Best for: Executive reporting
Summarize this analysis for executives in 6 bullets: what happened, impact, cause, confidence, risks, and next actions. Analysis: [paste]Replace the bracketed placeholders with your real details before using it.
Best for: Experiments
Interpret this A/B test result. Include conversion rates, practical significance, risks, and recommendation. Data: [paste result]Replace the bracketed placeholders with your real details before using it.
Best for: Retention analysis
Create a cohort analysis plan for [product/business]. Include cohort definition, retention metrics, segments, and visualizations.Replace the bracketed placeholders with your real details before using it.
Best for: Forecasting
Create a simple forecast approach for [metric]. Include inputs, assumptions, scenarios, limitations, and validation steps.Replace the bracketed placeholders with your real details before using it.
Best for: Documentation
Create a data dictionary from these fields. Include field name, meaning, type, example, validation rules, and owner. Fields: [paste fields]Replace the bracketed placeholders with your real details before using it.
Best for: Decision support
Prioritize these data insights by business impact, confidence, and ease of action. Insights: [paste insights]Replace the bracketed placeholders with your real details before using it.
Best for: Dashboard quality
Create a QA checklist for a dashboard about [topic]. Include data accuracy, filters, formatting, performance, permissions, and user testing.Replace the bracketed placeholders with your real details before using it.