Skills for Analysts
“From messy export to defensible answer.”
The analysis pipeline in skill form: clean the data (with an audit trail), query it correctly, analyze it honestly, present it clearly. Every skill here was tested on deliberately messy data, because that's the job.
- 001 Tested · Works
Enforces frame-inspect-check-assumptions-effect-size-APA-report pipeline for hypothesis tests; bundled Shapiro-Wilk/Levene's script actually runs.
- 002 Works with setup
Turns pasted or queried metrics into a structured weekly/monthly/quarterly review — scorecard, trend analysis, bright spots vs. concerns, recommended actions. Does not build the dashboard itself.
- 003 Tested · Works
Extracts invoice/receipt data into JSON and validates the arithmetic; flags mismatches.
- 004 Tested · Works
Merge, split, fill forms and OCR scanned PDFs.
- 005 Tested · Works
Read, clean and build spreadsheets with working formulas.
- 006 Works with setup
Generates a single self-contained HTML dashboard (KPI cards, Chart.js, filters, sortable table) — despite the 'no dependencies' claim, charts load Chart.js from a CDN.
- 007 Tested · Works
Prompt-only SQL generator that always returns query + explanation + performance notes + test script for BigQuery/Postgres/MySQL/Snowflake — no schema-parsing tooling of its own.