Prompt lesson · 17 prompts
Demand Forecasting prompts for Supply Chain Analysts
17 ready-to-use prompts from our AI for Supply Chain Analysts course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Analyze Historical Demand Data
Use this when you need to understand past demand patterns and the factors that influenced them to improve future forecasting and inventory planning.
Role You are a data-driven supply chain analyst. Your goal is to uncover the key factors that have driven demand fluctuations in the past and translate those insights into actionable inventory and forecasting strategies.
Context you provide
- {{product_or_service}}: The product, service, or product category to analyze.
- {{time_period}}: The historical time period to cover (e.g., "last 3 years").
- {{data}}: Historical sales or demand data (e.g., CSV, Excel, or a description).
- {{market_or_region}}: (Optional) Specific market, region, or customer segment to focus on.
- {{external_factors}}: (Optional) Known external factors such as seasonality, economic conditions, marketing campaigns, pricing changes, or product launches.
Instructions
- Ask for any missing context before starting.
- Analyze the historical data to identify demand patterns, trends, and fluctuations.
- Investigate the impact of the provided external factors (if any) on demand, quantifying their influence where possible.
- Highlight the most significant factors that have historically driven demand changes.
- Discuss how these factors have shaped overall demand trends.
- Provide actionable recommendations for future inventory management and forecasting accuracy.
Output format
- A structured report with sections: Data Overview, Key Findings, Factor Impact Analysis, Recommendations.
- Use bullet points and tables to present data clearly.
- Keep the tone professional and focused on actionable insights.
Guardrails
- Do not invent data; base all conclusions on the provided information.
- If you make assumptions about missing data, clearly flag them.
- Stay within the scope of historical demand analysis; avoid unrelated topics.
Example Product: "Coffee beans", Time period: "Jan 2021 - Dec 2023", Data: "Monthly sales by region", Market: "North America", External factors: "Pricing changes, promotions"
Open this prompt Analysis · Intermediate
Data Cleansing for Forecasting
Use this when you need to clean and preprocess raw data to ensure accuracy for demand forecasting models.
Role You are a data engineer who specializes in preparing raw data for accurate demand forecasting by cleaning, standardizing, and handling missing values.
Context you provide
- {{raw_data}}: The raw dataset (e.g., sales transactions, product lists) that needs cleansing.
- {{data_source}}: The source of the data (e.g., CRM, ERP, spreadsheets).
- {{product}}: The specific product or product line relevant to the data.
Instructions
- Ask for any missing context before starting.
- Identify and remove duplicate entries from the raw data, explaining the process and its importance.
- Standardize product names and attributes to ensure consistency across the dataset.
- Detect and handle missing values, suggesting appropriate imputation techniques (e.g., mean, median, or model-based).
- Provide a summary of the cleaning steps taken and how they improve data quality for forecasting.
Output format A step-by-step guide with code snippets or logical workflows for each cleaning task. Include a before-and-after comparison of data quality metrics. The tone should be technical and precise.
Guardrails
- Do not assume the data structure; ask for clarification if needed.
- Flag any potential biases in imputation methods.
- Stay within the scope of data cleansing; do not build forecasting models.
Example {{raw_data}} = "sales transactions with duplicate entries and inconsistent product names", {{data_source}} = "CRM export", {{product}} = "SKU-1234"
Open this prompt Automation · Advanced
Build Demand Forecasting Models
Use this when you need to develop or improve statistical demand forecasting models from historical sales data.
Open this prompt Analysis · Advanced
Analyze Demand Seasonality
Use this when you need to identify seasonal patterns in demand and adjust your forecasts and inventory accordingly.
Open this prompt Analysis · Intermediate
Analyze Long-Term Demand Trends
Use this when you need to identify long-term growth or decline patterns in demand and adjust supply chain strategy accordingly.
Open this prompt Analysis · Intermediate
Detect Demand Outliers
Use this when you need to identify unusual data points in your demand history that could skew forecasts and decide how to handle them.
Open this prompt Analysis · Intermediate
Collaborative Demand Forecasting
Use this when you need to gather insights from stakeholders and improve demand forecasting through collaboration.
Open this prompt Analysis · Intermediate
Evaluate Forecast Accuracy
Use this when you need to assess how well your demand forecasting models are performing and identify areas for improvement.
Open this prompt Analysis · Intermediate
Demand Scenario Analysis
Use this when you need to evaluate how different factors like market changes, disruptions, or pricing strategies might affect future demand.
Open this prompt Analysis · Advanced
Demand Segmentation Analysis
Use this when you need to segment demand data by customer type, region, or product category to improve forecast accuracy.
Open this prompt Analysis · Intermediate
Implement AI-Driven Demand Sensing
Use this when you need to integrate real-time data and market intelligence into demand forecasting to improve accuracy and responsiveness.
Open this prompt Analysis · Advanced
Demand Shaping with Data Analysis
Use this when you need to use data and AI to influence demand for a product or service through promotions and pricing.
Open this prompt Analysis · Intermediate
AI-Driven Demand Planning Integration
Use this when you need to integrate AI and ChatGPT into your demand planning process to improve forecast accuracy and align with supply chain operations.
Open this prompt Analysis · Intermediate
Analyze Demand Variability
Use this when you need to understand the uncertainty and risk in your demand forecasts by analyzing historical variability.
Open this prompt Analysis · Intermediate
Improve Forecast Accuracy
Use this when you need to analyze and enhance demand forecasting models to reduce errors and improve accuracy.
Open this prompt Analysis · Advanced
Market Research for Demand Forecasting
Use this when you need to gather and analyze market data to improve demand forecasting accuracy.
Open this prompt Research · Intermediate
Demand Forecasting Integration
Use this when you need to integrate demand forecasting outputs with supply chain planning systems to improve decision-making and efficiency.
Open this prompt Planning · Advanced