13 data prompts
SQL from a question, checking an analysis for the ways it could be lying, picking a chart, and defining a metric precisely.
Check this analysis
Where the numbers could be lying.
Clean up this messy column
Find the patterns, then the rule that normalises them.
Turn a CSV into something useful
Understand the shape before transforming it.
Deduplicate records
Decide what counts as the same thing first.
Define a metric precisely
Pin the edges so two people compute the same number.
Explain a number to a non-analyst
What it means and what it doesn't.
Explain this query
What it returns, and where it will hurt.
Model this in a spreadsheet
Inputs, formulas, and the assumption doing the work.
Pick the right chart
Match the form to the comparison being made.
Spot-check a dataset
The five queries to run before trusting it.
SQL from a plain-English question
The query, plus the assumptions it is making.
Why did this number change?
Decompose the move before explaining it.
Write a query that guards a report
Fail loudly when the underlying data drifts.
Other categories
Keep these data prompts a keystroke away
SnipTray puts the whole library behind one shortcut, turns each blank into a field, and pastes the finished prompt into whatever app you're in.