hermes
428 entries · 6 categories

Data analysis

Answering questions with data: spreadsheets, statistics, charts, reports and forecasts.

413 prompts, 7 personas, 6 workflows, 2 rules

Start here

9 start here · 383 specific · 36 advanced
PromptSpreadsheets

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.

write-spreadsheet-formula
PromptData visualisation

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.

choose-chart-type
WorkflowData visualisation

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.

dashboard-build-track
PromptStatistics

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.

choose-statistical-test
PromptData exploration

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.

write-analysis-plan
PromptReporting

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.

write-insight-report

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-dist
claude plugin install hodios-data-analysis@hodios

The 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
    PromptReporting

    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
    WorkflowReporting

    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
    WorkflowReporting

    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
    PromptReporting

    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.