Utilization and Realization Performance Dashboard Specification

Role: Principal Business Intelligence Architect with 15+ years designing enterprise telemetry for global professional services firms.

Context

• Practice coverage: {{practice_area_scope}}
• Data sources: {{source_systems}}
• Commercial models: {{billing_model_types}}
• Utilization targets: {{target_utilization_benchmark}}
• Data latency threshold: {{reporting_latency_sla}}
• Target audience: {{stakeholder_roles}}

Task

Produce an executive dashboard technical and design brief that establishes KPI data models, drill-down logic, and layout hierarchy for tracking practitioner billable utilization, billing realization rates, and revenue leakage across practice areas.

Method

1. Map data ingestion feeds from {{source_systems}} against target {{reporting_latency_sla}} to ensure data freshness.
2. Define standardized mathematical formulas for billable utilization, standard realization, and collected realization across {{billing_model_types}}.
3. Establish variance benchmarks comparing actual billings against {{target_utilization_benchmark}}.
4. Design tier-one overview cards displaying headline utilization, fee write-downs, and unbilled WIP inventory.
5. Structure second-tier multidimensional slice-and-dice views segmented by {{practice_area_scope}} and individual contributor seniority.
6. Detail role-based row-level security parameters aligned with {{stakeholder_roles}}.
7. Specify anomaly detection alerts for engagements experiencing systematic write-offs or chronic under-utilization.

Constraints

• MUST define explicit calculation formulas for standard rate realization versus effective rate realization.
• MUST NOT expose individual billing rates to unauthorized {{stakeholder_roles}}.
• Must provide explicit guidance on handling non-billable business development and administrative time.
• All metric visualizations must enforce data lineage traceability back to source time cards and invoices.
• Output must remain strictly implementation-ready without placeholder pseudo-code.

Output format

Provide a technical dashboard brief containing:

1. Executive Summary and Architecture Overview (max 200 words)
2. Metric Catalog and Semantic Layer Specifications (table with Metric Name, Business Logic, Formula, and Source System)
3. Visual Wireframe Layout and User Flow Hierarchy (structured list of viewports and filter containers)
4. Security and Access Governance Matrix
5. Alerting Engine Rules and Trigger Thresholds

Self-review

• Ensure every formula accounts for differences across {{billing_model_types}}.
• Verify all {{stakeholder_roles}} have distinct permission-tier mappings.
• Confirm layout directly addresses write-down mitigation.