Prompt lesson · 27 prompts
Data analysis and visualization prompts for Chief Sales Officers (CSOs)
27 ready-to-use prompts from our AI for Chief Sales Officers (CSOs) course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Data Cleaning Optimization
Use this when you need to clean a dataset to ensure accuracy and consistency, handling duplicates, missing values, and standardization.
Role You are a data quality expert specializing in data cleaning and preprocessing, helping users optimize their datasets for analysis.
Context you provide
- {{dataset name or type}} – the dataset you are working with.
- {{specific issues}} – any known issues like duplicates, missing values, or inconsistencies (optional).
- {{industry}} – the industry context if relevant (optional).
Instructions
- If the dataset or issues are not described, ask for clarification before starting.
- Provide a step-by-step guide to identify and remove duplicate entries, including methods and tools.
- Discuss techniques for handling missing values (e.g., imputation, deletion) with pros and cons for each.
- Identify common data inconsistencies in the given industry and how to detect and resolve them.
- Explain how to standardize and normalize variables for consistency, with examples.
Output format A structured response with sections: Duplicate Removal, Handling Missing Values, Inconsistency Resolution, and Standardization. Use bullet points and clear headings. Tone: practical and detailed.
Guardrails
- Do not assume specific data; ask for details if needed.
- Avoid recommending overly complex solutions without explaining trade-offs.
- Stay focused on data cleaning; do not drift into modeling or analysis.
Example
- {{dataset name or type}}: customer database; {{specific issues}}: duplicate records and missing age values; {{industry}}: retail.
Open this prompt Analysis · Intermediate
Exploratory Data Analysis
Use this when you need to uncover patterns, trends, and anomalies in a dataset through visual and statistical exploration.
Role You are a data scientist who performs exploratory data analysis (EDA) to reveal hidden patterns, trends, and anomalies, and translates findings into actionable business insights.
Context you provide
- {{dataset name}}: The name or description of the dataset to analyze.
- {{specific dataset}}: The actual data or a sample, if available.
Instructions
- Ask for the dataset if not provided.
- Perform EDA using statistical methods and visualizations to identify patterns, trends, and outliers.
- Explain the significance of any outliers and their potential impact.
- Provide actionable recommendations based on the findings.
- Suggest additional analyses or visualizations to deepen understanding.
Output format A structured report with sections: Key Patterns, Trends, Outliers, and Recommendations. Use bullet points and include descriptions of visualizations.
Guardrails
- Do not invent data; use only provided information.
- Clearly state any assumptions about the data.
- Keep the analysis focused on EDA, not predictive modeling.
Example
- {{dataset name}}: Customer purchase history; {{specific dataset}}: CSV file with 10,000 rows.
Open this prompt Analysis · Intermediate
Statistical Modeling Guidance
Use this when you need to build statistical models to analyze relationships and make predictions from your data.
Open this prompt Analysis · Advanced
Data Visualization Design
Use this when you need to create clear, interactive visualizations to communicate data insights effectively.
Open this prompt Creating · Intermediate
Data Aggregation and Summary
Use this when you need to combine and summarize data from multiple sources to get a comprehensive view of performance or feedback.
Open this prompt Analysis · Beginner
Data Segmentation Guide
Use this when you need to divide a dataset into meaningful segments for deeper analysis and decision-making.
Open this prompt Analysis · Intermediate
Pattern Recognition in Business Data
Use this when you need to identify recurring patterns or anomalies in a specific dataset to inform strategic decisions.
Open this prompt Analysis · Intermediate
Data Clustering Insights
Use this when you need to group similar data points to uncover patterns or relationships in a dataset.
Open this prompt Analysis · Intermediate
Time Series Analysis and Forecasting
Use this when you need to analyze time-based data to identify trends, seasonality, and forecast future values.
Open this prompt Analysis · Advanced
Data Anomaly Detection
Use this when you need to identify unusual data points that may indicate errors, fraud, or other issues requiring investigation.
Open this prompt Analysis · Intermediate
Correlation Analysis Insights
Use this when you need to determine the strength and direction of relationships between variables in a dataset.
Open this prompt Analysis · Intermediate
Data Classification Guide
Use this when you need to categorize data into distinct classes based on specific criteria or attributes.
Open this prompt Analysis · Intermediate
Summarize Data into Insights
Use this when you need to condense a large dataset, report, or collection of metrics into a clear, actionable summary focused on key findings and KPIs.
Open this prompt Analysis · Intermediate
Data Forecasting Model
Use this when you need to predict future values based on historical data and statistical models.
Open this prompt Analysis · Intermediate
Assess Data Quality for Projects
Use this when you need to evaluate the quality of data sources used in a project, including validation, cleaning, and reliability metrics.
Open this prompt Analysis · Intermediate
Predictive Analytics Dashboard Design
Use this when you need to design a dashboard that provides real-time predictive insights for business decisions.
Open this prompt Creating · Advanced
Customer Segmentation Analysis
Use this when you need to segment customers by behavior and demographics to enable targeted marketing and sales strategies.
Open this prompt Analysis · Intermediate
Fraud Detection System Design
Use this when you need to design a system that detects fraudulent patterns in financial transactions.
Open this prompt Planning · Advanced
Supply Chain Optimization Strategy
Use this when you need to analyze supply chain data to identify bottlenecks and improve inventory management.
Open this prompt Analysis · Intermediate
Social Media Sentiment Analysis
Use this when you need to analyze social media data to understand customer sentiment and improve brand perception.
Open this prompt Analysis · Intermediate
Sales Performance Analytics System
Use this when you need to build a sales performance analytics system to track, analyze, and optimize sales strategies.
Open this prompt Analysis · Intermediate
Analyze Website User Behavior
Use this when you need to understand how visitors interact with your website to improve user experience and conversion.
Open this prompt Analysis · Intermediate
Risk Assessment and Mitigation Framework
Use this when you need to design a risk assessment system, score risks, and communicate them effectively to stakeholders.
Open this prompt Planning · Intermediate
Operational Efficiency Monitoring Framework
Use this when you need to set up a system to monitor operational processes, identify inefficiencies, and optimize resource allocation.
Open this prompt Planning · Intermediate
Customer Churn Prediction
Use this when you need to develop, evaluate, or act on a customer churn prediction model to reduce attrition.
Open this prompt Planning · Advanced
Market Trend Analysis
Use this when you need to analyze market trends to identify opportunities and make data-driven strategic decisions.
Open this prompt Research · Intermediate
Product Performance Monitoring System
Use this when you need to set up a system to track product performance, identify improvement areas, and guide development strategy.
Open this prompt Planning · Intermediate