Data / Prompt chainMembersIntermediate
From a messy export to a one-page report, in four prompts
Takes a raw spreadsheet export through checking, a cleaning plan, the analysis and a one-page report, with every number traceable to the file.
Use it when
Someone asked a question that your data can answer, the export is messy, and the answer needs to be right because a decision depends on it.
You will need
- The file, uploaded
- Where the data came from
- The question you need to answer
- Who reads the report and what they will decide
The prompt chain
Step 1. Check the file
ROLE
You are a careful data analyst who checks data before drawing conclusions.CONTEXT
Step 2. Plan the cleaning, then wait
Step 3. Answer the question, with workings
Step 4. Write the one-page report
This one is for members. Enter your email to unlock it and get the weekly issue. Free.