Data Visualization Report Builder
Paste the following prompt into your AI chat to install this skill:
Follow https://skillhub.cn/install/skillhub.md to install @user_01168fee/data-visualization in your AI assistant.
About this skill
Problem addressed
Structured statistics and narrative reports often live in separate files: Excel contains frequency, trend, or cross-tabulation results, while Markdown or Word files contain findings and recommendations. Manually assembling those pieces into a presentation-ready report is repetitive and hard to keep visually consistent. This skill converts such inputs into a single-file HTML report that can be opened directly in a browser.
How it works and limits
The skill first detects input types such as .xlsx, .md, and .docx, then extracts a _data_extract.json file. For Excel, it captures sheets, row counts, samples, numeric summaries, and categorical previews. For text documents, it captures section structure, key numbers, and important passages. It then plans fixed sections such as Hero, KPI cards, and footer, and chooses chart forms based on data shape: ECharts, Chart.js, or plain CSS. Frequency data may map to bar or pie charts, date series to line charts, and cross-tabulations to grouped bars.
During HTML generation, CSS and JS are inlined, data is embedded directly, charts resize with their containers, and users can export individual PNG charts or bundle all charts. Finally, CDN-referenced chart libraries are replaced with local assets so the report works offline. It is best suited to clear statistical results or structured reports; if the input is mostly raw bulk data, it is more useful for extracting totals and date ranges than for replacing full data analysis.
Use Cases
- Turn an Excel workbook with frequency, trend, and cross-tabulation tables into an HTML report with KPIs and charts.
- Combine a Markdown analysis and Excel data into a single-file page with summaries and chart support.
- Consolidate multiple statistical Excel files into an offline visualization report and export chart PNGs.
- Convert a Word report's sections, key numbers, and conclusions into a dashboard with numbered navigation.
Best For
- Data analysts who need to turn Excel statistics into a presentation-ready report
- Operations analysts who need to extract key numbers from Markdown reports and add charts
- Business analysts who need to merge multiple statistical tables into an offline report
- Consultants who need to deliver KPIs, findings, and charts to management
Related Skills
Reads Excel/CSV files, cleans and analyzes them, then generates a charted Excel summary and interactive HTML dashboard.
Performs local, paragraph-level cross-document similarity checks and produces an HTML report with revision suggestions.
Scrapes JD search results for product titles, prices, sales, and stores, then exports verified data to UTF-8 CSV.
An A-share market monitor using Sina Finance API for real-time quotes, price and percentage alerts, daily logging, and scheduled checks.