Communitygithub.com

Panel de Portafolio

Panel de análisis de portafolio multideportivo. Agrega KPI entre proyectos, rastrea la salud del portafolio, compara rendimiento y apoya la toma de decisiones ejecutivas.

¿Qué es Panel de Portafolio?

Este skill implementa un panel de control de portafolio multi-proyecto para dar visibilidad a nivel de portafolio en proyectos de construcción. Agrega y analiza datos de múltiples proyectos, rastreando indicadores clave de rendimiento (KPI) como costo, cronograma, seguridad, calidad y riesgo. Permite comparar el rendimiento entre proyectos, identificar proyectos en riesgo, y apoyar decisiones estratégicas como la asignación de recursos y la previsión de necesidades de efectivo. Es compatible con plataformas de agentes AI que ejecutan habilidades basadas en Python y markdown, como Claude Code, Cursor, o Codex, y proporciona una estructura modular con clases para métricas de proyecto, resumen de portafolio, comparación de proyectos y un panel completo que genera informes ejecutivos a partir de los datos importados.

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

Preguntar en tu IA favorita

Abre un nuevo chat con esta habilidad de agente ya precargada.

Documentación

¿Qué hace Panel de Portafolio?

Resumen

Agregue y analice datos de múltiples proyectos de construcción para obtener visibilidad a nivel de portafolio. Rastree KPI, identifique tendencias, compare el rendimiento de proyectos y apoye decisiones estratégicas de asignación de recursos.

Marco de Análisis de Portafolio

┌─────────────────────────────────────────────────────────────────┐
│                  PANEL DE PORTAFOLIO                             │
├─────────────────────────────────────────────────────────────────┤
│                                                                  │
│  PROYECTO A    PROYECTO B    PROYECTO C    PROYECTO D               │
│     ↓             ↓            ↓            ↓                   │
│  ┌─────────────────────────────────────────────┐                │
│  │           AGREGACIÓN DE DATOS                   │
│  │  Costo | Cronograma | Seguridad | Calidad | Riesgo   │
│  └─────────────────────────────────────────────┘                │
│                         ↓                                        │
│  ┌─────────────────────────────────────────────┐                │
│  │          KPI DEL PORTAFOLIO                      │
│  │  📊 Valor Total    📈 % A Tiempo              │
│  │  💰 % Dentro de Presupuesto    🛡️ Tasa de Seguridad            │
│  │  ⚠️ Puntaje de Riesgo     📋 Utilización de Recursos          │
│  └─────────────────────────────────────────────┘                │
│                                                                  │
└─────────────────────────────────────────────────────────────────┘

