Design a KPI framework and dashboard specification for after-hours access performance aimed at [ExecutiveAudience]. Define leading/lagging metrics, data lineage, and SLAs. Cover metrics such as “Unscheduled After-Hours Entries,” “Door Held Open > [SLAThreshold] seconds,” “Badge-to-CCTV Correlation Rate,” “Approval Latency,” and “Log Ingestion Delay ≤ [DataLatency].” Include integration notes for [SIEM] and data refresh timing aligned to [ReportingCadence].
Output format:
KPI Dictionary (Markdown table: Metric | Definition | Formula/Pseudo-SQL | Target | Owner | Alert Threshold)
Data Sources & Joins (list with field-level mapping)
Dashboard Wireframe (textual layout: tiles, drill paths, filters)
Alerting Rules (table: Condition | Severity | Channel | On-Call Group)
Data Quality Checks (table: Check | Frequency | Pass Criteria | Fallback).
End with acceptance criteria for UAT.