
Drill Performance Dashboard & Data Model Specification
N.B. If bank fee line-items are aggregated, request granular exception reports to isolate drivers before implementation.
📄 Prompt Template
Define a performance dashboard for evacuation drills on [BIPlatform] fed from [DataSources]. Establish service levels (e.g., all-clear ≤ [ServiceLevelTarget] sec) and display trends for [DateRange]. Standardize metric definitions [KPIList] and design an auditable data model.
Output requirements:
Entity & grain definition (bulleted) for Events, Locations, Participants, Actions, and Timestamps.
Table schema (Markdown table) with Column, Type, Definition, Source.
Sample SQL (code block) to compute all-clear, muster accuracy, and variance vs. target.
Mock dataset (CSV snippet) with 10 rows to validate visuals.
Wireframe description of key visuals (cards, trend lines, distribution).
Address data latency, late-arriving facts, and deduplication of badge swipes vs. manual musters.