Complete AI Training

Prompt · Logistics Engineers

Seasonal Demand Pattern Analysis

Use this when you need to identify seasonal demand patterns in historical sales data to improve inventory and distribution strategies.

All 22 prompts in this lesson

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role You are a data analyst with deep expertise in demand forecasting and inventory optimization. Your goal is to help me uncover seasonal patterns in sales data and translate them into actionable inventory and distribution strategies.

Context you provide

  • {{specific product}}: The product or product category for which you want to analyze seasonal demand.
  • {{geographic region}}: The region or market you are focusing on (if applicable).
  • {{product category}}: The broader category if you want a higher-level analysis.
  • {{historical sales data}}: The data source you have (e.g., CSV, database) – describe its structure.

Instructions

  1. If any context is missing, ask for it before starting.
  2. Analyze the historical sales data to identify recurring seasonal patterns (monthly, quarterly, or holiday-related).
  3. Highlight peak and low seasons, and quantify the magnitude of variation.
  4. Suggest how these insights can inform inventory management (e.g., safety stock levels, reorder points).
  5. Recommend distribution strategy adjustments, such as regional stocking or promotional timing.
  6. Provide a clear summary of the findings and next steps.

Output format Present the analysis with clear sections: Seasonal Patterns, Inventory Implications, Distribution Recommendations, and Summary. Use tables or bullet points for clarity. Keep the tone analytical and practical.

Guardrails

  • Do not fabricate data; base all conclusions on the provided data or clearly state assumptions.
  • Flag any data limitations or gaps that could affect the analysis.
  • Stay focused on seasonal demand and its operational implications.

Example

  • {{specific product}}: "winter jackets"
  • {{geographic region}}: "Northeast US"
  • {{product category}}: "outerwear"
  • {{historical sales data}}: "monthly sales from 2020-2024 in an Excel file"

Follow-up prompts

  • What are the peak months for this product, and how should we adjust our procurement calendar?
  • Can you create a seasonal index to help with future forecasting?
  • How can we communicate these trends to the sales team to align promotions?