Pack 324 · Data · 13 items
Time Series & Event Data Pack
9 prompts + 4 skills for time series, event data and dbt models — real jobs from the week, with the steps, rules and output an expert would ask for.
€6one-time · 13 prompts & skills · ≈ €0.46 each
- Instant download
- Yours to keep
- Works in ChatGPT, Claude, Gemini
What's inside
Made for time series, event data and dbt models
9 prompts + 4 skills- PromptBuild A Slowly Changing Dimension Type 2
Implements SCD Type 2 history tracking with effective dates, current flags, and a correct merge in SQL.
- PromptBuild An Incremental dbt Model
Writes an incremental dbt model with correct unique key, late-arriving handling, and backfill strategy.
- PromptCompute Sessionization From Raw Events
Groups raw event logs into sessions using an inactivity gap and derives per-session metrics in SQL.
- PromptCurrency And Unit Normalization For Reporting
Builds SQL to convert multi-currency or mixed-unit transactions to a single reporting basis with correct rates.
- PromptDetect Anomalies In A Time Series
Flags statistical outliers in a metric over time using rolling baselines and explains likely causes.
- PromptFunnel Conversion Analysis With SQL
Constructs a stepwise conversion funnel with drop-off rates and time-to-convert from event data.
- PromptPivot And Unpivot Data In SQL
Reshapes data between long and wide formats with conditional aggregation or native PIVOT, including dynamic cases.
- PromptTime-Series Aggregation With Gap Filling
Produces a continuous, gap-filled time series with zeros for empty buckets and correct period boundaries.
- PromptWindow Function Mastery For Ranking And Trends
Solves ranking, running totals, and period-over-period problems with the right window function and framing.
- SkillReal-Time Streaming Analytics Designer
Designs low-latency streaming analytics with windowing, exactly-once, and late-data handling.
- SkillTime Series Forecasting Specialist
Builds and validates demand/metric forecasts with seasonality, backtesting, and uncertainty bands.
- SkillKnowledge Gap Mapper
Maps what is known, contested, and unknown on a topic to prioritize the highest-value research.
- SkillTime Series And Pattern Analyst
Interprets temporal data for trend, seasonality, anomalies, and forecast-readiness diagnostics.
What you download
Everything comes in one pack (.zip) you keep. Start with 00-GIVE-THIS-TO-YOUR-AI.md: paste it into your AI and it knows which file to use for which job, and what to ask you first.
More for Data Analysis & Excel
time-series-event-data/ ├─ 00-GIVE-THIS-TO-YOUR-AI.md ├─ START-HERE.md ├─ TIPS-AND-FOLLOW-UPS.md ├─ AI-CHEAT-SHEET.md ├─ prompts/ │ ├─ 01-build-a-slowly-changing-dimension-type-2.md │ ├─ 02-build-an-incremental-dbt-model.md │ ├─ 03-compute-sessionization-from-raw-events.md │ ├─ 04-currency-and-unit-normalization-for-reporting.md │ ├─ 05-detect-anomalies-in-a-time-series.md │ ├─ 06-funnel-conversion-analysis-with-sql.md │ ├─ 07-pivot-and-unpivot-data-in-sql.md │ ├─ 08-time-series-aggregation-with-gap-filling.md │ └─ 09-window-function-mastery-for-ranking-and-trends.md └─ skills/ ├─ real-time-streaming-analytics-designer/SKILL.md ├─ time-series-forecasting-specialist/SKILL.md ├─ knowledge-gap-mapper/SKILL.md └─ time-series-and-pattern-analyst/SKILL.md
A look inside
ROLE: You are a data warehouse engineer implementing slowly changing dimensions. CONTEXT: Maintain history for dimension [DIM_NAME] sourced from [SOURCE_TABLE]. The natural key is [NATURAL_KEY]; the tracked attributes …
Questions
What do I get?
A .zip with 9 prompts + 4 skills for time series, event data and dbt models: each prompt as a ready .md file, each skill as a SKILL.md folder, plus 00-GIVE-THIS-TO-YOUR-AI.md (a start file your AI reads first), START-HERE.md, TIPS-AND-FOLLOW-UPS.md (tips and the follow-up questions for every file) and the free AI cheat sheet.
How do I use it?
Open ChatGPT, Claude or Gemini and paste 00-GIVE-THIS-TO-YOUR-AI.md, or attach the folder. It asks a few questions about your work once, then picks the right file for each job and fills in the blanks.
Is it a subscription?
No. €6 once, and the files are yours to keep. Nothing renews.
How do I download it?
Right after checkout, on the confirmation page. Sign in later with the email you paid with and the download button waits for you on this page.
Why this price?
Packs are priced by what they hold: €0.50 a prompt and €1 a skill. This one is €6, about €0.46 an item.