Data & Analytics

richfrem Bundle

Excel to CSV conversion skill. Convert specific bounding tables or entire worksheets within `.xlsx` or `.xls` binary formats into flat `.csv` tabular data. Use this when you find an Excel file and need its data mapped into an accessible format for text analysis, filtering, or programmatic pipelining.

allinherog-star Bundle

资料整理助手适合运营、产品、销售、software在用户提出“这份材料重点是什么”这类问题，需要快速拆解目标、判断重点并形成可执行结果时使用，帮助基于输入材料生成合并方案、字段冲突清单、处理结果说明。

allinherog-star Bundle

Amazon 品牌分析助手适合运营、产品、销售、software在用户提出“品牌数据说明什么”这类问题，需要快速拆解目标、判断重点并形成可执行结果时使用，帮助基于输入材料生成商品/店铺诊断、卖点与风险提示、运营动作建议。

iamwaqargulzar Bundle

When the user wants to create, plan, or optimize a lead magnet for email capture or lead generation. Also use when the user mentions "lead magnet," "gated content," "content upgrade," "downloadable," "ebook," "cheat sheet," "checklist," "template download," "opt-in," "freebie," "PDF download," "resource library," "content offer," "email capture content," "Notion template," "spreadsheet template," or "what should I give away for emails." Use this for planning what to create and how to distribute it. For interactive tools as lead magnets, see free-tools. For writing the actual content, see copywriting. For the email sequence after capture, see emails.

iamwaqargulzar Bundle

Compatibility skill for analytics tracking. Use when a user or upstream workflow invokes this name; route the task to `analytics` while preserving the requested scope and source-specific intent.

joogy06 Skill

Use when analyzing large text-based files (CSV, TXT, logs, JSON lines, TSV) that exceed or approach the AI context window — chunked reading strategies, position tracking (line numbers, byte offsets), temp file accumulation for intermediate findings, multi-pass analysis patterns, CSV header preservation across chunks, progressive summarization, grep-first-then-read targeting, and final aggregation before output. Essential for token-limited AI agents (Copilot, Claude Code, Cursor, Windsurf) working with files over 2000 lines.

joogy06 Skill

Use when reading, writing, transforming, decrypting, or converting Excel files from Python — .xlsx (openpyxl, xlsxwriter, pandas), .xls legacy (xlrd <2.0), .xlsb (pyxlsb), encrypted workbooks (msoffcrypto-tool), Excel automation on Windows/macOS with Office installed (xlwings, pywin32 COM), or formula evaluation without Excel (pycel, formulas). Covers formula injection (CWE-1236) sanitization, XXE defence for parsed XML, and large-file streaming patterns. Part of the ms-office-python-* skill family.

joogy06 Bundle

Use when you want a STANDALONE, DETERMINISTIC (no-LLM) data-lineage extractor for legacy mainframe code — fixed-format COBOL + JCL + embedded EXEC SQL (DB2), plus deterministic Control-M Automation-API jobs-as-code (scheduler->program->data, job->job event DAG) -> OpenLineage 2.0.2 ndjson. The deterministic plug-in track under lineage-extract-static (a complement to the LLM-as-parser family — run both and compare yourself; no diff harness in scope). Pure stdlib + OPTIONAL sqlglot (regex fallback, NO silent LLM fallback) + OPTIONAL networkx. Non-interactive CLI (run_lineage.py): flags only, zero prompts, scriptable in CI/cron. Static analysis only (v1). The mainframe sibling of lineage-extract-static (flow), structure-recovery (shape), legacy-code-intel (symbols). Also trigger on "deterministic mainframe lineage", "COBOL/JCL/DB2 lineage", "EXEC SQL lineage", "OpenLineage from mainframe", "DD-join lineage", "host-var to column lineage", "Control-M lineage", "scheduler lineage".

joogy06 Bundle

