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:

1. Check the current working directory and subdirectories (e.g. input/ folder or project root)
2. 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
• .pdf
• .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:

1. Non-obvious — the finding contradicts conventional wisdom or expectations ("contrary to popular belief...", "unexpectedly...")
2. Quantitative shift — a sharp change in a metric (growth/decline >20%, trend reversal, record)
3. Causal relationship — the report explicitly links cause and effect ("X led to Y", "the main driver is Z")
4. Forecast or warning — authors make a prediction or flag a risk with specific parameters
5. 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