kpi-analyst
根据用户给出的excel文件内容，从中分析kpi指标的情况，并按照分工的列表，分别生成markdown格式的报告
When & Why to Use This Skill
The kpi-analyst skill is a powerful automation tool designed to streamline the process of KPI data extraction and performance reporting. It automatically parses Excel spreadsheets, analyzes key performance indicators, and generates customized Markdown reports tailored to specific stakeholders or regional leads based on predefined distribution lists. This skill significantly reduces manual data entry and ensures consistent, data-driven communication across organizations.
Use Cases
- Regional Performance Distribution: Automatically extracting city-level KPI metrics from a master Excel file and generating individual Markdown reports for different regional managers.
- Automated Business Reviews: Converting complex spreadsheet data into structured, readable reports for weekly or monthly business performance meetings.
- Stakeholder Communication: Streamlining the workflow of notifying department heads about specific metrics by auto-generating personalized status updates based on their areas of responsibility.
- Data-to-Document Workflow: Transforming raw Excel data into professional Markdown documentation for project tracking and historical record-keeping.
| name | kpi-analyst |
|---|---|
| description | 根据用户给出的excel文件内容，从中分析kpi指标的情况，并按照分工的列表，分别生成markdown格式的报告 |
| allowed-tools | Read, Grep, Glob, Write, Search |
kpi-analyst
Instructions
1、所有的运行中输出的临时程序、文件、代码统一放到当前项目根目录下的output/ 2、根据用户指定的输入xlsx文件，参考refrerence/xlsx.md，得到每一页中的所有内容，并将结果写入当前项目根目录下的output/{sheetname}.md 3、根据当前项目根目录下output/指标通报.md文件中的内容，找到各个地市的指标，并按照reference/分工.md中的负责人信息，分别生成给不同地市的负责人的指标通报，结果写入当前项目根目录下的output/{负责人}.md 4、检查是否正确的在当前项目根目录下的output/文件夹中存在各个负责人的输出文件，如果没有这个输出请再检查整个过程是否存在问题。