Data analysis
Answering questions with data: spreadsheets, statistics, charts, reports and forecasts.
413 prompts, 7 personas, 6 workflows, 2 rules
- Loading the index…
Start here
9 start here · 383 specific · 36 advancedWrite a spreadsheet formula
Builds an Excel or Google Sheets formula from a plain-language goal and the sheet layout, explains how it works and flags edge cases. Use when you know the result you want but not the formula.
write-spreadsheet-formulaChoose a chart type
Recommends the chart that best carries a specific message for a given data shape, with encodings, the alternatives considered and the anti-patterns to avoid. Use before building a chart.
choose-chart-typeDashboard build track
Builds a dashboard in gated steps from decisions and users to metric definitions, data checks, a wireframe, a build spec and a QA and adoption review. Use when a dashboard must be trusted and used.
dashboard-build-trackChoose a statistical test
Picks the right statistical test for a research question and data shape, explains its assumptions and how to check them, and gives code to run it. Use before testing a difference or relationship.
choose-statistical-testWrite an analysis plan
Writes an analysis plan before touching data, covering the decision, questions, metrics, data, method, comparisons, pitfalls and the result that would change the decision. Use when scoping a request.
write-analysis-planWrite an insight report
Turns analysis results into a decision-oriented report with a headline finding, evidence, caveats and a recommendation. Use when you need to share an analysis with people who will act on it.
write-insight-reportCategories
Download all 428
Every entry in data analysis, ready for your tool. Free, CC0.
or install it as a claude code plugin
claude plugin marketplace add hermes-hq/hodios-distclaude plugin install hodios-data-analysis@hodiosThe plugin carries the prompts, personas, workflows and styles. Rules are always-on instructions, so add those from their own pages.
Start with these
A few from each category. Open a category for all of them.
Spreadsheets
All 84- Write a spreadsheet formula
Builds an Excel or Google Sheets formula from a plain-language goal and the sheet layout, explains how it works and flags edge cases. Use when you know the result you want but not the formula.
- Clean a messy spreadsheet
Cleans messy tabular data (headers, types, duplicates, inconsistent categories, stray totals) and logs every change it makes. Use before analysing an export or a hand-maintained sheet.
- Convert data between formats
Converts tabular or nested data between CSV, TSV, JSON, Markdown and XML, preserving every value exactly and flagging ambiguous fields. Use when data must move between tools without silent changes.
- Spreadsheet expert
Spreadsheet expert who builds clean, auditable Excel and Google Sheets workbooks, prefers simple formulas over clever ones and explains each step. Use as a standing spreadsheet helper.
Data exploration
All 83- Write an analysis plan
Writes an analysis plan before touching data, covering the decision, questions, metrics, data, method, comparisons, pitfalls and the result that would change the decision. Use when scoping a request.
- Analyse website analytics
Analyses website analytics (GA4 or similar) for traffic sources, landing pages, engagement and conversion, flags tracking problems first and gives prioritised actions. Use as a marketer or site owner.
- Classify text records
Classifies free-text records such as tickets, feedback or expenses into a given set of categories, with a confidence level and an explicit Other bucket, and returns a table.
- Reconcile two datasets
Reconciles two datasets that should agree, such as bank versus ledger or CRM versus billing, by matching records, listing mismatches and explaining likely causes. Use for month-end checks.
Statistics
All 71- Choose a statistical test
Picks the right statistical test for a research question and data shape, explains its assumptions and how to check them, and gives code to run it. Use before testing a difference or relationship.
- Explain a statistics concept
Explains a statistics concept such as a p-value, confidence interval or power, with intuition, a worked example, a simulation and common misreadings. Use to finally get it.
- Make a Fermi estimate
Makes a Fermi estimate by decomposing a quantity, stating assumptions with ranges, cross-checking from another angle and naming the data that would tighten it. Use for sizing when no data exists.
- Analyse A/B test results
Analyses A/B test results with a sample-ratio-mismatch check, effect sizes, confidence intervals and guardrail metrics, ending in a ship, iterate or stop call. Use when an experiment ends.
Data visualisation
All 64- Choose a chart type
Recommends the chart that best carries a specific message for a given data shape, with encodings, the alternatives considered and the anti-patterns to avoid. Use before building a chart.
- Dashboard build track
Builds a dashboard in gated steps from decisions and users to metric definitions, data checks, a wireframe, a build spec and a QA and adoption review. Use when a dashboard must be trusted and used.
- Interpret a chart
Explains in plain words what a chart shows, what it does not show, how it might mislead and what to ask about it. Use when you are handed a chart in the news, a report or a meeting.
- Draw a process diagram
Draws a process as a valid Mermaid flowchart, swimlane or sequence diagram with decisions, owners and exceptions, and lists the gaps in the description. Use to document how a process works today.
Reporting
All 70- Write an insight report
Turns analysis results into a decision-oriented report with a headline finding, evidence, caveats and a recommendation. Use when you need to share an analysis with people who will act on it.
- Build a data report file end to end
Builds a data report file end to end, confirming the question, scripting analysis and charts, drafting traceable findings and exporting a document or deck after review. Use to answer a data question.
- Analysis project track
Takes a stakeholder request from question to analysis plan, data checks, analysis and a decision-ready report, pausing for review between steps. Use when an analyst takes on a request.
- Define a metric
Writes a precise metric definition (formula, grain, filters, edge cases, owner, known caveats) so every team computes the number the same way. Use when a metric is disputed or about to be launched.
Forecasting
All 56- Make a forecast
Forecasts a number or an event from whatever you have - a history, drivers or only judgement - with a baseline, a low-likely-high range and what to watch. Use for sales, demand or any "what next".
- Forecaster
Acts as a seasoned business forecaster who insists on baselines, ranges, backtests and honest track records, and helps people forecast demand, revenue, staffing and uncertain events.
- Forecast event attendance
Forecasts how many people will actually turn up to an event from registrations, ticket type and past events, with a range, planning numbers for catering and staff, and signals to update it.
- Write forecast commentary
Writes forecast commentary explaining the change from the last forecast with a bridge, drivers, quantified risks, confidence and decisions needed. Use for monthly or quarterly reforecasts.