kpi-analyst
根据用户给出的excel文件内容,从中分析kpi指标的情况,并按照分工的列表,分别生成markdown格式的报告
When & Why to Use This Skill
The kpi-analyst skill automates the end-to-end process of transforming complex Excel data into actionable insights. It specializes in extracting KPI metrics from spreadsheets, analyzing performance across different dimensions (such as geographic regions), and generating personalized Markdown reports for specific stakeholders. By bridging the gap between raw data and professional documentation, it significantly reduces manual reporting overhead and ensures data consistency.
Use Cases
- Regional Performance Reviews: Automatically parse master KPI spreadsheets to generate individual performance reports for city managers or department heads.
- Automated Data Transformation: Convert dense Excel-based financial or operational data into clean, readable Markdown files for documentation or GitHub-based project tracking.
- Stakeholder Distribution: Streamline the reporting pipeline by automatically identifying responsible parties from a distribution list and creating tailored summaries for each person.
- KPI Monitoring and Auditing: Periodically analyze indicator trends from data exports and verify the generation of output files to ensure reporting compliance.
| 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/文件夹中存在各个负责人的输出文件,如果没有这个输出请再检查整个过程是否存在问题。