Communitygithub.com

项目组合仪表盘

多项目组合分析仪表盘,聚合跨项目KPI、跟踪组合健康度、比较绩效,支持高管决策。

项目组合仪表盘 是什么?

该技能(项目组合仪表盘)为AI助手(如Claude Code、Cursor、Codex)提供了一套完整的多项目组合分析框架,特别适用于建筑、工程或类似项目管理场景。它通过定义`ProjectMetrics`、`PortfolioSummary`和`ProjectComparison`等核心数据结构,支持从多个项目收集成本、进度、安全、质量和风险等关键指标。核心类`PortfolioDashboard`实现了项目导入、KPI计算(如CPI、SPI、TRIR)、组合健康度评估、项目对比以及现金需求预测等功能。该技能支持按特定指标(如CPI、SPI)比较项目、识别风险项目(黄/红状态)、保存历史快照用于趋势分析,并生成包含执行摘要和详细指标的文本报告。整体设计旨在为高管提供战略层面的组合可见性,辅助资源分配和决策制定。

兼容平台✓Claude Code~Codex CLI~Cursor
npx skills add https://github.com/majiayu000/claude-skill-registry-data/tree/HEAD/analysis/portfolio-dashboard

在你喜欢的 AI 中提问

打开一个已预加载此 Agent Skill 的新对话。

文档

项目组合仪表盘 是做什么的?

概述

跨多个建筑项目聚合和分析数据,实现项目组合级别的可见性。跟踪KPI,识别趋势,比较项目绩效,并支持战略资源分配决策。

项目组合分析框架

┌─────────────────────────────────────────────────────────────────┐
│                 项目组合仪表盘                                   │
├─────────────────────────────────────────────────────────────────┤
│                                                                  │
│  项目A        项目B        项目C        项目D                    │
│     ↓             ↓            ↓            ↓                   │
│  ┌─────────────────────────────────────────────┐                │
│  │            数据聚合                          │                │
│  │  成本 | 进度 | 安全 | 质量 | 风险            │                │
│  └─────────────────────────────────────────────┘                │
│                         ↓                                        │
│  ┌─────────────────────────────────────────────┐                │
│  │          项目组合KPI                          │                │
│  │  📊 总价值    📈 按进度百分比                  │
│  │  💰 按预算百分比  🛡️ 安全率                   │
│  │  ⚠️ 风险评分    📋 资源利用率                │
│  └─────────────────────────────────────────────┘                │
│                                                                  │
└─────────────────────────────────────────────────────────────────┘

技术实现

from dataclasses import dataclass, field
from typing import List, Dict, Optional, Tuple
from datetime import datetime, timedelta
from enum import Enum
import statistics

class ProjectStatus(Enum):
    PLANNING = "planning"
    ACTIVE = "active"
    ON_HOLD = "on_hold"
    COMPLETE = "complete"
    CANCELLED = "cancelled"

class HealthStatus(Enum):
    GREEN = "green"       # 按计划进行
    YELLOW = "yellow"     # 有风险
    RED = "red"           # 危急
    GREY = "grey"         # 未开始/暂停

@dataclass
class ProjectMetrics:
    project_id: str
    project_name: str
    status: ProjectStatus
    contract_value: float
    percent_complete: float

    # 进度
    planned_start: datetime
    planned_end: datetime
    actual_start: Optional[datetime]
    forecast_end: datetime
    schedule_variance_days: int = 0

    # 成本
    budget: float
    actual_cost: float
    forecast_cost: float
    cost_variance: float = 0.0
    cpi: float = 1.0
    spi: float = 1.0

    # 安全
    recordable_incidents: int = 0
    total_hours: float = 0
    trir: float = 0.0

    # 质量
    defects_open: int = 0
    rework_cost: float = 0.0

    # 风险
    risk_score: float = 0.0
    critical_risks: int = 0

    @property
    def health(self) -> HealthStatus:
        """确定项目的整体健康状态。"""
        if self.status in [ProjectStatus.ON_HOLD, ProjectStatus.CANCELLED]:
            return HealthStatus.GREY

        # 如果明显超出预算或进度,则为危急
        if self.cpi < 0.85 or self.spi < 0.85 or self.critical_risks > 3:
            return HealthStatus.RED

        # 如果中度偏离轨道,则有风险
        if self.cpi < 0.95 or self.spi < 0.95 or self.critical_risks > 0:
            return HealthStatus.YELLOW

        return HealthStatus.GREEN

