Excel and CSV Data Analysis
bytedance/deer-flow
Analyzes uploaded Excel and CSV files with SQL through DuckDB, producing schema inspections, statistical summaries and exports to CSV, JSON or Markdown.
数据分析师工作规程。当用户给出销售/业务数据问题、要求统计、对比、趋势、归因、结论或建议时使用. An agent skill from zj-unicom-ai/UniEmployee.
Install Data Analysis
$ npx skills add zj-unicom-ai/UniEmployee --skill data-analysis -a claude-codeProject install by default; add -g for ~/.claude/skills/.
$ gh skill install zj-unicom-ai/UniEmployee data-analysis --agent claude-codeProject scope by default; add --scope user for a personal install. Needs GitHub CLI 2.90.0 or later (public preview).
$ git clone --depth 1 https://github.com/zj-unicom-ai/UniEmployee.git skills-src && mkdir -p .claude/skills && cp -r skills-src/backend/skills/data-analysis .claude/skills/data-analysis && rm -rf skills-srcUse ~/.claude/skills/ instead of .claude/skills for a personal install. The folder must contain SKILL.md.
Claude Code skills documentation · loads skills from .claude/skills/
Install the "data-analysis" agent skill from https://github.com/zj-unicom-ai/UniEmployee/tree/main/backend/skills/data-analysis into .claude/skills/data-analysis/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "data-analysis", then confirm the skill loads.Claude Code copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$skill-installer install https://github.com/zj-unicom-ai/UniEmployee/tree/main/backend/skills/data-analysisType this inside Codex. $skill-installer <name> installs a curated skill from openai/skills. The installer writes to $CODEX_HOME/skills (default ~/.codex/skills). Restart Codex if the skill does not show up.
$ npx skills add zj-unicom-ai/UniEmployee --skill data-analysis -a codexProject install goes to .agents/skills/; add -g for ~/.codex/skills/.
$ gh skill install zj-unicom-ai/UniEmployee data-analysis --agent codexProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/zj-unicom-ai/UniEmployee.git skills-src && mkdir -p .agents/skills && cp -r skills-src/backend/skills/data-analysis .agents/skills/data-analysis && rm -rf skills-srcUse ~/.agents/skills/ instead of .agents/skills for a personal install.
Codex skills documentation · loads skills from .agents/skills/
Install the "data-analysis" agent skill from https://github.com/zj-unicom-ai/UniEmployee/tree/main/backend/skills/data-analysis into .agents/skills/data-analysis/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "data-analysis", then confirm the skill loads.Codex copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add zj-unicom-ai/UniEmployee --skill data-analysis -a cursorProject install goes to .agents/skills/; add -g for ~/.cursor/skills/.
$ gh skill install zj-unicom-ai/UniEmployee data-analysis --agent cursorProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/zj-unicom-ai/UniEmployee.git skills-src && mkdir -p .cursor/skills && cp -r skills-src/backend/skills/data-analysis .cursor/skills/data-analysis && rm -rf skills-srcUse ~/.cursor/skills/ instead of .cursor/skills for a personal install.
Cursor skills documentation · loads skills from .cursor/skills/, .agents/skills/, .claude/skills/, .codex/skills/
Install the "data-analysis" agent skill from https://github.com/zj-unicom-ai/UniEmployee/tree/main/backend/skills/data-analysis into .cursor/skills/data-analysis/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "data-analysis", then confirm the skill loads.Cursor copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gemini skills install https://github.com/zj-unicom-ai/UniEmployee.git --path backend/skills/data-analysis--scope user (default) or --scope workspace; --path is the subfolder of the repo that holds the skill; --consent skips the security confirmation prompt.
$ npx skills add zj-unicom-ai/UniEmployee --skill data-analysis -a gemini-cliProject install goes to .agents/skills/; add -g for ~/.gemini/skills/.
$ gh skill install zj-unicom-ai/UniEmployee data-analysis --agent gemini-cliProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/zj-unicom-ai/UniEmployee.git skills-src && mkdir -p .gemini/skills && cp -r skills-src/backend/skills/data-analysis .gemini/skills/data-analysis && rm -rf skills-srcUse ~/.gemini/skills/ instead of .gemini/skills for a personal install, then run /skills reload.
Gemini CLI skills documentation · loads skills from .gemini/skills/, .agents/skills/
Install the "data-analysis" agent skill from https://github.com/zj-unicom-ai/UniEmployee/tree/main/backend/skills/data-analysis into .gemini/skills/data-analysis/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "data-analysis", then confirm the skill loads.Gemini CLI copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ gh skill install zj-unicom-ai/UniEmployee data-analysisInstalls for Copilot at project scope by default; add --scope user for a personal install. Preview a skill first with gh skill preview. Needs GitHub CLI 2.90.0 or later (public preview).
$ npx skills add zj-unicom-ai/UniEmployee --skill data-analysis -a github-copilotProject install goes to .agents/skills/; add -g for ~/.copilot/skills/.
$ git clone --depth 1 https://github.com/zj-unicom-ai/UniEmployee.git skills-src && mkdir -p .github/skills && cp -r skills-src/backend/skills/data-analysis .github/skills/data-analysis && rm -rf skills-srcUse ~/.copilot/skills/ instead of .github/skills for a personal install. Commit .github/skills so cloud agent and code review can use it.
GitHub Copilot skills documentation · loads skills from .github/skills/, .claude/skills/, .agents/skills/
Install the "data-analysis" agent skill from https://github.com/zj-unicom-ai/UniEmployee/tree/main/backend/skills/data-analysis into .github/skills/data-analysis/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "data-analysis", then confirm the skill loads.GitHub Copilot copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
$ npx skills add zj-unicom-ai/UniEmployee --skill data-analysis -a opencodeOpenCode documents no install command of its own. Project install goes to .agents/skills/; add -g for ~/.config/opencode/skills/.
$ gh skill install zj-unicom-ai/UniEmployee data-analysis --agent opencodeProject scope by default (.agents/skills/); add --scope user for a personal install.
$ git clone --depth 1 https://github.com/zj-unicom-ai/UniEmployee.git skills-src && mkdir -p .opencode/skills && cp -r skills-src/backend/skills/data-analysis .opencode/skills/data-analysis && rm -rf skills-srcUse ~/.config/opencode/skills/ instead of .opencode/skills for a personal install.
OpenCode skills documentation · loads skills from .opencode/skills/, .claude/skills/, .agents/skills/
Install the "data-analysis" agent skill from https://github.com/zj-unicom-ai/UniEmployee/tree/main/backend/skills/data-analysis into .opencode/skills/data-analysis/ in this project. Copy the whole folder (SKILL.md and every file beside it), keep the folder name "data-analysis", then confirm the skill loads.OpenCode copies the folder itself, the same result as the manual copy. Check what it changed before you commit it.
Facts
- Skill name
data-analysis- GitHub stars
- 359
- Token cost
- ~857 tokens
- SKILL.md length
- 229 words
- Files
- 1
- Skills in repo
- 22
- Repo updated
- First seen
- Licence
- MIT
At a glance
数据分析师工作规程。当用户给出销售/业务数据问题、要求统计、对比、趋势、归因、结论或建议时使用. An agent skill from zj-unicom-ai/UniEmployee.
- Tasks that involve Data analysis
- SKILL.md covers 通用分析流程（所有复杂问题必须遵守）, 流程一：数据库问数（默认）, 流程二：表格问答（用户上传 Excel/CSV 附件时） and 流程三：知识库检索（用户选了知识库作为数据源时）, plus 4 more sections
- Instructions only: no scripts, shell commands, URLs or credentials in SKILL.md
What it does
Data Analysis is an agent skill from zj-unicom-ai/UniEmployee. 数据分析师工作规程。当用户给出销售/业务数据问题、要求统计、对比、趋势、归因、结论或建议时使用。
Its SKILL.md is about 860 tokens, which your agent loads only when the skill is triggered. It is a single SKILL.md file with no bundled scripts.
It sits in Data & Analytics, covering Data analysis. It works with SQL. The repository describes itself as: 面向企业的数字员工构建与运行平台：把专业员工的经验、流程与判断标准，固化为可随时上岗、可配置、可审批、可观测的 AI 数字员工。 The licence is MIT.
When your agent uses it
- Tasks that involve Data analysis
Example prompts
- “/data-analysis”
Requirements
- Python 3
What it can do on your machine
Read from SKILL.md and the folder at commit c38a00a. It shows what the files ask for, not the result of running them.
Tool permissions
Pre-approves nothing: there is no allowed-tools line, so your agent's usual permission prompts apply.
From allowed-tools in the SKILL.md frontmatter.
Runs code
No scripts in the folder and no shell commands in SKILL.md.
From the folder's file list and the shell code blocks in SKILL.md.
Network
No URLs in SKILL.md.
From URLs in SKILL.md, links to its own repository left out.
Credentials
Names no API keys, tokens, secrets or passwords.
From names ending in _API_KEY, _TOKEN, _SECRET, _KEY or _PASSWORD in SKILL.md.
Context cost
Data Analysis loads about 857 tokens when it runs. Until then it costs about 16 tokens; SKILL.md has 229 words of instructions outside code blocks.
Estimates: characters ÷ 4, the usual rule of thumb; real counts depend on the model's tokenizer. Scripts and assets cost tokens only if the agent reads them.
Safety
Auto-check passed
The automated check found no risky patterns in SKILL.md.
Automated static check — not a guarantee. Review scripts before installing. It scans the text of SKILL.md for risky patterns (piping downloads into a shell, reading credential files, hidden Unicode, destructive commands); files beside SKILL.md are not scanned.
SKILL.md
The full file from zj-unicom-ai/UniEmployee at commit c38a00a, republished under its MIT licence (© zj-unicom-ai). 229 words, ~857 tokens.
Download SKILL.mdSave it as
.claude/skills/data-analysis/SKILL.md (or your agent's skills folder).- name
- data-analysis
- description
- 数据分析师工作规程。当用户给出销售/业务数据问题、要求统计、对比、趋势、归因、结论或建议时使用。
数据分析师工作规程
你是数据分析专家。你的任务不是简单返回 SQL 结果，而是按分析师工作方法完成：
理解业务问题 → 获取数据 → 验证数据 → 分析 → 归因 → 生成结论 → 输出报告/建议
数据分析能力有四个入口：数据库问数（sql_db_* 工具链）、表格问答（用户上传 Excel/CSV 附件，file_table_* 工具查询）、知识库检索（kb_search，用户选知识库作为数据源时）、连接器调用（MCP 工具，用户选连接器作为数据源时）。
通用分析流程（所有复杂问题必须遵守）
第一步：理解业务问题
- 识别用户真正要决策的问题，而不只是复述指标名
- 抽取：指标、时间范围、分析维度、对比基准、目标人群/对象、期望输出
- 若用户问题口径不清，但可以做合理假设，先说明假设后继续；若缺少关键数据源或指标定义，先简短澄清
第二步：获取数据
- 数据库问题走
sql_db_*；上传表格走file_table_*；知识库走kb_search；连接器走对应 MCP 工具 - 所有数字必须来自真实工具输出，禁止估算或编造
第三步：验证数据
- 重要分析、趋势分析、归因分析、报告类问题，必须先验证数据可信度
- 数据库表分析优先调用
sql_db_profile(table_names="...") - 对核心分析 SQL 或目标表调用
sql_db_quality_check(query="...")或sql_db_quality_check(table_name="...") - 验证重点：样本量、空结果、缺失值、重复记录、时间覆盖范围、指标字段是否适合当前问题
- 如果存在质量风险，后续结论必须说明限制；如果数据不足，不要强行给确定结论
第四步：分析
- 总览：先算核心 KPI 和整体趋势
- 对比：计算绝对差值和百分比差异
- 趋势：计算环比/同比，识别拐点和持续变化
- 结构：按地区、产品、渠道、客户分层等维度看占比和集中度
第五步：归因
- 用户问“为什么”、指标异常、趋势明显变化、KPI 未达标时，必须做归因
- 先确认异常事实，再按维度下钻，找贡献最大的拖累项/拉动项
- 输出时区分：事实（数据直接支持）、推断（基于数据的解释）、建议（下一步动作）
- 不要把相关性说成确定因果；因果不足时说“可能驱动因素”
第六步：结论与输出
- 结论先行：先说核心判断
- 每条结论必须有具体数字或来源支撑
- 给出业务建议，避免“加强管理”这类空话
- 报告类请求交给
report-generation规程输出 HTML 报告
流程一：数据库问数（默认）
用户问题未涉及上传附件时，一律走 SQL 工具链。
第一步：检索表结构（必须先调用）
- 调用
sql_db_smart_search(user_query="用户问题")获取最相关的表结构 - datasource_id 可不传，会话会自动注入当前选中的数据源
- 工具用 BM25 检索最相关的表，表数 ≤ 20 时返回全量
第二步：获取表关系（多表查询时）
- 调用
sql_db_table_relationship(table_names="表名1,表名2")获取外键关联
第三步：分析前验证
- 单点问数可跳过画像，但复杂分析、趋势、归因、报告必须调用
sql_db_profile或sql_db_quality_check - 核心 SQL 执行后，如结果用于重要结论，应调用
sql_db_quality_check(query="核心 SQL")检查样本量和缺失风险
第四步：编写并执行 SQL
- 只允许 SELECT 查询，禁止 INSERT/UPDATE/DELETE/DROP 等
- 结果限制 100 行
- 可先用
sql_db_query_checker(query)检查语法 - 用
sql_db_query(query)执行（datasource_id 可不传）
第五步：分析结果
- 如涉及客户/订单/产品等实体，可调用
ontology_find_entities关联本体 - 生成数据摘要、归因判断、质量限制和业务建议
流程二：表格问答（用户上传 Excel/CSV 附件时）
用户消息中出现「表格附件已自动注册为可查询数据表」时，走本流程：
第一步：了解表结构
- 消息里已列出注册表名/字段/行数；需要更多细节时调用
file_table_list() - 表名/字段名含中文或特殊字符时，SQL 中用双引号包裹
第二步：编写并执行 SQL
- 调用
file_table_query(query)（DuckDB 引擎，只读 SELECT） - 样本数据见注册摘要，可用于判断字段含义和格式
第三步：验证数据
- 对关键表格先看注册摘要；必要时调用
file_table_list() - 样本很小、关键字段缺失、时间范围不足时，结论必须降级为“基于当前样本”
第四步：分析结果
- 同流程一第五步
流程三：知识库检索（用户选了知识库作为数据源时）
当对话页顶部「选择数据源」下拉选了某个知识库时，走本流程。 会话自动注入当前选中的知识库 ID，无需手动传参。
第一步：检索知识库
- 调用
kb_search(query="用户问题或关键词")检索知识库 - 工具会自动限定到当前选中的知识库，无需指定
- 返回最相关的知识片段（top 3）
第二步：分析并回答
- 基于检索到的知识片段回答用户问题
- 回答必须标注来源：
来源：知识库名称 - 片段标题 - 若检索结果不足，告知用户并建议换关键词或转人工
流程四：连接器调用（用户选了连接器作为数据源时）
当对话页顶部「选择数据源」下拉选了某个连接器时，走本流程。 会话自动注入当前选中的连接器 ID。
第一步：调用连接器工具
- 根据连接器暴露的 MCP 工具（如
search_crm、query_news等）检索外部数据 - 工具调用参数按该工具的文档说明传入
第二步：分析并回答
- 基于连接器返回的数据回答用户问题
- 回答标注来源：
来源：连接器名称 - 工具名称 - 连接器故障或返回空时，告知用户外部数据源不可用
混合问数（数据库 + 知识库 + 连接器 + 附件）
- 先分别用对应工具取数，再在同一回复中对比分析
- 明确标注每个数字/结论的来源（数据库表 / 知识库 / 连接器 / 附件表格）
禁止行为
- ❌ 禁止调用 ls / glob / read_file / execute / write_file / run_python 等文件系统工具
- ❌ 禁止查找本地 csv / xlsx / json 文件——用户上传的数据文件已自动注册为表格，用 file_table_query 查询，不要读文件
- ❌ 禁止用 pandas 或 Python 脚本跑数据分析
- ✅ 数据库问题用 sql_db_* 工具链，上传表格问题用 file_table_* 工具
安全规则
- 只允许 SELECT 查询
- 查询失败最多重试 2 次，不要无限重试
- 不要重复执行相同的 SQL 查询
- 获取表架构后立即使用，不要重复获取
约束
- 数字必须来自 SQL 真实输出，禁止估算或编造
- 复杂问题必须拆成“总览 → 验证 → 下钻 → 归因 → 结论”
- 结论先行：先给结论，再给支撑数字、质量限制和业务建议
- 归因结论必须说明证据强度：数据直接支持 / 可能相关 / 需要补充数据验证
© zj-unicom-ai, MIT. Rendered from Markdown: HTML in the file is shown as text, images as links, and headings moved down two levels. Raw file
Files
Just SKILL.md in backend/skills/data-analysis of zj-unicom-ai/UniEmployee.
Open the folder on GitHubat commit c38a00a
Compare with similar skills
Data Analysis next to the 5 skills that share the most tags, products or categories with it. Stars are the repository's; “used in” counts other GitHub owners with a copy.
| Skill | Stars | Used in | Tokens | Auto-check | Licence | Repo updated |
|---|---|---|---|---|---|---|
| Data Analysis this skillzj-unicom-ai/UniEmployee | 359 | — | ~857 | Automated safety check: Pass | MIT | |
| Excel and CSV Data Analysisbytedance/deer-flow | 84k | 4 repos | ~2.2k | Automated safety check: Pass | MIT | |
| Ktx AnalyticsKaelio/ktx | 1.6k | — | ~10k | Automated safety check: Pass | Apache-2.0 | |
| Dinobase Business Data Querieskappa90/dinobase | 263 | — | ~1.5k | Automated safety check: Pass | Custom licence | |
| Code Generatorliangdabiao/claude-data-analysis-ultra-main | 290 | — | ~513 | Automated safety check: Pass | None | |
| Analytics Engineerborghei/Claude-Skills | 886 | — | ~3.4k | Automated safety check: Pass | MIT |
Similar skills
Ktx Analytics
Kaelio/ktx
A skill your agent uses when answering a question that needs data from a ktx-connected database - investigating, analyzing, "how many", "show me", "what's the breakdown of", finding records by…
Dinobase Business Data Queries
kappa90/dinobase
Sets up Dinobase, a local DuckDB database that syncs data from 100+ business sources, then answers questions across them with SQL joins and previewed write-backs.
Code Generator
liangdabiao/claude-data-analysis-ultra-main
Generates production-ready analysis code in Python, R, SQL. An agent skill from liangdabiao/claude-data-analysis-ultra-main.
Analytics Engineer
borghei/Claude-Skills
Analytics engineering across data modeling, dbt, transformation, and semantic layers.
Data Analysis
spytensor/openmozi
Data analysis workflow: ingest, validate quality, explore, analyze, report.
More from zj-unicom-ai/UniEmployee
All 22 skills in this repoEnterprise Customer Visit Playbook
zj-unicom-ai/UniEmployee
Prepares account managers for visits to government and enterprise customers: looks up the customer file, matches products, builds a Word solution document and files visit minutes.
Tencent ima Knowledge Base Reader
zj-unicom-ai/UniEmployee
Exports the article list and original article text from a Tencent ima knowledge base through a logged-in Chrome session, using browser automation.
Business Overview Analysis
zj-unicom-ai/UniEmployee
Produces a full business health analysis from sales, finance, inventory and customer CSV files: core KPIs, monthly trends, drill-downs and recommendations.
Competitor Deep-Dive Dashboard
zj-unicom-ai/UniEmployee
Produces a competitor benchmarking dashboard as an HTML page with an ECharts price comparison, from built-in profile cards plus fresh web research.
Insurance Operations Analysis
zj-unicom-ai/UniEmployee
Analyzes insurance operating data such as premium, loss ratio, renewal rate and expense ratio by branch, product and channel, flags anomalies and builds an HTML dashboard.
Market Alert Triage
zj-unicom-ai/UniEmployee
Assesses a reported market event such as a competitor price cut, new launch or negative press, verifies it, grades urgency from P0 to P2 and produces a short alert card.
Related
Works with
Categories
Questions about Data Analysis
What does Data Analysis do?
数据分析师工作规程。当用户给出销售/业务数据问题、要求统计、对比、趋势、归因、结论或建议时使用. An agent skill from zj-unicom-ai/UniEmployee. Data Analysis is an agent skill from zj-unicom-ai/UniEmployee.
When should I use Data Analysis?
Data Analysis fits situations like: tasks that involve Data analysis.
How do I install Data Analysis in Claude Code?
Run `npx skills add zj-unicom-ai/UniEmployee --skill data-analysis -a claude-code`. Or copy the skill folder (backend/skills/data-analysis in zj-unicom-ai/UniEmployee) into .claude/skills/data-analysis in your project. Claude Code loads it when a task matches its description.
How do I install Data Analysis in Codex?
Run `npx skills add zj-unicom-ai/UniEmployee --skill data-analysis -a codex`. Or copy the skill folder (backend/skills/data-analysis in zj-unicom-ai/UniEmployee) into .agents/skills/data-analysis in your project. Codex loads it when a task matches its description.
Can I use Data Analysis in Cursor, Gemini CLI or GitHub Copilot?
Cursor, Gemini CLI, GitHub Copilot and OpenCode also load SKILL.md folders. With the skills CLI, run `npx skills add zj-unicom-ai/UniEmployee --skill data-analysis -a cursor` (or -a gemini-cli, github-copilot or opencode for the others). To copy it by hand, put the folder in .cursor/skills/data-analysis, .gemini/skills/data-analysis, .github/skills/data-analysis and .opencode/skills/data-analysis in your project.
What does Data Analysis need to run?
SKILL.md names no scripts, command-line tools or credentials: Data Analysis is instructions for the agent only. Our summary lists: Python 3.
Does Data Analysis access the network?
SKILL.md contains no URLs. Any network use would come from the scripts or tools the agent runs. This is read from the text; nothing was executed.
Is Data Analysis safe to install?
Our automated static check of SKILL.md found no risky patterns, such as piping downloads into a shell, reading credential files or hidden Unicode. It is not a guarantee. Review the folder before installing.
What licence does Data Analysis use?
Data Analysis is published under the MIT licence (the repository's licence). It allows redistribution, so the full SKILL.md is shown on this page.
How many tokens does Data Analysis use?
About 857 tokens (SKILL.md is roughly 3.4k characters). Agents keep only the skill's name and description in context until a task matches; then they load SKILL.md in full.
What are the alternatives to Data Analysis?
Skills that share tags, products or a category with Data Analysis: Excel and CSV Data Analysis (bytedance/deer-flow, 84k stars), Ktx Analytics (Kaelio/ktx, 1.6k stars), Dinobase Business Data Queries (kappa90/dinobase, 263 stars) and Code Generator (liangdabiao/claude-data-analysis-ultra-main, 290 stars). The comparison table on this page puts their stars, adoption, token cost, safety result and licence side by side.
Who maintains Data Analysis?
zj-unicom-ai (a GitHub organization) maintains it in zj-unicom-ai/UniEmployee, which has 359 GitHub stars. The repository holds 22 skills in this directory. The repository was last updated on October 8, 2026.
Source: zj-unicom-ai/UniEmployee on GitHub. Facts on this page come from the repository at the commit we read; the author's words are quoted as theirs.