By use case

Top Data & Analytics Skills

Data sources, scientific datasets, BI dashboards, D3 viz patterns, structured extraction.

10 skills indexed · ranked by composite score

Top 6 Data & Analytics skills

  1. 1.deep-researchCited research reports from fanned-out web search with adversarial verification.
  2. 2.research-synthesisTurn raw research into themes, segments, and a prioritized next-steps list.
  3. 3.performance-reportExecutive-ready performance reports with next-period priorities.
  4. 4.firecrawlWeb scraping, search, and browser automation built to be agent-friendly.
  5. 5.valyuWeb search + 36 authoritative data sources. SEC, PubMed, ChEMBL, FRED — agent-grade research.
  6. 6.xlsxExcel spreadsheets with real formulas, charts, and formatting — not flat CSV exports.

About Data & Analytics

The best agent skills for data and analytics in 2026 are Anthropic's official `xlsx` Skill for spreadsheet work — preserving formulas, charts, and conditional formatting that pandas drops — and the BI dashboard Skills (Looker, Metabase, Hex) for turning live data into published reports. Data & analytics Skills give agents the chops to handle the full data-team workflow — from messy CSV cleanup to dashboard authoring to scientific dataset analysis. The category covers BI dashboard generation (Looker, Metabase, Hex), structured extraction from PDFs and scraped pages, D3 visualization patterns, jupyter notebook authoring, and ETL Skills that wire data sources together.

Common workflows include cleaning malformed spreadsheets into proper datasets, generating SQL for a question, building a chart from a dataset, exploratory analysis in a notebook, extracting tables from PDFs for analysis, and authoring repeatable data pipelines. Several Skills pair with Supermetrics, Ahrefs, Datadog, or other analytics MCP servers so the agent has live data access. The xlsx Skill — Anthropic-authored — anchors the spreadsheet half of this category and frequently shows up in non-analytics workflows too.

Data scientists, analytics engineers, BI leads, and product managers running their own analyses use these. Composite scoring weights install count (xlsx and the BI Skills dominate), provenance (Anthropic, well-known data orgs), and how well the Skill handles the messy real-world cases: misplaced headers, encoding issues, mixed types, merged cells.

Ranked by score

Best Data & Analytics Skills

Skills that do data & analytics well — ranked transparently.

Official

Cited research reports from fanned-out web search with adversarial verification.

ResearchWeb SearchSynthesis
Code

Turn raw research into themes, segments, and a prioritized next-steps list.

ResearchSynthesisUX
All surfaces

Executive-ready performance reports with next-period priorities.

ReportingAnalyticsKPIs
All surfaces
Verified

Web scraping, search, and browser automation built to be agent-friendly.

ScrapingSearchWeb
All surfaces
Verified

Web search + 36 authoritative data sources. SEC, PubMed, ChEMBL, FRED — agent-grade research.

SearchSECPubMed
All surfaces
Official

Excel spreadsheets with real formulas, charts, and formatting — not flat CSV exports.

ExcelFormulasCharts
All surfaces

Ethical scraping at scale. robots.txt respect, rate-limiting, structured extraction.

ScrapingEthicsSchema
Code
Community

D3.js patterns for interactive viz that does not look stock.

D3.jsVizInteractive
Code

MongoDB aggregations and indexing without the foot-guns.

MongoDBAggregationNoSQL
Code

Scientific computing + dataset APIs. Reproducible research workflows for agents.

Sciencescikit-learnReproducibility
Code

FAQ

Frequently asked

What does the xlsx Skill do that pandas does not?

It preserves formulas, conditional formatting, merged cells, and chart objects — things pandas drops on read. For analysis, pandas is fine. For creating or editing existing spreadsheets that humans will open, xlsx is the right tool.

Can these Skills query my warehouse?

Pair them with a Supabase, BigQuery or Snowflake MCP server and yes. Standalone Skills generate SQL but do not run it.

Do they handle large datasets?

For multi-gigabyte data, Skills generate the right tooling (DuckDB, polars, Spark snippets) rather than loading everything into the agent's context.

Which Skill is best for jupyter notebooks?

The Anthropic-authored notebook-edit tool plus the data-analysis Skills cover the common cases — read all cells with outputs, edit specific cells, run targeted analyses.

Are BI dashboard Skills cross-platform?

Most target one tool (Looker, Metabase, Hex). Cross-platform support is rare and a sign of a mature Skill — check the compatibility filter.

Other categories

Browse other use cases