@dataclass
class PortfolioSummary:
    report_date: datetime
    total_projects: int
    active_projects: int
    total_contract_value: float
    total_budget: float
    total_actual_cost: float
    total_forecast_cost: float

    # 绩效
    avg_cpi: float
    avg_spi: float
    on_budget_pct: float
    on_schedule_pct: float

    # 安全
    portfolio_trir: float
    total_incidents: int

    # 健康状态分布
    green_count: int
    yellow_count: int
    red_count: int

    # 趋势
    cost_trend: str
    schedule_trend: str

@dataclass
class ProjectComparison:
    metric: str
    projects: Dict[str, float]
    avg: float
    best: Tuple[str, float]
    worst: Tuple[str, float]

class PortfolioDashboard:
    """多项目组合分析。"""

    # 健康阈值
    THRESHOLDS = {
        "cpi_warning": 0.95,
        "cpi_critical": 0.85,
        "spi_warning": 0.95,
        "spi_critical": 0.85,
        "trir_warning": 2.0,
        "risk_score_warning": 7.0
    }

    def __init__(self, portfolio_name: str):
        self.portfolio_name = portfolio_name
        self.projects: Dict[str, ProjectMetrics] = {}
        self.snapshots: List[Dict] = []  # 历史数据

    def add_project(self, metrics: ProjectMetrics):
        """在组合中添加或更新项目。"""
        self.projects[metrics.project_id] = metrics

    def import_projects(self, projects_data: List[Dict]) -> int:
        """从数据导入多个项目。"""
        count = 0
        for p in projects_data:
            metrics = ProjectMetrics(
                project_id=p['id'],
                project_name=p['name'],
                status=ProjectStatus(p.get('status', 'active')),
                contract_value=p['contract_value'],
                percent_complete=p.get('percent_complete', 0),
                planned_start=p['planned_start'],
                planned_end=p['planned_end'],
                actual_start=p.get('actual_start'),
                forecast_end=p.get('forecast_end', p['planned_end']),
                budget=p['budget'],
                actual_cost=p.get('actual_cost', 0),
                forecast_cost=p.get('forecast_cost', p['budget']),
                cpi=p.get('cpi', 1.0),
                spi=p.get('spi', 1.0),
                recordable_incidents=p.get('incidents', 0),
                total_hours=p.get('total_hours', 0),
                risk_score=p.get('risk_score', 0),
                critical_risks=p.get('critical_risks', 0)
            )

            # 计算衍生指标
            metrics.cost_variance = metrics.budget - metrics.actual_cost
            metrics.schedule_variance_days = (metrics.planned_end - metrics.forecast_end).days

            if metrics.total_hours > 0:
                metrics.trir = (metrics.recordable_incidents * 200000) / metrics.total_hours

            self.add_project(metrics)
            count += 1

        return count

    def get_active_projects(self) -> List[ProjectMetrics]:
        """获取活跃项目列表。"""
        return [p for p in self.projects.values()
                if p.status == ProjectStatus.ACTIVE]

    def calculate_portfolio_summary(self) -> PortfolioSummary:
        """计算项目组合级别的汇总指标。"""
        active = self.get_active_projects()
        all_projects = list(self.projects.values())

        if not all_projects:
            return None

        # 总计
        total_contract = sum(p.contract_value for p in all_projects)
        total_budget = sum(p.budget for p in all_projects)
        total_actual = sum(p.actual_cost for p in all_projects)
        total_forecast = sum(p.forecast_cost for p in all_projects)

        # 绩效平均值(按预算加权)
        if total_budget > 0:
            avg_cpi = sum(p.cpi * p.budget for p in active) / sum(p.budget for p in active) if active else 1.0
            avg_spi = sum(p.spi * p.budget for p in active) / sum(p.budget for p in active) if active else 1.0
        else:
            avg_cpi = avg_spi = 1.0

        # 按预算/按进度的百分比
        on_budget = len([p for p in active if p.cpi >= 0.95])
        on_schedule = len([p for p in active if p.spi >= 0.95])

        on_budget_pct = (on_budget / len(active) * 100) if active else 100
        on_schedule_pct = (on_schedule / len(active) * 100) if active else 100

        # 安全指标
        total_incidents = sum(p.recordable_incidents for p in all_projects)
        total_hours = sum(p.total_hours for p in all_projects)
        portfolio_trir = (total_incidents * 200000 / total_hours) if total_hours > 0 else 0

        # 健康状态分布
        green = len([p for p in active if p.health == HealthStatus.GREEN])
        yellow = len([p for p in active if p.health == HealthStatus.YELLOW])
        red = len([p for p in active if p.health == HealthStatus.RED])

        # 趋势(与之前的快照比较)
        cost_trend = "stable"
        schedule_trend = "stable"

        if self.snapshots:
            prev = self.snapshots[-1]
            if avg_cpi > prev.get('avg_cpi', 1.0):
                cost_trend = "improving"
            elif avg_cpi < prev.get('avg_cpi', 1.0):
                cost_trend = "declining"

            if avg_spi > prev.get('avg_spi', 1.0):
                schedule_trend = "improving"
            elif avg_spi < prev.get('avg_spi', 1.0):
                schedule_trend = "declining"

        return PortfolioSummary(
            report_date=datetime.now(),
            total_projects=len(all_projects),
            active_projects=len(active),
            total_contract_value=total_contract,
            total_budget=total_budget,
            total_actual_cost=total_actual,
            total_forecast_cost=total_forecast,
            avg_cpi=avg_cpi,
            avg_spi=avg_spi,
            on_budget_pct=on_budget_pct,
            on_schedule_pct=on_schedule_pct,
            portfolio_trir=portfolio_trir,
            total_incidents=total_incidents,
            green_count=green,
            yellow_count=yellow,
            red_count=red,
            cost_trend=cost_trend,
            schedule_trend=schedule_trend
        )

    def compare_projects(self, metric: str) -> ProjectComparison:
        """按特定指标比较项目。"""
        active = self.get_active_projects()

        if not active:
            return None

        metric_map = {
            "cpi": lambda p: p.cpi,
            "spi": lambda p: p.spi,
            "percent_complete": lambda p: p.percent_complete,
            "cost_variance": lambda p: p.cost_variance,
            "trir": lambda p: p.trir,
            "risk_score": lambda p: p.risk_score
        }

        if metric not in metric_map:
            raise ValueError(f"未知指标: {metric}")

        getter = metric_map[metric]
        values = {p.project_name: getter(p) for p in active}

        avg = statistics.mean(values.values())

        # 最佳/最差取决于指标(CPI越高越好,TRIR越低越好)
        if metric in ["trir", "risk_score"]:
            best = min(values.items(), key=lambda x: x[1])
            worst = max(values.items(), key=lambda x: x[1])
        else:
            best = max(values.items(), key=lambda x: x[1])
            worst = min(values.items(), key=lambda x: x[1])

        return ProjectComparison(
            metric=metric,
            projects=values,
            avg=avg,
            best=best,
            worst=worst
        )

    def get_projects_at_risk(self) -> List[ProjectMetrics]:
        """获取需要关注的项目。"""
        return [p for p in self.get_active_projects()
                if p.health in [HealthStatus.YELLOW, HealthStatus.RED]]

    def get_top_risks(self, limit: int = 10) -> List[Dict]:
        """获取整个组合中的顶级风险。"""
        risks = []

        for p in self.get_active_projects():
            if p.risk_score > 0:
                risks.append({
                    "project": p.project_name,
                    "risk_score": p.risk_score,
                    "critical_risks": p.critical_risks,
                    "cpi": p.cpi,
                    "spi": p.spi
                })

        return sorted(risks, key=lambda x: -x['risk_score'])[:limit]

    def forecast_cash_needs(self, months: int = 6) -> List[Dict]:
        """预测整个组合的现金需求。"""
        forecasts = []

        for month in range(1, months + 1):
            month_date = datetime.now() + timedelta(days=month * 30)

            month_spend = 0
            for p in self.get_active_projects():
                # 基于剩余工作的简单线性预测
                remaining = p.forecast_cost - p.actual_cost
                months_remaining = max(1, (p.forecast_end - datetime.now()).days / 30)
                monthly_burn = remaining / months_remaining
                month_spend += monthly_burn

            forecasts.append({
                "month": month_date.strftime("%Y-%m"),
                "projected_spend": month_spend
            })

        return forecasts

    def save_snapshot(self):
        """保存当前状态用于趋势分析。"""
        summary = self.calculate_portfolio_summary()
        if summary:
            self.snapshots.append({
                "date": datetime.now(),
                "avg_cpi": summary.avg_cpi,
                "avg_spi": summary.avg_spi,
                "on_budget_pct": summary.on_budget_pct,
                "on_schedule_pct": summary.on_schedule_pct,
                "total_forecast": summary.total_forecast_cost
            })

    def generate_report(self) -> str:
        """生成项目组合仪表盘报告。"""
        summary = self.calculate_portfolio_summary()

        if not summary:
            return "组合中没有项目"

        lines = [
            "# 项目组合仪表盘",
            "",
            f"**组合名称:** {self.portfolio_name}",
            f"**报告日期:** {summary.report_date.strftime('%Y-%m-%d')}",
            "",
            "## 执行摘要",
            "",
            f"| 指标 | 数值 |",
            f"|------|------|",
            f"| 项目总数 | {summary.total_projects} ({summary.active_projects} 个活跃) |",
            f"| 总合同价值 | ${summary.total_contract_value:,.0f} |",
            f"| 总预算 | ${summary.total_budget:,.0f} |",
            f"| 至今实际成本 | ${summary.total_actual_cost:,.0f} |",
            f"| 完成时预测 | ${summary.total_forecast_cost:,.0f} |",
            f"| 平均CPI | {summary.avg_cpi:.3f} |",
            f"| 平均SPI | {summary.avg_spi:.3f} |",
            f"| 按预算百分比 | {summary.on_budget_pct:.1f}% |",
            f"| 按进度百分比 | {summary.on_schedule_pct:.1f}% |",
            f"| 组合TRIR | {summary.portfolio_trir:.1f} |",
            f"| 总事故数 | {summary.total_incidents} |",
            f"| 绿色项目 | {summary.green_count} |",
            f"| 黄色项目 | {summary.yellow_count} |",
            f"| 红色项目 | {summary.red_count} |",
            f"| 成本趋势 | {summary.cost_trend} |",
            f"| 进度趋势 | {summary.schedule_trend} |",
            "",
            "## 健康状态分布",
            "",
            f"- 🟢 健康: {summary.green_count}",
            f"- 🟡 有风险: {summary.yellow_count}",
            f"- 🔴 危急: {summary.red_count}",
            "",
            "## 风险项目",
            ""
        ]

        at_risk = self.get_projects_at_risk()
        if at_risk:
            for p in at_risk:
                lines.append(f"- **{p.project_name}**: {p.health.value} - CPI: {p.cpi:.3f}, SPI: {p.spi:.3f}")
        else:
            lines.append("无风险项目")

        lines.extend([
            "",
            "## 项目比较 (按CPI)",
            ""
        ])

        try:
            comparison = self.compare_projects("cpi")
            if comparison:
                lines.append(f"| 项目 | CPI |")
                lines.append(f"|------|-----|")
                for name, val in sorted(comparison.projects.items(), key=lambda x: -x[1]):
                    lines.append(f"| {name} | {val:.3f} |")
                lines.append("")
                lines.append(f"- 平均: {comparison.avg:.3f}")
                lines.append(f"- 最好: {comparison.best[0]} ({comparison.best[1]:.3f})")
                lines.append(f"- 最差: {comparison.worst[0]} ({comparison.worst[1]:.3f})")
        except ValueError as e:
            lines.append(f"错误: {e}")

        lines.extend([
            "",
            "## 现金需求预测",
            ""
        ])

        cash_forecast = self.forecast_cash_needs()
        if cash_forecast:
            lines.append(f"| 月份 | 预计支出 |")
            lines.append(f"|------|--------|")
            for f in cash_forecast:
                lines.append(f"| {f['month']} | ${f['projected_spend']:,.0f} |")

        return "\n".join(lines)