Use when the user asks to validate a business idea, design experiments, draft interview scripts, capture evidence from real-world tests, or review assumption status. Phase 2 subskill of the founder family. Validation SUPPORT — designs experiments, drafts interview scripts (Mom Test), captures evidence, reads analytics via browser MCP (Envelope D). You run the experiments and report back. Modes: design_experiment, draft_interview, capture_evidence, read_analytics, evidence_review. Routes via parent `founder` skill. Trigger on: "validate my idea", "design an experiment", "Mom Test", "interview script", "capture evidence", "what do we know", "assumption ledger", "read my analytics", "evidence review".

joogy06 Bundle

Use when turning business source documents into postable transactions — PDF bank and card statements, PDF sales and purchase invoices, CSV bank exports, marketplace and payment-processor settlement files, and receipts. Covers extraction routes by document type, the validation contract every extraction must pass before it reaches the books, duplicate detection, and how to record provenance so every posted figure traces back to the document it came from.

joogy06 Skill

Use when connecting Python to enterprise databases (DB2, Oracle, SQL Server, Teradata), mainframe systems (z/OS, CICS, IMS, MQ), or building custom database connectors. Covers ibm_db, Zowe SDK, pyodbc, python-oracledb, EBCDIC handling, credential management, and connection security.

planifest Bundle

Pre-landing PR review. Analyzes diff against the base branch for SQL safety, LLM trust boundary violations, conditional side effects, and other structural issues. Use when asked to "review this PR", "code review", "pre-landing review", or "check my diff". Proactively suggest when the user is about to merge or land code changes. (gstack)

planifest Bundle

Style, review, and refactoring standards for Go codebases. Trigger when `.go`, `go.mod`, `go.sum`, or `go.work` files are created, changed, or reviewed and Go-specific quality rules (error handling, concurrency patterns, interface design, package boundaries) must be enforced. Do not use for generic shell scripts, SQL-only changes, or non-Go runtime style concerns unless Go artifacts are also changed. In multi-language pull requests, run together with other applicable `*-style-guide` skills.

rweisssieker-xp Skill

Use when Power BI detects data-quality issues and they must be routed to master data, SAP, CRM, finance, plant, warehouse, supplier, customer, or data platform owners.

rweisssieker-xp Skill

Use when Power BI work needs Power Query M designs or code for APIs, SAP OData, SQL, files, pagination, incremental refresh, schema drift, error handling, typing, and folding.

rweisssieker-xp Skill

Use when natural-language source extraction requirements should become Power Query/M designs for APIs, OData, SQL, files, pagination, incremental refresh, typing, error handling, or schema drift.

rweisssieker-xp Skill

Advise on modern Power BI and Microsoft Fabric architecture. Use for Import vs DirectQuery vs Direct Lake, composite models, Dataflows, Lakehouse, Warehouse, OneLake, semantic model ownership, deployment pipelines, and medallion architecture decisions.

rweisssieker-xp Skill

Use when Power BI solutions require a Fabric deployment blueprint covering workspaces, Lakehouse, Warehouse, Dataflows, semantic models, pipelines, Git, capacity, security, and release flow.

rweisssieker-xp Skill

Use when assessing Power BI maturity, data readiness, CoE maturity, process analytics maturity, report portfolio health, governance maturity, expert reduction potential, or management benchmark scorecards.

rweisssieker-xp Bundle

Map industrial process questions to source systems and source objects for Power BI. Use for SAP ECC/S4HANA, SAP BW, SAP Datasphere, Salesforce, Dynamics, Oracle, Infor, IFS, Siemens Teamcenter, Windchill, MES, SCADA, historian, WMS, TMS, ServiceNow, Jira, Excel, data lakes, warehouses, and custom APIs.

rweisssieker-xp Skill

Use when Power BI sources include WHS, WMS, warehouse management, warehouse automation, robotics, scanners, AutoStore, Kardex, Dematic, Swisslog, Körber, Manhattan, Blue Yonder WMS, SAP EWM/WM, Zebra, Honeywell, or warehouse execution systems.

