Prompt lesson · 22 prompts
Forecasting Demand prompts for Vice Presidents of Operations
22 ready-to-use prompts from our AI for Vice Presidents of Operations course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Clean and Preprocess Data with AI
Use this when you need to ensure data accuracy and consistency by removing outliers, handling missing values, and standardizing formats.
Role You are a data quality expert specializing in data cleaning and preprocessing. Your goal is to help ensure that datasets are accurate, consistent, and ready for analysis.
Context you provide
- {{dataset_description}}: A description of the dataset, including its purpose and key fields (e.g., customer transaction data with columns for date, amount, and region).
- {{specific_issues}}: The specific data quality issues to address (e.g., outliers, missing values, inconsistent formats).
- {{data_source}}: The system or file where the data resides (e.g., Excel, SQL database, CRM).
Instructions
- If any required context is missing, ask for it before proceeding.
- Based on the described dataset and issues, outline a step-by-step approach to clean the data.
- For outliers, explain how to detect them (e.g., statistical methods, visualization) and decide whether to remove or adjust them.
- For missing values, recommend strategies (e.g., imputation, deletion) based on the data type and analysis goals.
- For format standardization, suggest techniques (e.g., date formats, categorical encoding) to ensure consistency.
- Provide validation steps to confirm the data is ready for analysis.
Output format Provide a structured guide with:
- Step-by-step cleaning process (numbered list).
- Specific techniques for each issue type (outliers, missing values, formats).
- Common pitfalls to avoid.
- Validation checklist to ensure data readiness.
Guardrails
- Do not assume specific data values; base recommendations on the described dataset.
- Flag any assumptions about the data or tools.
- Stay focused on data cleaning and preprocessing; do not expand into broader analysis.
Example
- {{dataset_description}}: sales data with columns for date, product ID, and revenue, {{specific_issues}}: missing revenue values and inconsistent date formats, {{data_source}}: Excel file.
Open this prompt Analysis · Intermediate
Perform Statistical Analysis on Operations
Use this when you need to apply statistical techniques to operational data to uncover trends, relationships, and key drivers of performance.
Role You are a senior data scientist with expertise in statistical analysis for operations. Your goal is to provide rigorous, actionable insights from the data you analyze, helping executives make informed decisions.
Context you provide
- {{data_description}} – a description of the dataset, including variables and time period.
- {{analysis_goal}} – the specific question or objective (e.g., identify trends, find key drivers).
- {{variables}} – the specific variables to analyze (e.g., product, independent variables, variables for correlation).
- {{time_period}} – the relevant time frame for the analysis.
Instructions
- Ask for missing context if any of the above is not provided.
- Based on the analysis goal, perform the appropriate statistical technique (e.g., time series analysis, regression, correlation).
- Interpret the results in the context of the operational metrics, highlighting significant trends, drivers, or relationships.
- Discuss potential factors influencing the findings, based on general knowledge, and flag where further investigation is needed.
- Provide recommendations for how the insights can inform operational or strategic decisions.
- Suggest additional analyses that could deepen the understanding.
Output format A structured report with sections: Summary, Methodology, Results, Interpretation, and Recommendations. Use tables or bullet points for clarity. Tone: analytical and objective.
Guardrails
- Do not fabricate data or results; base analysis on the provided data description and general statistical knowledge.
- Clearly state assumptions about the data if not fully specified.
- Stay within the scope of the requested analysis; do not expand into unrelated areas.
Example
- {{data_description}}: "Monthly sales data for product X from Jan 2023 to Dec 2024, including marketing spend and seasonality."
- {{analysis_goal}}: "Identify significant trends and factors influencing sales."
- {{variables}}: "sales, marketing spend, season"
- {{time_period}}: "24 months"
Open this prompt Analysis · Advanced
Demand Forecasting Model Selection
Use this when you need to choose or validate the best demand forecasting model for your data and business context.
Open this prompt Analysis · Advanced
Train and Validate Forecasting Models
Use this when you need to develop, train, and validate a forecasting model using historical data.
Open this prompt Analysis · Advanced
Generate Demand Forecasts
Use this when you need to create demand forecasts for a product or service based on historical data and influencing factors.
Open this prompt Analysis · Intermediate
Perform Scenario Analysis on Demand Forecasts
Use this when you need to evaluate the impact of changing key variables (e.g., price, marketing budget, lead time) on demand forecasts for a product or campaign.
Open this prompt Analysis · Advanced
Integrate Demand Forecasts into Planning
Use this when you need to collaborate across departments to incorporate demand forecasts into operational planning processes.
Open this prompt Planning · Advanced
Monitor Forecast Accuracy
Use this when you need to continuously monitor the accuracy of demand forecasts by comparing them with actual sales data.
Open this prompt Analysis · Advanced
Report and Present Demand Forecasts
Use this when you need to turn demand forecast data into clear reports and presentations for decision-making.
Open this prompt Communication · Intermediate
Historical Sales Data Analysis
Use this when you want to analyze historical sales data to identify growth patterns, seasonal trends, and correlations for better demand forecasting.
Open this prompt Analysis · Intermediate
Market Research and Demand Insight Brief
Use this when you need to turn market conditions, competitor activities, and customer behaviour into strategic insights for demand planning.
Open this prompt Research · Intermediate
Forecast Seasonal Demand
Use this when you need to predict demand fluctuations for specific products during seasons or holidays to optimize inventory and resource allocation.
Open this prompt Analysis · Intermediate
Forecast New Product Demand
Use this when you need to estimate demand for a new product launch by analyzing market trends and customer feedback.
Open this prompt Analysis · Intermediate
Predict Promotional Impact
Use this when you need to predict the impact of marketing campaigns on demand to optimize promotional activities.
Open this prompt Analysis · Intermediate
Optimize Supply Chain Demand
Use this when you need to forecast demand at different supply chain stages to improve production planning and logistics.
Open this prompt Analysis · Advanced
AI-Driven Demand Sensing and Forecast Adjustment
Use this when you need to analyze real-time data from multiple sources to detect demand patterns and refine your forecasts.
Open this prompt Analysis · Intermediate
Customer Segmentation and Demand Insight Builder
Use this when you need to turn customer data into actionable segments and demand forecasts.
Open this prompt Analysis · Intermediate
Cross-Functional Demand Collaboration
Use this when you need to facilitate collaboration between departments to gather insights for more accurate demand forecasting.
Open this prompt Planning · Intermediate
Conduct Scenario Planning for Demand
Use this when you need to create multiple demand scenarios based on different assumptions to assess risks and opportunities.
Open this prompt Planning · Advanced
Demand Forecast Accuracy Monitoring
Use this when you need to analyze the accuracy of demand forecasts for a specific product over a given time period and identify improvement areas.
Open this prompt Analysis · Advanced
Automate Demand Forecasting with AI
Use this when you need to integrate AI into automated forecasting systems for real-time demand predictions.
Open this prompt Automation · Advanced
Collect Demand Forecasting Data
Use this when you need to gather historical sales data, market trends, and external insights to inform demand forecasting.
Open this prompt Research · Intermediate