使用示例

from portfolio_dashboard import PortfolioDashboard, ProjectMetrics, ProjectStatus
from datetime import datetime, timedelta

# 初始化仪表盘
dashboard = PortfolioDashboard("基础设施组合")

# 导入项目
dashboard.import_projects([
    {
        'id': 'P001',
        'name': '桥梁修复',
        'status': 'active',
        'contract_value': 50000000,
        'percent_complete': 45,
        'planned_start': datetime(2024, 1, 1),
        'planned_end': datetime(2025, 6, 30),
        'actual_start': datetime(2024, 1, 15),
        'forecast_end': datetime(2025, 7, 15),
        'budget': 45000000,
        'actual_cost': 22500000,
        'forecast_cost': 47000000,
        'cpi': 0.96,
        'spi': 0.93,
        'incidents': 2,
        'total_hours': 150000,
        'risk_score': 5.5,
        'critical_risks': 1
    }
])

# 计算汇总
summary = dashboard.calculate_portfolio_summary()
print(f"按预算百分比: {summary.on_budget_pct:.1f}%")
print(f"活跃项目: {summary.active_projects}")

# 保存快照用于趋势分析
dashboard.save_snapshot()

# 生成报告
report = dashboard.generate_report()
print(report)

配置

设置组合名称和阈值:

