Data AnalysisForecast framing

Frame a time series forecasting approach

Use to pick the right forecasting method and validation scheme before building anything.

The prompt
prompt.txt
Act as a forecasting specialist.

Series to forecast: {{series_description}}
Frequency: {{frequency}}
History available: {{history_length}}
Known drivers and events: {{known_drivers}}
Forecast horizon: {{horizon}}
Business use of the forecast: {{business_use}}

Task:
1. Diagnose what likely matters: trend, seasonality (which periods), holidays, external regressors.
2. Recommend 2 candidate methods (from naive baseline, ETS, ARIMA, Prophet, gradient-boosted lags, etc.) and explain when each wins.
3. Define a backtesting scheme (rolling origin or expanding window) with the exact split sizes.
4. Pick the right error metric for the business use and justify it.
5. List the failure modes to watch for.

Keep it actionable; do not write full model code yet.

Click the copy button in the top right of the block to grab the full prompt.

Variables

Replace each placeholder below with your own values before you run the prompt.

  • {{series_description}}
  • {{frequency}}
  • {{history_length}}
  • {{known_drivers}}
  • {{horizon}}
  • {{business_use}}
Recommended models
Claude Opus 4.8GPT-5Gemini 2.5 Pro
Tags
#forecasting#time-series#modeling#framing

Related prompts

Data AnalysisPlan cleaning
Build a data cleaning plan from a messy dataset

You are a meticulous data analyst. Here is a sample of my raw dataset (header row plus a few rows): {{sample_rows}} Context: this data describes {{data_description}} and I plan to...

Claude Opus 4.xGPT-5Gemini 2.5 Pro
#cleaning#data-quality#planning
View
Data AnalysisWrite cleaning code
Generate pandas code to clean a dataset

You are a senior Python data engineer. Write clean, reproducible pandas code to clean my dataset. Columns and their meaning: {{column_spec}} Known issues to handle: {{known_issues}...

Claude Opus 4.xGPT-5Gemini 2.5 Pro
#pandas#python#cleaning
View
Data AnalysisPlan EDA
Run an exploratory data analysis walkthrough

Act as a data analyst guiding me through exploratory data analysis. Dataset summary: {{dataset_summary}} My goal / the question I care about: {{analysis_goal}} Produce an EDA plan...

Claude Opus 4.xGPT-5Gemini 2.5 Pro
#eda#exploration#planning
View
Data AnalysisWrite SQL
Write a SQL query from a plain-English question

You are a SQL expert writing for a {{sql_dialect}} database. Here is the relevant schema (tables, columns, types, keys): {{schema}} Question to answer: {{question}} Rules: - Use on...

Claude Opus 4.xGPT-5Gemini 2.5 Pro
#sql#querying#database
View
Data AnalysisDebug SQL
Explain and debug an existing SQL query

You are a SQL reviewer. Explain and debug the query below. Dialect: {{sql_dialect}} What I expected it to return: {{expected_result}} What is actually wrong (if known): {{symptom}}...

Claude Opus 4.xGPT-5Gemini 2.5 Pro
#sql#debugging#performance
View
Data AnalysisTune SQL
Optimize a slow SQL query

You are a database performance specialist for {{sql_dialect}}. Slow query: {{query}} Context: - Approximate row counts of the main tables: {{table_sizes}} - Existing indexes: {{ind...

Claude Opus 4.xGPT-5Gemini 2.5 Pro
#sql#performance#optimization
View

0 Comments

Sign in to post

Loading discussion...