Analytics Documentation Generator
Auto-generate data dictionaries, lineage maps, and transformation docs from your analytics stack
What You Can Do
This skill automatically documents your entire analytics infrastructure by analyzing data sources, transformations, and outputs. You'll generate production-ready data dictionaries with field definitions, lineage maps showing data flow across systems, and transformation documentation that explains logic and dependencies. Save weeks of manual documentation work while keeping your analytics stack discoverable as it evolves.
Features
automatically catalog all tables, fields, data types, and business definitions from your warehouse
trace data flow from source systems through transformations to final analytics outputs
auto-generate docs explaining ETL logic, filters, aggregations, and dependencies
capture field descriptions, constraints, quality rules, and ownership
identify downstream dependencies when source schemas or transformations change
generate version-control-friendly documentation that lives alongside your code
pre-built connectors for Snowflake, BigQuery, Redshift, dbt, and Fivetran
automatically organize and cross-reference business term definitions across your stack
Example Output
Example Data Dictionary Entry
Table: customers_fact
Owner: Analytics Team
Updated: 2026-07-30
| Column | Type | Description | Business Definition |
|---|---|---|---|
| customer_id | INT | Unique customer identifier (PK) | Stable identifier for each customer |
| VARCHAR | Customer email address | Primary communication channel | |
| lifetime_value | DECIMAL(12,2) | Total customer spend (USD) | Sum of all successful transactions |
Example Lineage Map
salesforce_accounts → Fivetran → raw_salesforce → dbt models →
dim_accounts → Revenue Dashboard
↓
fact_opportunities → Sales Pipeline Report
Example Transformation Doc
Transformation: stg_orders__deduplicated
- Source:
raw_orderstable - Logic: Deduplicates orders by order_id, keeping latest updated_at timestamp
- Dependencies: Runs after
raw_ordersis refreshed, upstream offct_orders - Last updated: 2026-07-15
- Owner: analytics@company.com
What's Included
- SKILL.md: Complete analytics documentation generation workflow with decision trees
- Data Dictionary Template: Structured markdown template for table and column documentation
- Lineage Map Template: Mermaid-formatted data flow diagrams
- Transformation Documentation Template: ETL logic and dependency tracking
- Column Metadata Extraction Checklist: Step-by-step field cataloging guide
- Platform Integration Guide: Connection setup for Snowflake, BigQuery, Redshift, dbt Cloud, and Fivetran
- Schema Change Impact Analysis Workflow: Identify affected downstream transforms
- Business Glossary Builder: Automated term extraction and cross-reference guide
- Documentation Audit Checklist: Quality assurance for generated docs
Who It's For
- Data Engineers building and maintaining ETL pipelines across multiple source systems
- Analytics Engineers documenting dbt transformations and maintaining semantic layers
- Data Analysts onboarding to new analytics environments or inheriting legacy systems
- Data Governance Managers building metadata catalogs and compliance frameworks
- Business Intelligence Developers creating self-service analytics platforms and BI portals
Best For
- Documenting legacy analytics systems with missing or outdated metadata
- Creating data dictionaries for compliance (HIPAA, GDPR, SOX audits)
- Onboarding new team members to your analytics stack quickly
- Building data governance and cataloging frameworks from scratch
- Tracking schema changes and impact analysis across your entire data platform
You might also like
You'll systematically diagnose data quality problems by developing structured root cause analysis frameworks, calculating the true business impact, and creating reproducible validation tests. This skill walks you through hypothesis-driven investigation, data lineage analysis, and remediation planning — turning data issues into documented fixes and preventive measures.
by moonwell-fi
You can systematically evaluate and improve your RAG pipelines using Claude as a design partner. You'll analyze retrieval quality, identify bottlenecks in your embedding and chunking strategies, and receive actionable recommendations to reduce hallucinations and improve context relevance. By the end, you'll have a data-driven optimization plan tailored to your specific use case and performance metrics.
by moonwell-fi
You'll build comprehensive data quality test suites that validate transformations, detect anomalies, and document standards across your dbt and SQL pipelines. This skill generates production-ready test configurations, anomaly detection protocols, and validation rules that catch data issues before they impact analytics.
by moonwell-fi
You can convert complex datasets and business metrics into polished, executive-ready reports that stakeholders trust and act on. Claude generates data-driven narratives, executive summaries, actionable insights, and visualization recommendations tailored to your audience's priorities. Your reports will tell a cohesive story that connects metrics to business outcomes, eliminating confusion and accelerating decision-making.
by moonwell-fi
You can rapidly compile, organize, and format disparate health economic evidence—from clinical trials to cost-effectiveness analyses—into structured, regulatory-compliant dossiers. This skill maps your evidence to specific payer and HTA requirements, automatically generates evidence hierarchies, and produces submission-ready dossier outlines with formatting that meets regulatory standards for NICE, EUnetHTA, and other major bodies.
by moonwell-fi
You can structure comprehensive health technology assessments (HTAs) that organize clinical evidence, economic analyses, and regulatory considerations into evidence-based coverage recommendations. This skill helps you synthesize clinical trial data, health economic models, and real-world evidence into clear, defensible payer coverage determinations. You'll generate professional HTA reports that align with major frameworks like ICER, CADTH, and NICE standards.
by moonwell-fi
This skill detects your project framework (Vite, Next.js, plain Node, or monorepo) and automatically configures agent-tail to pipe dev server and browser console logs into unified log files. You'll get a proposed configuration tailored to your setup, install agent-tail with the correct plugins, and have logs immediately available for AI agents to consume and analyze.
by moonwell-fi
You can build production-grade vector search systems that retrieve semantically similar documents in sub-millisecond time using AgentDB's optimized HNSW indexing. The skill enables you to implement RAG pipelines, semantic search engines, and intelligent knowledge bases with configurable embedding dimensions, distance metrics (cosine, Euclidean, dot product), and similarity thresholds—all with built-in quantization and caching for massive performance gains.
by moonwell-fi