Communitygithub.com

ポートフォリオダッシュボード

複数プロジェクトのポートフォリオ分析ダッシュボードです。プロジェクト間でKPIを集約し、ポートフォリオの健全性を追跡し、パフォーマンスを比較し、経営層の意思決定を支援します。

ポートフォリオダッシュボード とは?

このスキルは、複数の建設プロジェクトにわたるデータを集約・分析し、ポートフォリオレベルの可視性を提供するPythonベースのダッシュボードです。プロジェクトの財務、スケジュール、安全、品質、リスクに関するKPIを追跡し、ポートフォリオ全体の健全性を評価します。主な機能として、プロジェクトメトリクスのインポート、ポートフォリオサマリーの計算、プロジェクト間のパフォーマンス比較、リスク分析、キャッシュフロー予測、トレンド分析のためのスナップショット保存などがあります。このスキルはClaude CodeやCodexなどのAIエージェントプラットフォームで動作し、データ構造(ProjectMetrics、PortfolioSummary、ProjectComparison)と主要クラス(PortfolioDashboard)を通じて、プロジェクトのステータス、健全性(グリーン/イエロー/レッド)、CPI(コスト効率指数)、SPI(スケジュール効率指数)、TRIR(総記録可能災害率)などの指標を計算します。経営層はこのダッシュボードを使用して、予算超過やスケジュール遅延のあるプロジェクトを特定し、戦略的なリソース配分を決定できます。

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

お気に入りのAIに質問する

このエージェントスキルを事前に読み込んだ状態で新しいチャットを開きます。

ドキュメント

Portfolio Dashboard

概要

複数の建設プロジェクトにわたるデータを集約・分析し、ポートフォリオレベルの可視性を提供します。KPIを追跡し、傾向を特定し、プロジェクトパフォーマンスを比較し、戦略的なリソース配分の意思決定をサポートします。

Portfolio Analytics Framework

┌─────────────────────────────────────────────────────────────────┐
│                  PORTFOLIO DASHBOARD                             │
├─────────────────────────────────────────────────────────────────┤
│                                                                  │
│  PROJECT A    PROJECT B    PROJECT C    PROJECT D               │
│     ↓             ↓            ↓            ↓                   │
│  ┌─────────────────────────────────────────────┐                │
│  │           DATA AGGREGATION                   │                │
│  │  コスト | スケジュール | 安全 | 品質 | リスク   │                │
│  └─────────────────────────────────────────────┘                │
│                         ↓                                        │
│  ┌─────────────────────────────────────────────┐                │
│  │          PORTFOLIO KPIs                      │                │
│  │  📊 総契約額    📈 スケジュール遵守率(%)      │                │
│  │  💰 予算内比率(%)  🛡️ 安全率                  │                │
│  │  ⚠️ リスクスコア     📋 リソース活用率          │                │
│  └─────────────────────────────────────────────┘                │
│                                                                  │
└─────────────────────────────────────────────────────────────────┘

