Prompt lesson · 17 prompts
Trend Analysis and Forecasting prompts for Systems Analysts
17 ready-to-use prompts from our AI for Systems Analysts course. Copy one, fill in the {{placeholders}}, and paste it into ChatGPT, Claude, Gemini or any other AI.
Data Collection and Cleaning
Use this when you need to gather and clean data from multiple sources for analysis.
Role You are a meticulous data analyst specializing in data collection and cleaning. Your goal is to prepare high-quality, analysis-ready datasets from raw, disparate sources.
Context you provide
- {{data_sources}}: List of sources (e.g., social media platforms, review sites, sales databases, analytics tools) from which to collect data.
- {{data_type}}: The type of data to gather (e.g., customer feedback, sales data, user behavior, survey responses).
- {{timeframe}}: The period for which data is needed (e.g., last quarter, past year).
- {{specific_requirements}}: Any additional criteria such as demographics, regions, or specific fields.
Instructions
- If any of the above inputs are missing, ask for them before proceeding.
- Outline a step-by-step plan for collecting data from each source, including methods (e.g., API calls, manual extraction) and tools.
- Clean the data by: removing duplicates, handling missing values, standardizing formats (dates, text, numbers), and correcting inconsistencies.
- Provide a summary of the cleaning steps taken and any assumptions made.
- Output the cleaned data in a structured format (e.g., CSV, table) ready for analysis.
Output format Provide a brief overview of the data collection process, followed by a detailed cleaning report, and finally the cleaned dataset in a table or CSV format. Use clear headings and bullet points for readability.
Guardrails
- Do not invent data; only work with the data provided or described.
- Flag any assumptions about missing data or ambiguous instructions.
- Stay within the scope of the requested data collection and cleaning; do not perform analysis unless asked.
Example
- {{data_sources}}: Twitter and Yelp; {{data_type}}: customer feedback; {{timeframe}}: last 6 months; {{specific_requirements}}: include reviews with 3+ stars.
Open this prompt Analysis · Intermediate
Perform Time Series Analysis
Use this when you need to analyze historical data to identify seasonal patterns and long-term trends.
Role You are a data scientist with expertise in time series analysis, helping users uncover patterns and make data-driven decisions.
Context you provide
- {{data_type}}: The type of data (e.g., sales, website traffic, financial, inventory).
- {{time_period}}: The specific years or timeframe to analyze (e.g., 2019-2023, last 5 years).
- {{analysis_goal}}: The objective (e.g., identify seasonal trends, forecast future values, compare to benchmarks).
Instructions
- Ask for any missing information about the data and goals.
- Analyze the historical data for trends, seasonality, and cyclical patterns.
- Use appropriate statistical methods to describe the data (e.g., moving averages, decomposition).
- Provide insights into what the patterns mean for the business.
- If requested, suggest forecasting methods and potential future trends.
Output format Provide a structured analysis with sections for data overview, trend identification, seasonal patterns, and insights. Use bullet points and clear headings. Keep the tone technical but accessible.
Guardrails
- Do not fabricate data; work only with provided information.
- Flag any assumptions about data quality or completeness.
- Stay within the scope of time series analysis; do not provide investment advice.
Example Data type: monthly sales; time period: 2019-2023; analysis goal: identify seasonal trends and forecast next year.
Open this prompt Analysis · Intermediate
Statistical Trend Forecasting
Use this when you need to build statistical models to forecast future trends based on historical data.
Open this prompt Analysis · Advanced
Scenario Analysis for Future Trends
Use this when you need to explore multiple possible futures and their impacts on a given topic.
Open this prompt Planning · Intermediate
Create Data Visualizations
Use this when you need to create clear and effective visualizations to present trend analysis and forecasting results.
Open this prompt Creating · Beginner
Trend Data Automation System
Use this when you need to automate the collection and analysis of trend data from various sources to identify insights and patterns.
Open this prompt Automation · Advanced
Predictive Modeling for Sales Forecasting
Use this when you need to build a predictive model to forecast sales based on historical data and market trends.
Open this prompt Analysis · Advanced
Customer Sentiment Trend Analysis
Use this when you need to analyze customer feedback and social media data to uncover sentiment trends and forecast behavior shifts.
Open this prompt Analysis · Intermediate
Demand Forecasting with Time Series
Use this when you need to analyze historical time series data to forecast demand for products or services.
Open this prompt Analysis · Advanced
Market Trend Monitoring and Reporting
Use this when you need to analyze market trends and generate reports on opportunities and threats.
Open this prompt Analysis · Intermediate
Scenario Planning and Forecasting
Use this when you need to forecast future outcomes by creating scenarios based on different variables and trends.
Open this prompt Planning · Advanced
Industry Trend Identification and Tracking
Use this when you need to identify and track emerging trends in a specific industry or market to inform strategic decisions.
Open this prompt Research · Intermediate
Forecast Resource Allocation Needs
Use this when you need to predict future resource requirements based on historical data, trends, and demand patterns.
Open this prompt Analysis · Intermediate
Forecast Equipment Maintenance Needs
Use this when you need to predict maintenance requirements for equipment based on historical or real-time data.
Open this prompt Analysis · Advanced
Identify Product Development Trends
Use this when you need to spot market trends and turn them into product development opportunities.
Open this prompt Research · Intermediate
Assess Risks from Trend Analysis
Use this when you need to identify potential risks by analyzing trends in a specific domain, such as finance, consumer behavior, cybersecurity, or climate.
Open this prompt Analysis · Intermediate
Trend-Based Investment Strategy Analysis
Use this when you need to analyze market trends and identify potential investment opportunities across sectors or regions.
Open this prompt Analysis · Intermediate