KirKruglov Report Analyzer
Analyzes large reports (PDF, PPTX) and produces a structured summary with key data and insights.
Target audience: product managers, marketers, analysts, finance professionals, C-level executives.
Language Detection
Detect the language from the user's message. Use that language for all output — the summary document, clarifying questions, and responses. If the user writes in Russian, respond and generate the output in Russian. If in English — in English.
Input
- A PDF or PPTX report file
- The user specifies the file name or path in their message, or uploads the file directly
Output
A structured summary document (up to 1.5 pages) containing:
- Report metadata
- Executive Summary
- Key figures and data
- Key insights
- Report structure
Instructions
Step 1 — Locate the input file
The user specifies the report file name in their message. Locate the file using this order:
- Check the current working directory and subdirectories (e.g.
input/folder or project root) - If the user provided a full path — use it directly
File search:
find . -iname "*.pdf" -o -iname "*.pptx" 2>/dev/null
If the file is not found — ask the user:
"Please specify the exact file name or path to the report, or upload the file directly. Supported formats: PDF, PPTX."
If the format is not supported:
"This skill works with PDF and PPTX files. Please provide a file in one of these formats."
Step 2 — Ask clarifying questions
Ask the user the following questions before proceeding:
Question 1: "What is the analysis focus?"
- General overview
- Numbers and data
- Strategic takeaways
- Everything combined
Question 2: "What output file format do you prefer?"
- .md
- .docx
Do not create the output file until both questions are answered.
Step 3 — Read and process the file
For PDF:
import pdfplumber
with pdfplumber.open("path/to/file.pdf") as pdf:
text = ""
for page in pdf.pages:
text += page.extract_text() or ""
# Extract tables
tables = page.extract_tables()
Also extract metadata:
from pypdf import PdfReader
reader = PdfReader("path/to/file.pdf")
meta = reader.metadata
pages_count = len(reader.pages)
For PPTX:
python -m markitdown presentation.pptx
If text extraction fails (scanned PDF) — use OCR:
import pytesseract
from pdf2image import convert_from_path
images = convert_from_path('file.pdf')
for image in images:
text += pytesseract.image_to_string(image)
Step 4 — Perform analysis
Based on the extracted text, generate content according to the structure below.
Analysis rules:
- Extract only facts and data from the report — do not infer or fabricate
- All numbers must be exact — as in the original
- Formulate insights in the third person ("the authors note", "the report indicates")
- If data is contradictory — flag it explicitly
- Output document must not exceed 1.5 pages
How to identify insights (selection criteria):
An insight is a statement from the report that meets at least one criterion:
- Non-obvious — the finding contradicts conventional wisdom or expectations ("contrary to popular belief...", "unexpectedly...")
- Quantitative shift — a sharp change in a metric (growth/decline >20%, trend reversal, record)
- Causal relationship — the report explicitly links cause and effect ("X led to Y", "the main driver is Z")
- Forecast or warning — authors make a prediction or flag a risk with specific parameters
- Actionability — a finding that enables a management decision (not just a description of the situation)
How to formulate an insight:
- One sentence, two at most
- Lead with the substance, not the context
- Include specific numbers where available
- Bad: "The AI market is growing" → Good: "The GenAI market grew 68% YoY to $127B, outpacing analyst forecasts by 15 p.p."
Number of insights: 5–7. If the report contains fewer significant findings — do not pad to 5 artificially.
Adaptation by focus:
- General overview — balanced across all sections
- Numbers and data — expanded data table, condensed insights
- Strategic takeaways — expanded insights, condensed data table
- Everything combined — all sections in full (within the 1.5-page limit)
Step 5 — Generate the output file
Use the structure from the "Output Format" section below.
By format:
.md— write the file directly.pdf— first generate.md, then use the pdf skill if available.docx— first generate.md, then use the docx skill if available
File naming:
report-summary_REPORT-NAME_YYYY-MM-DD.extension
Example: report-summary_mckinsey-ai-trends_2026-03-18.md
Save the file in the project output folder or current working directory. Deliver the file to the user.
Output Format
# Report Summary: [Report Title]
**Analysis date:** [date]
---
## Report metadata
| Parameter | Value |
|-----------|-------|
| Title | [full title] |
| Author / source | [company or author] |
| Publication date | [date or year] |
| Length | [page count] |
| Original language | [language] |
| Type | [consulting / research / analytics / market review / other] |
---
## Executive Summary
[3–5 sentences: core thesis of the report, main argument, key conclusion]
---
## Key figures and data
| Metric / indicator | Value | Context |
|--------------------|-------|---------|
| [metric 1] | [value] | [explanation] |
| [metric 2] | [value] | [explanation] |
| ... | ... | ... |
---
## Key insights
1. [insight 1]
2. [insight 2]
3. [insight 3]
4. [insight 4]
5. [insight 5]
---
## Report structure
| Section | Summary |
|---------|---------|
| [Section 1] | [1–2 sentences] |
| [Section 2] | [1–2 sentences] |
| ... | ... |
Negative Cases
- Do not add personal assessments or recommendations — only report content
- Do not exceed 1.5 pages in the output document
- Do not use filler phrases ("Sure, here's the analysis...")
- Do not retell the entire report — highlight what matters
- Do not round or alter numbers from the original
- Do not create the file until both clarifying questions are answered
Dependencies
pip install pdfplumber pypdf markitdown --break-system-packages
For PPTX:
pip install "markitdown[pptx]" --break-system-packages
For OCR (scanned PDFs):
pip install pytesseract pdf2image --break-system-packages