kpi-tracker

# KPI Tracker ## Overview The KPI Tracker skill provides comprehensive capabilities for defining, calculating, and monitoring Key Performance Indicators. It supports the full KPI lifecycle from definition through tracking, alerting, and reporting for business intelligence and performance management. ## Capabilities - KPI formula definition and validation - Target and threshold management - Traffic light status calculation - Trend analysis and forecasting - Drill-down hierarchy configuration - Benchmark comparison - Variance analysis - Automated alert generation ## Used By Processes - KPI Framework Development - Executive Dashboard Development - Operational Reporting System Design ## Usage ### KPI Definition ```python # Define KPI structure kpi_definition = { "name": "Customer Acquisition Cost", "code": "CAC", "category": "Marketing", "description": "Total cost to acquire a new customer", "formula": "total_marketing_spend / new_customers_acquired", "unit": "currency", "polarity": "lower_is_better", "frequency": "monthly", "owner": "Marketing Director", "data_sources": [ {"name": "marketing_spend", "source": "finance_system", "table": "expenses"}, {"name": "new_customers", "source": "crm", "table": "customers"} ] } ``` ### Target Configuration ```python # Define targets and thresholds targets = { "kpi": "CAC", "period": "2024-Q1", "target": 150, "thresholds": { "green": {"max": 150}, ...