skills.rest
apconw
apconwCOMMUNITY
Explore all skills by this author →
GitHub

report-generation

Generate end-to-end HTML data analysis reports with charts and tables.

2.2k|428|Updated Nov 15, 2024
Search Tags:#SQL#data-analysis#data-visualization#report-generation#HTML-report#business-intelligence
One-click install
npx skills add https://github.com/apconw/Aix-DB --skill report-generation
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: report-generation
Source: https://github.com/apconw/Aix-DB/tree/main/agent/deepagent/skills/report-generation
Command: npx skills add https://github.com/apconw/Aix-DB --skill report-generation

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) and assets (resource) components.

What problem does it solve?

当需要把原始数据分析需求转化为完整的报告时，手动整理查询、聚合与可视化图表耗时且易出错。本 Skill 提供端到端的报告生成能力，自动完成数据提取、分析与可视化整合。

Core Features & Use Cases

  • 自动化数据查询与分析：从多个数据源提取、聚合并计算关键 KPI。
  • 可视化报告：生成多种图表并嵌入到独立的 HTML 报告中，支持交互。
  • 灵活输出：提供可下载的 HTML 报告，以及可在对话中直接展示的可预览内容。
  • Use Case：企业销售季度分析、运营指标监控、市场研究报告等场景。

Quick Start

使用报告生成技能提交需求，例如“生成2024年Q1的销售分析报告，包含地区分布柱状图和总览 KPI，输出一个可预览的 HTML 报告”。

Frequently Asked Questions about report-generation

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I generate an HTML report from SQL data analysis?▼

To generate an HTML report from SQL data analysis, you provide a natural language request specifying the metrics and visualizations needed. The system orchestrates deterministic SQL queries for data extraction and aggregation, then renders charts via CDN libraries to produce a polished, interactive HTML report.

What is the best way to automate business intelligence reporting with data visualization?▼

Automating business intelligence reporting is achieved by submitting data analysis requests to generate end-to-end outputs. It automatically extracts data, calculates KPIs, and embeds interactive data visualization charts into a standalone HTML report without writing to local storage.

Can I create interactive charts and tables for a sales performance dashboard?▼

Yes, you can create interactive charts and tables for a sales performance dashboard. The report generation process supports rendering various chart types via CDN libraries and embedding them alongside KPI tables directly into a previewable HTML document.

Does report generation work with deterministic SQL queries for data extraction?▼

Report generation works directly with deterministic SQL queries to ensure accurate data extraction and aggregation. This approach guarantees that the data populating your interactive charts and HTML reports is consistently retrieved without manual query writing.

Do I need to save files to local storage to preview data analysis reports?▼

You do not need to save files to local storage to preview data analysis reports. The generated HTML reports can be displayed directly within the conversation interface, providing immediate previewable content alongside downloadable output options.

What types of use cases are supported for HTML report generation?▼

HTML report generation supports use cases like enterprise sales quarterly analysis, operations metric monitoring, and market research. It transforms raw data extraction and aggregation into polished reports featuring interactive charts and overview KPI tables.

Related Skills

Explore More Data & Analytics Skills→
AstorYHAstorYH
15

postgresql-query-runner

Execute PostgreSQL SQL queries against specified database connections.

Community
Intermediate
weirdgmeweirdgme
4

platform-engineering

Design and implement scalable platform engineering patterns for internal developer platforms.

Community
Advanced
AltinityAltinity
16

altinity-expert-clickhouse-overview

Aggregate ClickHouse health data by executing predefined SQL system queries.

Official
Intermediate
Mohamed-ElkahefMohamed-Elkahef

dashboard-creation

Build interactive analytics dashboards with Chart.js for business metrics and KPIs.

Community
Advanced