kpi-analyst

Name: kpi-analyst
Availability: InStock
Author: flyingtimes

Extract KPI indicators from Excel workbooks and generate per-sheet Markdown reports.

Updated Nov 5, 2025

Search Tags:#markdown #analysis #excel #xlsx #report #kpi

Ready to run

npx skills add https://github.com/flyingtimes/podcast-using-skill --skill kpi-analyst

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: kpi-analyst
Source: https://github.com/flyingtimes/podcast-using-skill/tree/main/.claude/skills/kpi-analyst
Command: npx skills add https://github.com/flyingtimes/podcast-using-skill --skill kpi-analyst

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

This Skill analyzes KPI data from an Excel workbook and automatically generates per-city markdown reports, enabling consistent and timely communication of performance metrics to stakeholders.

Core Features & Use Cases

Sheet-to-Report Conversion: Reads each worksheet and converts KPI data into Markdown reports.
Stakeholder Allocation: Distributes reports to city owners according to a predefined responsibility list.
Automated Output: Writes per-city reports to output/{city}.md for easy distribution and archival.

Quick Start

Place the input Excel file in the project, ensure the city responsibilities are defined in the distribution file, and run the KPI-Analyst workflow to generate per-city Markdown reports under the output/ directory.

Frequently Asked Questions about kpi-analyst

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I convert KPI data from Excel into markdown reports?▼

KPI-Analyst extracts indicators from Excel workbooks and generates structured markdown reports automatically. It processes each worksheet, analyzes KPI data, and outputs per-sheet reports to markdown files for stakeholder distribution.

Can I distribute KPI reports to specific city owners automatically?▼

Yes. The Skill allocates reports to city owners using a predefined responsibility mapping file. It reads city assignments from your distribution reference and writes individual markdown reports to each city's output file.

What Excel file structure does KPI-Analyst require?▼

The Skill works with multi-sheet Excel workbooks containing KPI indicator data. Each worksheet is processed independently, and a responsibility mapping file defines which cities receive which report sheets.

How does the Skill handle multiple worksheets in a single workbook?▼

KPI-Analyst performs per-sheet analysis on all worksheets in your Excel file. It generates individual markdown reports for each sheet, then aggregates city-specific briefings based on your responsibility assignments.

What's the best way to organize city responsibility assignments for report distribution?▼

Store city responsibility mappings in a reference file (分工.md format). The Skill reads these assignments to route each sheet's KPI analysis to the correct city owner, ensuring consistent stakeholder communication.