executive-dashboard
Compare original and translation side by side
🇺🇸
Original
English🇨🇳
Translation
ChineseExecutive Dashboard
管理层仪表盘
Metadata
元数据
- Name: executive-dashboard
- Description: KPI framework for executive performance monitoring
- Triggers: dashboard, KPI, performance metrics, executive reporting, scorecard
- 名称: executive-dashboard
- 描述: 用于管理层绩效监控的KPI框架
- 触发词: 仪表盘、KPI、绩效指标、管理层报告、计分卡
Instructions
说明
You are designing an executive dashboard for $ARGUMENTS.
Create a KPI framework that provides visibility into critical business drivers.
你正在为$ARGUMENTS设计一款管理层仪表盘。
创建一个KPI框架，清晰呈现关键业务驱动因素。
Framework
框架
Dashboard Design Principles
仪表盘设计原则
- Strategic Alignment - KPIs tied to strategic objectives
- Leading + Lagging - Mix of predictive and outcome measures
- Actionable - Each KPI has an owner who can act
- Limited - 5-10 KPIs maximum per view
- Drill-down - Can explore details when needed
- Real-time or Near Real-time - Timely enough to act
- 战略对齐 - KPI与战略目标绑定
- 领先指标+滞后指标 - 结合预测性指标和结果性指标
- 可执行 - 每个KPI都有对应的负责人可以采取行动
- 精简 - 每个视图最多包含5-10个KPI
- 可下钻 - 必要时可查看详细数据
- 实时或准实时 - 数据及时，支持快速行动
KPI Categories
KPI类别
| Category | Purpose | Examples |
|---|---|---|
| Financial | Profitability & health | Revenue, margin, cash flow |
| Customer | Market position | NPS, retention, share |
| Operational | Efficiency & quality | Cycle time, quality, utilization |
| People | Human capital | Engagement, turnover, productivity |
| Growth | Future performance | Pipeline, innovation, launches |
| 类别 | 用途 | 示例 |
|---|---|---|
| 财务类 | 盈利能力与健康度 | 营收、利润率、现金流 |
| 客户类 | 市场地位 | NPS、客户留存率、市场份额 |
| 运营类 | 效率与质量 | 周期时间、质量、资源利用率 |
| 人力类 | 人力资本 | 员工敬业度、离职率、生产力 |
| 增长类 | 未来绩效 | 销售漏斗、创新、产品发布 |
Leading vs. Lagging Indicators
领先指标vs滞后指标
| Type | Definition | Example |
|---|---|---|
| Leading | Predicts future performance | Pipeline, bookings, web traffic |
| Lagging | Measures past performance | Revenue, profit, market share |
| Coincident | Current state indicator | Backlog, inventory, headcount |
| 类型 | 定义 | 示例 |
|---|---|---|
| 领先指标 | 预测未来绩效 | 销售漏斗、预订量、网站流量 |
| 滞后指标 | 衡量过往绩效 | 营收、利润、市场份额 |
| 同步指标 | 当前状态指标 | 未完成订单、库存、员工人数 |
Traffic Light System
红绿灯系统
- 🟢 Green = On track (within tolerance)
- 🟡 Yellow = At risk (outside tolerance, needs attention)
- 🔴 Red = Off track (significant deviation, action required)
- 🟢 绿色 = 正常（在公差范围内）
- 🟡 黄色 = 风险预警（超出公差范围，需关注）
- 🔴 红色 = 偏离轨道（严重偏差，需立即采取行动）
Output Format
输出格式
undefinedundefinedExecutive Dashboard: [Business/Function]
Executive Dashboard: [Business/Function]
Dashboard Purpose
Dashboard Purpose
Business Unit/Function: [Name]
Dashboard Owner: [Executive]
Update Frequency: [Daily/Weekly/Monthly]
Primary Audience: [Who uses this]
Key Decisions Supported: [What decisions does this inform]
Business Unit/Function: [Name]
Dashboard Owner: [Executive]
Update Frequency: [Daily/Weekly/Monthly]
Primary Audience: [Who uses this]
Key Decisions Supported: [What decisions does this inform]
Dashboard Overview
Dashboard Overview
┌─────────────────────────────────────────────────────────────────┐
│ EXECUTIVE DASHBOARD │
│ [Business Unit] │
│ As of: [Date] │
├─────────────────────────────────────────────────────────────────┤
│ │
│ REVENUE MARGIN CUSTOMER OPERATIONS │
│ $50.2M 22.5% NPS: 72 98.2% SLA │
│ 🟢 +8% YoY 🟡 -1pt YoY 🟢 +5pts 🟢 +0.5pt │
│ │
├─────────────────────────────────────────────────────────────────┤
│ │
│ CRITICAL METRICS │
│ ┌──────────────┬──────────────┬──────────────┬──────────────┐ │
│ │ ARR: $45M │ Churn: 5.2% │ CAC: $2.1K │ LTV: $15K │ │
│ │ 🟢 +12% │ 🟡 +0.5pt │ 🟢 -10% │ 🟢 +20% │ │
│ └──────────────┴──────────────┴──────────────┴──────────────┘ │
│ │
│ 🟢 6 Green │ 🟡 3 Yellow │ 🔴 1 Red │
│ │
└─────────────────────────────────────────────────────────────────┘┌─────────────────────────────────────────────────────────────────┐
│ EXECUTIVE DASHBOARD │
│ [Business Unit] │
│ As of: [Date] │
├─────────────────────────────────────────────────────────────────┤
│ │
│ REVENUE MARGIN CUSTOMER OPERATIONS │
│ $50.2M 22.5% NPS: 72 98.2% SLA │
│ 🟢 +8% YoY 🟡 -1pt YoY 🟢 +5pts 🟢 +0.5pt │
│ │
├─────────────────────────────────────────────────────────────────┤
│ │
│ CRITICAL METRICS │
│ ┌──────────────┬──────────────┬──────────────┬──────────────┐ │
│ │ ARR: $45M │ Churn: 5.2% │ CAC: $2.1K │ LTV: $15K │ │
│ │ 🟢 +12% │ 🟡 +0.5pt │ 🟢 -10% │ 🟢 +20% │ │
│ └──────────────┴──────────────┴──────────────┴──────────────┘ │
│ │
│ 🟢 6 Green │ 🟡 3 Yellow │ 🔴 1 Red │
│ │
└─────────────────────────────────────────────────────────────────┘KPI Definitions
KPI Definitions
Financial KPIs
Financial KPIs
| KPI | Definition | Target | Current | Status | Trend |
|---|---|---|---|---|---|
| Revenue | Total revenue (monthly) | $50M | $50.2M | 🟢 | ↑ |
| Gross Margin | (Revenue - COGS) / Revenue | 65% | 63% | 🟡 | → |
| Operating Margin | Operating income / Revenue | 25% | 22.5% | 🟡 | ↓ |
| Free Cash Flow | Cash from operations - CapEx | $10M | $12M | 🟢 | ↑ |
| ARR | Annual recurring revenue | $40M | $45M | 🟢 | ↑ |
| KPI | Definition | Target | Current | Status | Trend |
|---|---|---|---|---|---|
| Revenue | Total revenue (monthly) | $50M | $50.2M | 🟢 | ↑ |
| Gross Margin | (Revenue - COGS) / Revenue | 65% | 63% | 🟡 | → |
| Operating Margin | Operating income / Revenue | 25% | 22.5% | 🟡 | ↓ |
| Free Cash Flow | Cash from operations - CapEx | $10M | $12M | 🟢 | ↑ |
| ARR | Annual recurring revenue | $40M | $45M | 🟢 | ↑ |
Customer KPIs
Customer KPIs
| KPI | Definition | Target | Current | Status | Trend |
|---|---|---|---|---|---|
| NPS | Net Promoter Score | 70 | 72 | 🟢 | ↑ |
| Customer Retention | % retained customers | 95% | 94.8% | 🟡 | → |
| Churn Rate | % customers lost (annual) | <5% | 5.2% | 🟡 | ↑ |
| Market Share | % of market | 25% | 23% | 🟡 | → |
| CAC | Customer acquisition cost | <$2.5K | $2.1K | 🟢 | ↓ |
| KPI | Definition | Target | Current | Status | Trend |
|---|---|---|---|---|---|
| NPS | Net Promoter Score | 70 | 72 | 🟢 | ↑ |
| Customer Retention | % retained customers | 95% | 94.8% | 🟡 | → |
| Churn Rate | % customers lost (annual) | <5% | 5.2% | 🟡 | ↑ |
| Market Share | % of market | 25% | 23% | 🟡 | → |
| CAC | Customer acquisition cost | <$2.5K | $2.1K | 🟢 | ↓ |
Operational KPIs
Operational KPIs
| KPI | Definition | Target | Current | Status | Trend |
|---|---|---|---|---|---|
| SLA Achievement | % of SLAs met | 99% | 98.2% | 🟢 | ↑ |
| Cycle Time | Avg. time to complete | <5 days | 4.8 days | 🟢 | ↓ |
| Quality Score | Defect-free rate | 99.5% | 99.1% | 🟡 | → |
| Utilization | Resource utilization | 85% | 82% | 🟡 | ↓ |
| KPI | Definition | Target | Current | Status | Trend |
|---|---|---|---|---|---|
| SLA Achievement | % of SLAs met | 99% | 98.2% | 🟢 | ↑ |
| Cycle Time | Avg. time to complete | <5 days | 4.8 days | 🟢 | ↓ |
| Quality Score | Defect-free rate | 99.5% | 99.1% | 🟡 | → |
| Utilization | Resource utilization | 85% | 82% | 🟡 | ↓ |
People KPIs
People KPIs
| KPI | Definition | Target | Current | Status | Trend |
|---|---|---|---|---|---|
| Engagement Score | Employee engagement | 80 | 78 | 🟡 | → |
| Voluntary Turnover | % leaving voluntarily | <10% | 8.5% | 🟢 | ↓ |
| Productivity | Revenue per employee | $300K | $315K | 🟢 | ↑ |
| KPI | Definition | Target | Current | Status | Trend |
|---|---|---|---|---|---|
| Engagement Score | Employee engagement | 80 | 78 | 🟡 | → |
| Voluntary Turnover | % leaving voluntarily | <10% | 8.5% | 🟢 | ↓ |
| Productivity | Revenue per employee | $300K | $315K | 🟢 | ↑ |
Growth KPIs
Growth KPIs
| KPI | Definition | Target | Current | Status | Trend |
|---|---|---|---|---|---|
| Pipeline Value | Weighted pipeline | $100M | $85M | 🔴 | ↓ |
| Win Rate | % of deals won | 35% | 38% | 🟢 | ↑ |
| New Product Revenue | % from products <2yr old | 20% | 18% | 🟡 | → |
| KPI | Definition | Target | Current | Status | Trend |
|---|---|---|---|---|---|
| Pipeline Value | Weighted pipeline | $100M | $85M | 🔴 | ↓ |
| Win Rate | % of deals won | 35% | 38% | 🟢 | ↑ |
| New Product Revenue | % from products <2yr old | 20% | 18% | 🟡 | → |
Trend Visualization
Trend Visualization
Revenue (12-month rolling)
$60M ┤
│ ╭───●
$55M ┤ ╭────────╯
│ ╭──────╯
$50M ┤ ╭─────────╯
│ ╭───────╯
$45M ┤──────╯
│
$40M ┤
└───┬───┬───┬───┬───┬───┬───┬───┬───┬───┬───┬───┬───
J F M A M J J A S O N DNPS Trend
80 ┤ ╭───────●
│ ╭───────╯
75 ┤ ╭───────╯
│────╯
70 ┤
│
65 ┤
└───┬───┬───┬───┬───┬───┬───┬───┬───┬───┬───┬───┬───
J F M A M J J A S O N D营收（12个月滚动）
$60M ┤
│ ╭───●
$55M ┤ ╭────────╯
│ ╭──────╯
$50M ┤ ╭─────────╯
│ ╭───────╯
$45M ┤──────╯
│
$40M ┤
└───┬───┬───┬───┬───┬───┬───┬───┬───┬───┬───┬───┬───
J F M A M J J A S O N DNPS趋势
80 ┤ ╭───────●
│ ╭───────╯
75 ┤ ╭───────╯
│────╯
70 ┤
│
65 ┤
└───┬───┬───┬───┬───┬───┬───┬───┬───┬───┬───┬───┬───
J F M A M J J A S O N DAlerts & Exceptions
警报与异常
| Alert | Metric | Condition | Current | Action Required |
|---|---|---|---|---|
| 🔴 CRITICAL | Pipeline | <$90M | $85M | Sales push needed |
| 🟡 WARNING | Gross Margin | <64% | 63% | Cost review |
| 🟡 WARNING | Churn | >5% | 5.2% | Retention campaign |
| 警报 | 指标 | 触发条件 | 当前值 | 需采取的行动 |
|---|---|---|---|---|
| 🔴 严重警报 | 销售漏斗 | <$90M | $85M | 需要推动销售 |
| 🟡 预警 | 毛利率 | <64% | 63% | 成本审查 |
| 🟡 预警 | 客户流失率 | >5% | 5.2% | 客户留存活动 |
KPI Drill-Down
KPI下钻
🔴 Pipeline Detail
🔴 销售漏斗详情
By Stage:
| Stage | Value | # Deals | Avg Size | Conversion |
|---|---|---|---|---|
| Qualification | $20M | 40 | $500K | 20% |
| Discovery | $25M | 25 | $1M | 35% |
| Proposal | $25M | 15 | $1.7M | 50% |
| Negotiation | $15M | 8 | $1.9M | 70% |
By Region:
| Region | Pipeline | Target | Gap |
|---|---|---|---|
| North America | $40M | $50M | -$10M |
| EMEA | $25M | $25M | ✅ |
| APAC | $20M | $25M | -$5M |
Root Cause: [Analysis of why pipeline is low]
Action Items:
- [Action 1] - Owner: [Name] - Due: [Date]
- [Action 2] - Owner: [Name] - Due: [Date]
按阶段划分：
| 阶段 | 金额 | 交易数量 | 平均规模 | 转化率 |
|---|---|---|---|---|
| 资格审核 | $20M | 40 | $500K | 20% |
| 需求探索 | $25M | 25 | $1M | 35% |
| 提案 | $25M | 15 | $1.7M | 50% |
| 谈判 | $15M | 8 | $1.9M | 70% |
按区域划分：
| 区域 | 销售漏斗金额 | 目标 | 差距 |
|---|---|---|---|
| 北美 | $40M | $50M | -$10M |
| 欧洲、中东和非洲 | $25M | $25M | ✅ |
| 亚太 | $20M | $25M | -$5M |
根本原因： [分析销售漏斗金额偏低的原因]
行动项：
- [行动1] - 负责人：[姓名] - 截止日期：[日期]
- [行动2] - 负责人：[姓名] - 截止日期：[日期]
Period Comparison
周期对比
| Metric | This Period | Last Period | YoY Change | Target |
|---|---|---|---|---|
| Revenue | $50.2M | $48.5M | +8% ✅ | $50M |
| Margin | 22.5% | 23.1% | -1pt ⚠️ | 25% |
| NPS | 72 | 70 | +5pts ✅ | 70 |
| Pipeline | $85M | $95M | -15% ⚠️ | $100M |
| Headcount | 159 | 155 | +10% ✅ | 165 |
| 指标 | 本期 | 上期 | 同比变化 | 目标 |
|---|---|---|---|---|
| 营收 | $50.2M | $48.5M | +8% ✅ | $50M |
| 利润率 | 22.5% | 23.1% | -1pt ⚠️ | 25% |
| NPS | 72 | 70 | +5pts ✅ | 70 |
| 销售漏斗 | $85M | $95M | -15% ⚠️ | $100M |
| 员工人数 | 159 | 155 | +10% ✅ | 165 |
Management Actions
管理层行动
Decisions Required:
- Pipeline shortfall - Approve sales incentive program
- Margin pressure - Authorize cost reduction initiative
- Hiring plan - Confirm Q1 headcount targets
Recent Actions Taken:
| Action | Date | Owner | Status |
|---|---|---|---|
| Price increase | Jan 15 | CFO | ✅ Complete |
| Sales training | Jan 20 | CRO | 🔄 In progress |
| Cost audit | Jan 25 | COO | 🔄 In progress |
需做出的决策：
- 销售漏斗缺口 - 批准销售激励计划
- 利润率压力 - 授权成本削减举措
- 招聘计划 - 确认Q1员工人数目标
近期已采取的行动：
| 行动 | 日期 | 负责人 | 状态 |
|---|---|---|---|
| 提价 | 1月15日 | CFO | ✅ 已完成 |
| 销售培训 | 1月20日 | CRO | 🔄 进行中 |
| 成本审计 | 1月25日 | COO | 🔄 进行中 |
Dashboard Governance
仪表盘管理规则
Update Schedule:
- Data refresh: Daily at 6:00 AM
- Dashboard update: Daily by 8:00 AM
- Review meeting: Weekly Monday 9:00 AM
Data Sources:
- Financial: [ERP System]
- Customer: [CRM System]
- Operational: [Operations Dashboard]
- People: [HRIS System]
Accountability:
- Dashboard Owner: [Name]
- Data Steward: [Name]
- Review Forum: [Meeting]
Escalation Path:
- 🟡 Yellow > 2 weeks → Function head
- 🔴 Red > 1 week → Executive team
undefined更新计划：
- 数据刷新：每日6:00 AM
- 仪表盘更新：每日8:00 AM前完成
- 评审会议：每周一9:00 AM
数据源：
- 财务：[ERP系统]
- 客户：[CRM系统]
- 运营：[运营仪表盘]
- 人力：[HRIS系统]
责任划分：
- 仪表盘负责人：[姓名]
- 数据管理员：[姓名]
- 评审会议：[会议名称]
升级路径：
- 🟡 黄色状态持续>2周 → 职能部门负责人
- 🔴 红色状态持续>1周 → 高管团队
undefinedTips
小贴士
- Less is more - only critical KPIs
- Each KPI should have an owner
- Mix leading and lagging indicators
- Make it visual - trends, not just numbers
- Exception-based reporting - focus on what's off track
- Can you act on this? If not, why track it?
- Review and refresh KPIs quarterly
- The dashboard should tell a story
- 少即是多 - 只保留关键KPI
- 每个KPI都要有负责人
- 结合领先指标和滞后指标
- 可视化呈现 - 展示趋势，而非仅数字
- 异常报告 - 聚焦偏离轨道的指标
- 该指标是否可执行？如果不能，为什么要跟踪它？
- 每季度评审和更新KPI
- 仪表盘应能讲述业务故事
References
参考资料
- Kaplan, Robert & Norton, David. The Balanced Scorecard. 1996.
- Few, Stephen. Information Dashboard Design. 2006.
- Parmenter, David. Key Performance Indicators. 2015.
- 罗伯特·卡普兰 & 戴维·诺顿. 《平衡计分卡》. 1996年.
- 斯蒂芬·菲奥. 《信息仪表盘设计》. 2006年.
- 戴维·帕门特. 《关键绩效指标》. 2015年.