Skip to content
Prompt Library

Data Analysis

12 prompts in this category. First 5 shown free.

Back to all categories

7 of 12 prompts are locked. Unlock to read, copy and download them all — plus every new one we add, free.

Search Trends Line Graph for [Topic], Last 12 Months

Create a line graph showing search trends for [insert topic] over the last year.

Cohort Retention SQL and Interpretation Guide

Write SQL for a cohort retention table on [TABLE]: group users by their [SIGNUP_PERIOD] cohort, then show the % still active in each following period. State the cohort definition, the return-event that counts as retained, and how you handle partial/incomplete cohorts. Return the query plus how to read the triangle.

Metric Result Sanity Check With Significance and Bias Assessment

I see [RESULT] in [METRIC]. Before I act, run sanity checks: is the sample large enough, is the difference statistically significant (state test + p-value), could a confounder like [VARIABLE] or seasonality explain it, is it survivor/selection bias, and is the metric definition stable. Output: verdict (real / noise / unclear) + what to check next.

Pandas Data Cleaning Pipeline with Before/After Row Count

Write a pandas cleaning pipeline for messy [DATASET]. Handle in order: coerce dtypes (pd.to_datetime, numeric), strip/lowercase text, standardize categories, decide drop vs fillna per column with a stated reason, remove exact + near-duplicates, and rename columns to snake_case. Output runnable code plus a before/after row-count log.

Decision Dashboard Design with North Star and Leading/Lagging Metrics

Design a decision dashboard for [GOAL] / [TEAM]. Pick one North Star metric, then 4-6 supporting metrics pairing each leading indicator next to the lagging one it drives, plus 1-2 guardrail metrics. For each: definition, why it's actionable not vanity, and the threshold that should trigger a decision. Return as a table.

Free preview ends here

Locked

First-Pass EDA Report with Pandas Diagnostics

Locked

Funnel Dropoff Analysis for [FUNNEL_STEPS] with SQL and Segments

Locked

Churn Reduction Plan With Win-Backs, Flow Fixes, and Early Signals

Locked

Analyze the Data

Locked

Clean and Fix the Data

Locked

Create Charts and Dashboard Ideas

Locked

Generate Excel Formulas

Unlock all 12 prompts

Buy this category on its own, or get every category with the bundle.

And it doesn't stop at 12. We add new Data Analysis prompts every week, and they unlock for you automatically — no upgrade, no second payment.

Already purchased? Log in