Dataset Analysis Report
Takes messy spreadsheet or CSV files, inventories them, profiles the join keys, cleans and joins the data, analyzes it with charts where useful, and ships an answer-first report that leads with the finding and states its caveats. Use when the user asks to "analyze these spreadsheets", "join these CSV files", "what does this data show", "clean and combine these exports", or "build a report from this data". Do NOT use for building a blank workbook or tracker (use xlsx), valuation modeling (use dcf-valuation), completing a three-statement template (use 3-statements), or reporting from a published
Install
npx skills add microsoft/cat-agent-skills --skill dataset-analysis-reportgit clone --depth 1 https://github.com/microsoft/cat-agent-skills.git /tmp/cat-agent-skills
mkdir -p ~/.claude/skills
cp -r /tmp/cat-agent-skills/submissions/finance-for-cowork/skills/dataset-analysis-report ~/.claude/skills/dataset-analysis-reportPersonal skills live in ~/.claude/skills. Use .claude/skills in a project folder to share a skill with your team.
From the SKILL.md
# Dataset Analysis with Shipped Report Handles the unglamorous part honestly: work out what the files actually contain, whether they can be joined at all, and what the answer is — with its caveats attached rather than buried. ## When NOT to Use - **Building a blank workbook, template, or tracker** — use xlsx instead. - **Valuation or scenario modeling** — use dcf-valuation instead. - **Reporting from a published semantic model** — query Power BI directly - **Questions answerable without a data file** — just answer them ## Related Skills Hand off rather than overlap: - Variance narrative for a finance review — use variance-commentary instead. - Consolidating budget submissions — use budget-consolidation instead. - A slide-format readout — use pptx instead. - Receipt and expense processing — use expense-itemization instead. - Completing an existing income statement / balance sheet / cash flow template — use 3-statements instead. - Aggregating customer feature requests — outside this skill's scope. ## Workflow ### 1. Inventory before analyzing Find the files in `input/` first, then `sharepoint_onedrive-SearchDrive` if the user points elsewhere. For each file record: name, format, sheet or table names, row and column counts, and the period it appears to cover. **Show the inventory before doing any analysis.** Half of all bad data answers come from analyzing the wrong file, and the user can spot that instantly.
Details
- Skill name
dataset-analysis-report- Repository
- microsoft/cat-agent-skills
- Path
submissions/finance-for-cowork/skills/dataset-analysis-report/SKILL.md- License
- MIT
- Repo updated
- 15 November 2026
FAQ
What does the Dataset Analysis Report skill do?
Takes messy spreadsheet or CSV files, inventories them, profiles the join keys, cleans and joins the data, analyzes it with charts where useful, and ships an answer-first report that leads with the finding and states its caveats. Use when the user asks to "analyze these spreadsheets", "join these CSV files", "what does this data show", "clean and combine these exports", or "build a report from this data". Do NOT use for building a blank workbook or tracker (use xlsx), valuation modeling (use dcf-valuation), completing a three-statement template (use 3-statements), or reporting from a published
How do I install the Dataset Analysis Report skill?
skills CLI (Claude Code, Cursor, Codex and more): npx skills add microsoft/cat-agent-skills --skill dataset-analysis-report. Skills go in ~/.claude/skills (personal) or .claude/skills (project), and Claude loads them automatically when a task matches the description.
Is Dataset Analysis Report popular?
It lives in microsoft/cat-agent-skills, which has 110 GitHub stars and 122 forks.
Related skills
3 Statements
110microsoft/cat-agent-skills
Completes existing income statement, balance sheet and cash flow templates while preserving layout, grounding historical inputs and linking forecast formulas with reconciliation checks. Use for "fill in a 3-statement template", "complete an IS/BS/CF framework", "populate my integrated financial model", "link statements in this template", or "finish the forecasts in my three-statement workbook". Do NOT use for blank-slate models or general workbook edits (use xlsx), DCF valuation (use dcf-valuation), or buyout modeling (use lbo-model).
Accessibility Pass
110microsoft/cat-agent-skills
Use this skill whenever the user asks to check, review, or fix the accessibility of a PowerPoint deck, Word document, HTML page, or Markdown file, and before handing over any deck or document this agent just generated, so it does not ship with missing alt text, untitled slides, or unreadable colour contrast.
Accessible Learning Materials
110microsoft/cat-agent-skills
Maintains instructionally equivalent, accessible variants of a set of learning materials — lessons, readings, slides, and handouts — with parity checks against the original learning goals and recorded approvals. Use when the user asks to "make these materials accessible", "audit this lesson set for accessibility", "create an accessible version of this reading", "check reading level and alt text", or "keep my accessible variants in sync". Do NOT use for individual student accommodation or support-plan decisions (IEP, EHCP, or local equivalent), and do NOT use for generic document formatting (us
Dcf Valuation
110microsoft/cat-agent-skills
Builds discounted cash flow valuation models as banker-readable Excel workbooks with live formulas, a WACC x terminal-growth sensitivity grid, a reverse-DCF, and an explicit readiness gate. Use when the user asks to "build a DCF", "what is this company worth on a DCF basis", "run the WACC and terminal value", "what is the intrinsic value per share", or "what is the market implying". Do NOT use for LBO sponsor returns (use lbo-model), completing an existing three-statement template (use 3-statements), peer trading multiples, or non-valuation spreadsheets (use xlsx).
Cowork Use Case One Pager
110microsoft/cat-agent-skills
Turn a Cowork conversation or workflow into a high-value Cowork use case one-pager as a printable HTML page. Use when the user asks to "write up a Cowork use case", "make a one-pager for this workflow", "document what this scheduled task does", "turn this into a case example", "create a slide-style use case summary", or capture a task as a shareable internal case example. Do NOT use for a multi-slide deck, an editable Word or Excel document, or a plain written summary — this skill produces a single printable HTML page.
Doc Format Converter
110microsoft/cat-agent-skills
Use this skill whenever the user asks to convert a document or file from one format to another — Markdown, HTML, PDF, Word (.docx), PowerPoint (.pptx), Excel (.xlsx), CSV, or plain text (e.g. "turn this Word doc into a PDF", "make slides from this markdown", "save this page as markdown"). Only for producing a converted file as a deliverable. Do NOT use this skill to answer questions about a document's content — the analyzing-* skills handle that. Run the bundled scripts/convert.py instead of writing ad-hoc conversion code, BEFORE attempting any conversion yourself.
Browse the most popular Claude skills, all documents & office files skills, or write your own with the skills generator.