Implementación Técnica

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"       # En camino
    YELLOW = "yellow"     # En riesgo
    RED = "red"           # Crítico
    GREY = "grey"         # No iniciado/En espera

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

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

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

    # Seguridad
    recordable_incidents: int = 0
    total_hours: float = 0
    trir: float = 0.0

    # Calidad
    defects_open: int = 0
    rework_cost: float = 0.0

    # Riesgo
    risk_score: float = 0.0
    critical_risks: int = 0

    @property
    def health(self) -> HealthStatus:
        """Determina la salud general del proyecto."""
        if self.status in [ProjectStatus.ON_HOLD, ProjectStatus.CANCELLED]:
            return HealthStatus.GREY

        # Crítico si está significativamente por encima del presupuesto/cronograma
        if self.cpi < 0.85 or self.spi < 0.85 or self.critical_risks > 3:
            return HealthStatus.RED

        # En riesgo si está moderadamente fuera de lo previsto
        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

    # Rendimiento
    avg_cpi: float
    avg_spi: float
    on_budget_pct: float
    on_schedule_pct: float

    # Seguridad
    portfolio_trir: float
    total_incidents: int

    # Distribución de salud
    green_count: int
    yellow_count: int
    red_count: int

    # Tendencias
    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:
    """Analítica de portafolio multi-proyecto."""

    # Umbrales de salud
    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] = []  # Datos históricos

    def add_project(self, metrics: ProjectMetrics):
        """Agrega o actualiza un proyecto en el portafolio."""
        self.projects[metrics.project_id] = metrics

    def import_projects(self, projects_data: List[Dict]) -> int:
        """Importa múltiples proyectos desde datos."""
        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)
            )

            # Calcular métricas derivadas
            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]:
        """Obtiene la lista de proyectos activos."""
        return [p for p in self.projects.values()
                if p.status == ProjectStatus.ACTIVE]

    def calculate_portfolio_summary(self) -> PortfolioSummary:
        """Calcula métricas de resumen a nivel de portafolio."""
        active = self.get_active_projects()
        all_projects = list(self.projects.values())

        if not all_projects:
            return None

        # Totales
        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)

        # Promedios de rendimiento (ponderados por presupuesto)
        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

        # Porcentajes dentro de presupuesto/cronograma
        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

        # Métricas de seguridad
        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

        # Distribución de salud
        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])

        # Tendencias (comparar con la instantánea anterior si está disponible)
        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:
        """Compara proyectos por una métrica específica."""
        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"Métrica desconocida: {metric}")

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

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

        # Mejor/peor depende de la métrica (CPI más alto es bueno, TRIR más bajo es bueno)
        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]:
        """Obtiene proyectos que necesitan atención."""
        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]:
        """Obtiene los principales riesgos en todo el portafolio."""
        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]:
        """Pronostica las necesidades de efectivo en todo el portafolio."""
        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():
                # Proyección lineal simple basada en el trabajo restante
                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):
        """Guarda el estado actual para el análisis de tendencias."""
        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:
        """Genera un informe del panel de portafolio."""
        summary = self.calculate_portfolio_summary()

        if not summary:
            return "No hay proyectos en el portafolio"

        lines = [
            "# Panel de Portafolio",
            "",
            f"**Portafolio:** {self.portfolio_name}",
            f"**Fecha del Informe:** {summary.report_date.strftime('%Y-%m-%d')}",
            "",
            "## Resumen Ejecutivo",
            "",
            f"| Métrica | Valor |",
            f"|--------|-------|",
            f"| Proyectos Totales | {summary.total_projects} ({summary.active_projects} activos) |",
            f"| Valor Total del Contrato | ${summary.total_contract_value:,.0f} |",
            f"| Presupuesto Total | ${summary.total_budget:,.0f} |",
            f"| Costo Real a la Fecha | ${summary.total_actual_cost:,.0f} |",
            f"| Pronóstico al Finalizar | ${summary.total_forecast_cost:,.0f} |",
            f"| CPI Promedio | {summary.avg_cpi:.2f} |",
            f"| SPI Promedio | {summary.avg_spi:.2f} |",
            f"| Dentro del Presupuesto | {summary.on_budget_pct:.1f}% |",
            f"| A Tiempo | {summary.on_schedule_pct:.1f}% |",
            f"| TRIR del Portafolio | {summary.portfolio_trir:.2f} |",
            f"| Incidentes Totales | {summary.total_incidents} |",
            "",
            "## Distribución de Salud",
            f"- 🟢 Verde (En camino): {summary.green_count}",
            f"- 🟡 Amarillo (En riesgo): {summary.yellow_count}",
            f"- 🔴 Rojo (Crítico): {summary.red_count}",
            "",
            "## Tendencias",
            f"- Tendencia de Costo: {summary.cost_trend}",
            f"- Tendencia de Cronograma: {summary.schedule_trend}",
            "",
            "## Proyectos en Riesgo",
            "",
            "Los siguientes proyectos necesitan atención:",
            "",
        ]

        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:.2f}, SPI: {p.spi:.2f})")
        else:
            lines.append("- No se identificaron proyectos en riesgo en este momento.")

        lines.append("")
        lines.append("## Proyección de Efectivo para los Próximos 6 Meses")
        lines.append("")

        cash_forecast = self.forecast_cash_needs(6)
        if cash_forecast:
            for forecast in cash_forecast:
                lines.append(f"- {forecast['month']}: ${forecast['projected_spend']:,.0f}")

        lines.append("")
        lines.append("---")
        lines.append("*Generado por el Sistema de Análisis de Portafolio*")

        return "\n".join(lines)

Individual skills in this repo

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

majiayu000/claude-skill-registry

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

majiayu000/claude-skill-registry

Edit existing BMAD agents while maintaining compliance

majiayu000/claude-skill-registry

Edit existing BMAD agents while maintaining compliance

majiayu000/claude-skill-registry

Edit existing BMAD modules while maintaining coherence

majiayu000/claude-skill-registry

Edit existing BMAD modules while maintaining coherence

majiayu000/claude-skill-registry

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

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

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

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

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

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

majiayu000/claude-skill-registry

BlockRun works with Claude Code and Google Antigravity.

majiayu000/claude-skill-registry

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

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

majiayu000/claude-skill-registry

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

CRITICAL: Use for MolyKit AI chat toolkit. Triggers on: BotClient, OpenAI, SSE streaming, AI chat, molykit, PlatformSend, spawn(), ThreadToken, cross-platform async, Chat widget, Messages, PromptInput, Avatar, LLM

majiayu000/claude-skill-registry

AI and machine learning workflow covering LLM application development, RAG implementation, agent architecture, ML pipelines, and AI-powered features.

majiayu000/claude-skill-registry

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

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

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

Skills relacionados