经营分析看板

Overview

本技能基于上市水务/公用事业公司的公开财务数据（年报、交易所披露），生成专业、可公开发布的经营分析看板。看板覆盖营收趋势、业务结构、季度分析、核心财务指标、运营数据、现金流、资产负债结构与股东回报，全部用 ECharts 可视化呈现。所有数据均来自公开渠道，已做脱敏处理，适合直接发布到公开平台。

When to Use（何时启用）

当用户提出以下任一类需求时，应主动加载本技能：

直接触发词（用户原话出现即可启用）：

"做一份水务公司/供水公司的经营分析看板"
"把某上市公司年报做成可视化看板"
"生成经营分析看板" / "生成财务看板"
"把内部看板脱敏，换成公开数据发布"
"可视化上市公司财务数据" / "上市公司年报可视化"

语义触发（出现以下组合时启用）：

提及"水务""供水""污水处理""公用事业" + "看板""dashboard""经营分析""财务可视化"
提及某家水务上市公司（如重庆水务、兴蓉环境）+ 财务/年报/指标分析
需要把含敏感信息的内部报表改写为可对外展示的版本

快速上手（示例指令）

用户安装后，可直接用自然语言或 /经营分析看板 调用。常用指令示例：

做一份重庆水务的经营分析看板 —— 自动搜集 601158.SH 近三年年报数据并生成 HTML 看板
把这份内部看板脱敏，换成上市公司公开数据后发布 —— 读取已有看板，移除敏感信息，替换为公开数据
生成某水务公司 2022—2025 年营收利润现金流可视化看板 —— 指定公司与年份区间

提示：技能内置完整 HTML 模板（14 个 ECharts 图表），只需替换数据数组即可适配任意上市水务公司。

Workflow

Step 1: Identify the Target Company and Collect Public Data

Search for the target water utility company's public financial data. Key sources:

Stock exchange filings (SSE/SZSE/HKEX): Annual reports, quarterly reports
Financial news aggregators: Sina Finance, Sohu Finance, CNStock, STCN
Financial data platforms: Tencent Finance (gu.qq.com), Eastmoney

Collect the following data categories (minimum 3 years for trend analysis):

| Category | Key Metrics | |----------|------------| | Revenue & Profit | 营业收入, 归母净利润, 扣非净利润, 毛利率, 净利率 | | Cash Flow | 经营/投资/筹资活动现金流净额, 销售现金比率, 净利润现金含量 | | Balance Sheet | 总资产, 总负债, 净资产, 资产负债率, 流动比率, 速动比率 | | Profitability | ROE, ROA, EPS, 每股净资产 | | Business Segments | By product/service line (供水, 污水处理, 污泥处置, etc.) | | Quarterly | Q1-Q4 revenue, profit, cash flow, gross margin | | Operational | Water volume (处理水量, 售水量), capacity, employee count | | Shareholder | Dividend per share, payout ratio, P/E, P/B |

Step 2: Desensitize (If Starting from an Internal Dashboard)

If adapting an existing internal dashboard:

Remove all internal company names, subsidiary names
Remove all internal file paths (e.g., E:\供水\...)
Remove all budget data, internal cost breakdowns, personnel details
Remove all internal management commentary and risk assessments
Replace all financial data with public company data from Step 1
Update the header, metadata, and data source citations

Step 3: Generate the HTML Dashboard

Use the template at assets/dashboard-template.html as the structural reference. The dashboard follows this design system:

Visual Design:

Light theme: white cards on #f2f5f9 background
Brand colors: deep blue #123f6d / #1c5c9c
Warning semantics: red #c0392b (risk/down), yellow #b9770e (watch), green #1a7a4c (improvement)
Font: system sans-serif (PingFang SC / Microsoft YaHei)
Max width: 1180px, responsive grid

ECharts Configuration:

CDN: https://cdn.jsdelivr.net/npm/echarts@5.5.0/dist/echarts.min.js
All charts use echarts.init(document.getElementById('chartN')).setOption({...})
Responsive: window.addEventListener('resize', ...) for all chart instances
Color palette: #1c5c9c (brand), #c0392b (warn), #1a7a4c (ok), #b9770e (mid), #6b7c90 (muted)

Dashboard Structure (9 sections):

Header — Company name, stock code, exchange, data period
Executive Summary — 4 KPI cards + bullet-point conclusions
Multi-Year Trends — Revenue/profit bar+line, profitability ratios line, cash flow bar, summary table
Business Segments — Pie chart (current year), grouped bar (year-over-year comparison), detail table
Quarterly Analysis — Revenue/profit bar+line, cash flow bar, gross margin line, detail table
Key Financial Metrics — KPI grid (profitability, solvency, efficiency, growth — 4 categories)
Operational Metrics — Water volume trends bar, capacity & efficiency table
Cash Flow — Three-activity bar, quality indicators table
Balance Sheet — Assets/liabilities/equity bar, debt ratio line, major item changes table

Additional Sections:

Shareholder Returns — EPS + dividend bar+line, payout ratio bar, valuation table
Risk Watch — 6 risk cards (2-column grid, color-coded left border)
Data Source — Links to annual reports, disclaimer

Step 4: Publish to WorkBuddy Platform (Optional)

If the user wants to publish the dashboard:

Import to Library: Use the library skill's import_html.py to import the HTML as a page node
Publish: Use publish_page.py to generate a public link (workbuddy.link/p/...)
Deploy as Site (alternative): Use workbuddy_sites_deploy for a standalone web URL

Step 5: Publish to "灵感-数据分析" Category

To publish under the "灵感-数据分析" (Inspiration - Data Analysis) category:

Create a folder named "灵感-数据分析" in the user's personal library space
Import the HTML dashboard under that folder using --parent-id
Publish the page using publish_page.py

Data Verification Checklist

Before finalizing the dashboard, verify:

[ ] All financial figures match the annual report (cross-check 2+ sources)
[ ] Year-over-year growth rates are correctly calculated
[ ] Quarterly data sums to annual totals
[ ] Business segment percentages sum to 100%
[ ] No internal/private data remains (if desensitizing)
[ ] Data source links are included at the bottom
[ ] Disclaimer text is present
[ ] All ECharts render correctly (no empty chart containers)

适配其他水务上市公司

This skill can be adapted for any listed water utility company by:

Searching for the company's stock code and annual report
Collecting the same data categories listed in Step 1
Updating the JavaScript data arrays in the HTML template
Updating the header, conclusions, and risk assessment text
Updating the data source links

常用中国上市水务公司（可直接套用本技能）：

重庆水务 (601158.SH)
兴蓉环境 (000598.SZ)
创业环保 (600874.SH)
洪城环境 (600461.SH)
中山公用 (000685.SZ)
江南水务 (601199.SH)
瀚蓝环境 (600323.SH)
钱江水利 (600283.SH)
绿城水务 (601368.SH)
国祯环保 (300388.SZ)

Resources

assets/

dashboard-template.html — Complete HTML dashboard template with ECharts, based on the Chongqing Water Group (601158.SH) dashboard. Contains all 9 sections, 14 charts, CSS, and JavaScript. Replace the data arrays and text content to adapt for any water utility company.

references/

data-sources-guide.md — Guide on where to find public financial data for Chinese listed water utility companies, including URL patterns and search strategies.

财务分析看板