技術的実装

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"Unknown metric: {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 "No projects in portfolio"

        lines = [
            "# Portfolio Dashboard",
            "",
            f"**Portfolio:** {self.portfolio_name}",
            f"**Report Date:** {summary.report_date.strftime('%Y-%m-%d')}",
            "",
            "## Executive Summary",
            "",
            f"| Metric | Value |",
            f"|--------|-------|",
            f"| Total Projects | {summary.total_projects} ({summary.active_projects} active) |",
            f"| Total Contract Value | ${summary.total_contract_value:,.0f} |",
            f"| Total Budget | ${summary.total_budget:,.0f} |",
            f"| Actual Cost to Date | ${summary.total_actual_cost:,.0f} |",
            f"| Forecast at Completion | ${summary.total_forecast_cost:,.0f} |",
            "",
            "## Portfolio Health",
            "",
            f"| Health Status | Count |",
            f"|---------------|-------|",
            f"| 🟢 Green | {summary.green_count} |",
            f"| 🟡 Yellow | {summary.yellow_count} |",
            f"| 🔴 Red | {summary.red_count} |",
            "",
            "## Key Performance Indicators",
            "",
            f"| KPI | Value | Trend |",
            f"|-----|-------|-------|",
            f"| Average CPI | {summary.avg_cpi:.2f} | {summary.cost_trend} |",
            f"| Average SPI | {summary.avg_spi:.2f} | {summary.schedule_trend} |",
            f"| On Budget (%) | {summary.on_budget_pct:.1f}% | |",
            f"| On Schedule (%) | {summary.on_schedule_pct:.1f}% | |",
            f"| Total Incidents | {summary.total_incidents} | |",
            f"| Portfolio TRIR | {summary.portfolio_trir:.1f} | |",
        ]

        return "\n".join(lines)

    def visualize(self) -> str:
        """ASCIIベースのダッシュボード可視化を生成します。"""
        summary = self.calculate_portfolio_summary()
        if not summary:
            return ""

        visual = f"""
┌─────────────────────────────────────────────────┐
│           Portfolio Health Dashboard            │
├─────────────────────────────────────────────────┤
│  Portfolio: {self.portfolio_name:<30}  │
│  Date: {summary.report_date.strftime('%Y-%m-%d'):<35}  │
├─────────────────────────────────────────────────┤
│  Active Projects: {summary.active_projects:<34}  │
│  Total Value: ${summary.total_contract_value:>12,.0f}  │
│  Budget: ${summary.total_budget:>18,.0f}  │
│  Actual Cost: ${summary.total_actual_cost:>14,.0f}  │
├─────────────────────────────────────────────────┤
│  Health Status Distribution                    │
│                                                │
│  🟢 Green: {summary.green_count:<4}  {'█' * min(summary.green_count, 20):<20}  │
│  🟡 Yellow: {summary.yellow_count:<3}  {'█' * min(summary.yellow_count, 20):<20}  │
│  🔴 Red: {summary.red_count:<6}  {'█' * min(summary.red_count, 20):<20}  │
├─────────────────────────────────────────────────┤
│  Performance Indicators                        │
│                                                │
│  CPI: {summary.avg_cpi:.2f} {'→' if summary.cost_trend == 'stable' else '↑' if summary.cost_trend == 'improving' else '↓':<3} {summary.cost_trend:<12}  │
│  SPI: {summary.avg_spi:.2f} {'→' if summary.schedule_trend == 'stable' else '↑' if summary.schedule_trend == 'improving' else '↓':<3} {summary.schedule_trend:<12}  │
│  On Budget: {summary.on_budget_pct:.0f}%                                    │
│  On Schedule: {summary.on_schedule_pct:.0f}%                                 │
├─────────────────────────────────────────────────┤
│  Safety Metrics                                │
│                                                │
│  TRIR: {summary.portfolio_trir:.1f}                                    │
│  Total Incidents: {summary.total_incidents:<30}  │
└─────────────────────────────────────────────────┘
"""
        return visual

使用例

# ポートフォリオダッシュボードの初期化
dashboard = PortfolioDashboard("Infrastructure Projects 2024")

# プロジェクトデータのインポート
projects_data = [
    {
        'id': 'PRJ-001',
        'name': 'Highway Expansion',
        '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': 20000000,
        'forecast_cost': 46000000,
        'cpi': 0.95,
        'spi': 0.93,
        'incidents': 2,
        'total_hours': 150000,
        'risk_score': 6.5,
        'critical_risks': 2
    },
    {
        'id': 'PRJ-002',
        'name': 'Bridge Construction',
        'status': 'active',
        'contract_value': 35000000,
        'percent_complete': 30,
        'planned_start': datetime(2024, 3, 1),
        'planned_end': datetime(2025, 12, 31),
        'actual_start': datetime(2024, 3, 1),
        'forecast_end': datetime(2025, 12, 31),
        'budget': 32000000,
        'actual_cost': 9500000,
        'forecast_cost': 32000000,
        'cpi': 1.02,
        'spi': 1.01,
        'total_hours': 80000,
        'risk_score': 3.0
    }
]

dashboard.import_projects(projects_data)

# ポートフォリオサマリーの計算
summary = dashboard.calculate_portfolio_summary()
print(f"Total Value: ${summary.total_contract_value:,.0f}")
print(f"Active Projects: {summary.active_projects}")
print(f"Average CPI: {summary.avg_cpi:.2f}")
print(f"On Budget: {summary.on_budget_pct:.1f}%")

# プロジェクトの比較
comparison = dashboard.compare_projects("cpi")
print(f"Best: {comparison.best}")
print(f"Worst: {comparison.worst}")

# リスクのあるプロジェクトの特定
risky = dashboard.get_projects_at_risk()
for p in risky:
    print(f"{p.project_name}: {p.health.value}")

# レポートの生成
dashboard.save_snapshot()
report = dashboard.generate_report()
print(report)

# ダッシュボードの可視化
dashboard.visualize()

ベストプラクティス

  1. データ品質: インポートする前にプロジェクトデータが正確で完全であることを確認してください。
  2. 定期的なスナップショット: トレンド分析を可能にするために、定期的にsave_snapshot()を呼び出してください。
  3. しきい値の調整: 組織のリスク許容度に合わせてTHRESHOLDSをカスタマイズしてください。
  4. 定期的な見直し: 毎週または隔週でget_projects_at_risk()を確認し、問題に積極的に対処してください。
  5. 指標の組み合わせ: 単一の指標に頼らず、CPI、SPI、リスクスコア、その他の指標を組み合わせて包括的なポートフォリオの健全性を把握してください。

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".

関連スキル