100 Best Claude Prompts for Data Analysis and Insights
Here are 100 expert-level prompts you can use with Claude for advanced data analysis, modeling, and decision intelligence.
These prompts are designed for workflows with tools like Python, SQL, Power BI, Tableau, and Microsoft Excel.
100 Expert-Level Claude Prompts for Data Analysis
1. Expert Data Exploration
-
Perform a comprehensive exploratory data analysis (EDA) including distribution diagnostics, skewness, kurtosis, and anomalies.
-
Identify latent structures and hidden relationships in the dataset.
-
Perform feature interaction analysis and highlight nonlinear relationships.
-
Detect systematic bias or sampling bias in the dataset.
-
Identify variables with the highest predictive power.
-
Analyze feature correlations and multicollinearity risks.
-
Detect data leakage risks in modeling scenarios.
-
Identify rare events or long-tail distributions.
-
Segment the dataset into behaviorally similar clusters.
-
Produce a technical EDA report suitable for data scientists.
2. Advanced Data Cleaning
-
Design a robust data cleaning pipeline for production analytics.
-
Detect outliers using multiple statistical techniques (IQR, Z-score, isolation forest).
-
Identify structural inconsistencies in categorical data.
-
Implement imputation strategies based on data distribution.
-
Detect data drift across time segments.
-
Suggest automated data validation rules.
-
Identify schema anomalies across tables.
-
Detect inconsistent measurement units or encoding errors.
-
Build a data quality scoring framework.
-
Recommend data transformation strategies for modeling.
3. Statistical Analysis
-
Perform hypothesis testing with clear assumptions and statistical interpretation.
-
Determine the appropriate statistical tests for each variable relationship.
-
Run ANOVA analysis across multiple segments.
-
Conduct causal inference analysis using observational data.
-
Estimate confidence intervals for key metrics.
-
Perform bootstrap resampling for robustness checks.
-
Evaluate statistical power of the dataset.
-
Detect heteroscedasticity and model violations.
-
Perform multivariate regression with interpretation.
-
Provide causal explanations vs correlations.
4. Time Series Analysis
-
Decompose the time series into trend, seasonality, and residual components.
-
Detect seasonal patterns and structural breaks.
-
Perform time-series stationarity tests.
-
Compare ARIMA, Prophet, and machine learning forecasting models.
-
Detect anomalies in temporal data.
-
Generate rolling window analytics.
-
Forecast future trends with confidence intervals.
-
Identify leading indicators in time series data.
-
Perform change point detection.
-
Model long-term growth patterns.
5. Feature Engineering
-
Suggest high-impact feature engineering strategies.
-
Generate interaction features and polynomial terms.
-
Apply target encoding for categorical variables.
-
Design domain-specific features for predictive modeling.
-
Create time-based lag features.
-
Generate rolling statistics features.
-
Evaluate feature importance using multiple techniques.
-
Detect redundant features.
-
Apply dimensionality reduction techniques.
-
Design feature selection pipeline.
6. Machine Learning Modeling
-
Recommend best machine learning models for this problem.
-
Build a baseline predictive model.
-
Compare multiple algorithms and evaluate performance.
-
Optimize models using hyperparameter tuning.
-
Evaluate model bias-variance tradeoff.
-
Implement cross-validation strategy.
-
Detect overfitting or underfitting issues.
-
Generate model explainability using SHAP or feature importance.
-
Evaluate classification vs regression modeling approaches.
-
Recommend ensemble modeling strategies.
7. Advanced Business Intelligence
-
Translate analysis into strategic executive insights.
-
Identify revenue drivers and profit levers.
-
Detect customer churn risk factors.
-
Perform customer segmentation analysis.
-
Identify high-value customer cohorts.
-
Conduct cohort retention analysis.
-
Identify market expansion opportunities.
-
Detect operational inefficiencies.
-
Recommend data-driven growth strategies.
-
Create KPI frameworks based on the dataset.
8. Optimization & Decision Modeling
-
Create optimization models to maximize revenue or efficiency.
-
Perform scenario analysis for strategic decisions.
-
Simulate best-case, worst-case, and expected outcomes.
-
Evaluate ROI of different strategies.
-
Identify optimal pricing strategies using data.
-
Recommend resource allocation models.
-
Perform sensitivity analysis.
-
Identify risk exposure in decision scenarios.
-
Build decision trees for strategic planning.
-
Generate data-driven policy recommendations.
9. Data Visualization Strategy
-
Design executive-level dashboards.
-
Identify most impactful visualizations for storytelling.
-
Build dashboard wireframes for BI tools.
-
Create data storytelling narrative from insights.
-
Recommend visualizations for anomaly detection.
-
Design interactive dashboards for stakeholders.
-
Highlight key performance indicators visually.
-
Create visual analytics workflow.
-
Design real-time monitoring dashboards.
-
Generate presentation-ready visual insights.
10. Advanced Analytics & Research
-
Conduct market basket analysis using association rules.
-
Detect fraud patterns using anomaly detection techniques.
-
Perform customer lifetime value modeling.
-
Conduct network analysis for relationship data.
-
Detect emerging trends using unsupervised learning.
-
Build predictive models for demand forecasting.
-
Create advanced cohort survival analysis.
-
Perform multi-factor causal impact analysis.
-
Generate a complete end-to-end data science workflow.
-
Produce a publication-quality analytical report with insights, models, and recommendations.
Pro Tip:
When using these prompts with Claude, attach:-
dataset
-
schema
-
business context
-
target variable
This makes Claude generate much deeper analysis.

Comments
Post a Comment