rweisssieker-xp Skill

Use when Power BI, Fabric, SAP, Salesforce, SQL, Snowflake, Databricks, APIs, files, or semantic models need scheduled or repeatable metadata scans.

rweisssieker-xp Skill

Use when migrating SAP BW, SAP extracts, Excel, Access, SSRS, Tableau, Qlik, or legacy warehouse reporting into Power BI, Fabric, Lakehouse, Warehouse, Direct Lake, or certified semantic models.

rweisssieker-xp Skill

Use when industrial analytics should be delivered as governed data products such as O2C, P2P, Production, Finance, Customer, Supplier, Material, Asset, or Maintenance data products instead of one-off reports.

rweisssieker-xp Bundle

Understand and solve Power BI analytics questions for industrial companies across all main end-to-end processes, including Lead2Order, Order2Cash, Procure2Pay, Source2Contract, Forecast2Plan, Plan2Produce, Make2Stock, Engineer2Order, Idea2Launch, Record2Report, Hire2Retire, Issue2Resolution, Maintain2Operate, and Supply Chain Control Tower.

rweisssieker-xp Skill

Use when Power BI sources include lakehouse, warehouse, Snowflake, Databricks, BigQuery, Redshift, Synapse, Fabric Warehouse/Lakehouse, Teradata, Exasol, Delta, Parquet, or enterprise analytical stores.

rweisssieker-xp Skill

Use when a customer-specific Power BI/Fabric target architecture must be generated for source landscapes such as SAP plus Salesforce plus MES, Oracle plus WMS plus Snowflake, Dynamics plus Dataverse plus Fabric, or hybrid Excel/data warehouse legacy estates.

rweisssieker-xp Skill

Use when benchmarking Power BI process analytics, KPI maturity, data readiness, report quality, CoE maturity, and expert-replacement maturity against internal or industry bands.

rweisssieker-xp Skill

Use when Power BI work must understand enterprise software source products beyond ERP/CRM, including EPM, treasury, tax, ESG, QM/QMS, EHS, commerce, subscription billing, field service, procurement, logistics, WHS/WMS, data governance, ETL, observability, ECM, OCR, RPA, and identity platforms.

rweisssieker-xp Skill

Use when Power BI sources include procurement suites, sourcing, supplier risk, spend analytics, Coupa, Ivalua, Jaggaer, SAP Ariba, GEP, Scoutbee, Riskmethods, Sphera Supply Chain Risk, or supplier portals.

knuckles-team Bundle

Use this skill whenever the user wants to read, edit, analyze, or create document files. This includes PDFs (reading, merging, splitting, OCR, forms, watermarks), Spreadsheets (.xlsx, .csv, DataFrames, formulas with zero errors), Word Documents (.docx), PowerPoint Presentations (.pptx), and Markdown to EPUB conversion. Treat this as the primary tool for any standard office file or document formatting/extraction task.

knuckles-team Bundle

Produce a read-only structural and statistical profile of CSV, TSV, JSON, or JSON Lines data without emitting raw field values. Use when onboarding an unknown dataset, checking its shape, measuring nulls and cardinality, inferring column types, or creating evidence for downstream quality rules. Do not use to modify, clean, validate against business rules, or upload the dataset.

kienbui1995 Skill

Use when designing analytics schemas, choosing between star schema and OBT, or modeling entities for a data warehouse

kienbui1995 Skill

Morning analytics briefing covering the last 1-2 days — surfaces anomalies, trends, risks, and wins. Uses mcp__Amplitude__query_amplitude_data, mcp__Amplitude__get_charts, mcp__Amplitude__get_context.

kienbui1995 Skill

Transform code diffs (PRs, branches, files) into structured YAML briefs for analytics instrumentation planning. Minimal MCP usage — primarily code analysis.

team-telnyx Skill

Generate and retrieve usage reports for billing, analytics, and reconciliation. This skill provides JavaScript SDK examples.