dashboard = PortfolioDashboard("我的组合")
dashboard.THRESHOLDS = {
    "cpi_warning": 0.98,
    "cpi_critical": 0.90,
    "spi_warning": 0.98,
    "spi_critical": 0.90,
    "trir_warning": 1.5,
    "risk_score_warning": 5.0
}

Individual skills in this repo

This repo contains 20 individual skills — each has its own dedicated page.

majiayu000/claude-skill-registry-data

Edit existing BMAD agents while maintaining compliance

majiayu000/claude-skill-registry-data

Edit existing BMAD agents while maintaining compliance

majiayu000/claude-skill-registry-data

Edit existing BMAD modules while maintaining coherence

majiayu000/claude-skill-registry-data

Edit existing BMAD modules while maintaining coherence

majiayu000/claude-skill-registry-data

Analyzes current state and user query to answer BMad questions or recommend the next workflow or agent. Use when user says what should I do next, what do I do now, or asks a question about BMad

majiayu000/claude-skill-registry-data

Build AI agents with Google ADK Python (Agent Development Kit). Use for multi-agent systems, workflow agents (sequential/parallel/loop), Vertex AI deployment, tool integration, human-in-the-loop.

majiayu000/claude-skill-registry-data

Build AI agents with Google ADK Python (Agent Development Kit). Use for multi-agent systems, workflow agents (sequential/parallel/loop), Vertex AI deployment, tool integration, human-in-the-loop.

