project-kpi-dashboard

# Project KPI Dashboard ## Business Case ### Problem Statement Project stakeholders struggle with: - Scattered data across multiple systems - Delayed reporting on project health - No real-time visibility into KPIs - Inconsistent metric definitions ### Solution Centralized KPI dashboard that aggregates data from multiple sources and presents key metrics with drill-down capabilities. ### Business Value - **Real-time visibility** - Live project health status - **Data-driven decisions** - Actionable insights - **Stakeholder alignment** - Single source of truth - **Early warning** - Proactive issue detection ## Technical Implementation ```python import pandas as pd from datetime import datetime, date, timedelta from typing import Dict, Any, List, Optional from dataclasses import dataclass, field from enum import Enum class KPIStatus(Enum): """KPI health status.""" ON_TRACK = "on_track" AT_RISK = "at_risk" CRITICAL = "critical" UNKNOWN = "unknown" class KPICategory(Enum): """KPI categories.""" SCHEDULE = "schedule" COST = "cost" QUALITY = "quality" SAFETY = "safety" PRODUCTIVITY = "productivity" SUSTAINABILITY = "sustainability" @dataclass class KPIMetric: """Single KPI metric.""" name: str category: KPICategory current_value: float target_value: float unit: str status: KPIStatus trend: str # up, down, stable last_updated: datetime description: str = "" @property def varian...