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

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