Data Analysis & Charts
DataIntermediateMedium credit usage
What this solves
Drop an Excel/CSV file and get cleaning, pivoting, charting and a conclusion-first narrative — the same pipeline works for market recaps, operations data and research summaries.
What you need
- Skill: Office Documents
- Screenshot tables first? Image to Excel
- Recommended: a data-analysis built-in expert
Steps
- State the question: "Which product line grew fastest this quarter?" beats "analyze this"
- Confirm understanding: have the agent output column names and 3 sample rows before anything else
- Two-phase instructions: first cleaning rules (dedupe/fill/date format) — confirm — then analysis and charts
- Output format: one conclusion-first paragraph, at most 3 charts, data appendix attached
Tips
- Two-phase beats one-shot: an error in the cleaning layer poisons everything downstream
- Specify chart types and dimensions to avoid rework loops
- For sensitive data, prefer the desktop app with a scoped authorized folder
📌 Patterns are field-tested; capabilities evolve — the official docs prevail. Independent third-party publication.