skills.rest
flyingtimes
flyingtimesCOMMUNITY
Explore all skills by this author →
GitHub

kpi-analyst

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

Updated Nov 5, 2025
Search Tags:#markdown#analysis#excel#xlsx#report#kpi
One-click install
npx skills add https://github.com/flyingtimes/podcast-using-skill --skill kpi-analyst
Or copy as Structured Prompt for Agent▼
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.

Related Skills

Explore More Data & Analytics Skills→
refly-airefly-ai
199

excel

Read and write data in specified Microsoft Excel worksheets.

Official
Intermediate
ajayatwal1105-emersonajayatwal1105-emerson

performance-report

Generate structured marketing performance reports from raw KPI and channel data.

Community
Advanced
ma-waisma-wais

excel-generator

Create and modify Excel workbooks with formatting, formulas, charts, and validation.

Community
Advanced
Ines-05Ines-05

business-bi-dashboard

Generate BI dashboards with KPIs and charts from CSV or Excel files.

Community
Advanced