majiayu000/claude-skill-registry-data

Portfolio allocation and rebalancing optimizer. Manages asset allocation across stocks/cash/bonds, performs periodic rebalancing, and ensures diversification according to market regime and risk tolerance.

majiayu000/claude-skill-registry-data

Create a hilarious and ultra-realistic video of an anthropomorphic animal acting like a human vlogger in a real-world setting.

majiayu000/claude-skill-registry-data

Speech-to-text transcription and translation via OpenAI Audio API -- models, response formats, timestamps, prompting, streaming, chunking, and diarization

majiayu000/claude-skill-registry-data

This skill should be used when the user asks about libraries, frameworks, API references, or needs code examples. Activates for setup questions, code generation involving libraries, or mentions of specific frameworks like React, Vue, Next.js, Prisma, Supabase, etc.

majiayu000/claude-skill-registry-data

小省导购员数字人带货版即梦视频提示词生成系统,基于四大智能体协同(提示词生成师、质量管控师、知识库运维师、跨环节适配师),按照"主体+运动+场景+(镜头语言+光影+氛围)"公式输出中英文双版提示词,适配5s短视频。确保人物一致性、视觉连贯性、情绪连贯性,支持知识库智能复用和跨工具适配(Suno音乐、AI绘画),为数字人带货视频提供高质量提示词生成服务。

majiayu000/claude-skill-registry-data

Upload and manage files using Google Gemini File API via scripts/. Use for uploading images, audio, video, PDFs, and other files for use with Gemini models. Supports file upload, status checking, and file management. Triggers on "upload file", "file API", "upload image", "upload PDF", "upload video", "file management".

majiayu000/claude-skill-registry-data

Analyze images/audio/video with Gemini API (better vision than Claude). Generate images (Imagen 4), videos (Veo 3). Use for vision analysis, transcription, OCR, design extraction, multimodal AI.

majiayu000/claude-skill-registry-data

Analyze images/audio/video with Gemini API (better vision than Claude). Generate images (Imagen 4), videos (Veo 3). Use for vision analysis, transcription, OCR, design extraction, multimodal AI.

majiayu000/claude-skill-registry-data

Skill for discovering and researching autonomous AI agents, tools, and ecosystems using the AgentFolio directory.

majiayu000/claude-skill-registry-data

Conduct domain and industry research. Use when the user says "lets create a research report on [domain or industry]

majiayu000/claude-skill-registry-data

Conduct market research on competition and customers. Use when the user says "create a market research report about [business idea]".

majiayu000/claude-skill-registry-data

Conduct technical research on technologies and architecture. Use when the user says "create a technical research report on [topic]".

majiayu000/claude-skill-registry-data

Builds, edit or validate Agent Skill through conversational discovery. Use when the user requests to "Create an Agent", "Optimize an Agent" or "Edit an Agent".

相关技能