Commercial Real Estate Occupancy Dashboard Specification Matrix

Role: Senior BI Architect specializing in Commercial Real Estate Asset Management.

Context

• Target Portfolio: {{portfolio_name}}
• Asset Asset Classes: {{property_types}}
• Key Dashboard Stakeholders: {{target_audience}}
• Core Portfolio Metrics: {{primary_kpis}}
• Target Pipeline Cadence: {{refresh_frequency}}
• Core Source Systems: {{data_source_systems}}

Task

Generate a comprehensive dashboard specification matrix for {{portfolio_name}} that maps core real estate metrics to specific visual widgets, target stakeholder views, filtering dimensions, and underlying system pipelines.

Method

1. Review the operational hierarchy across {{property_types}} and classify user data consumption tiers for {{target_audience}}.
2. Deconstruct {{primary_kpis}} into physical occupancy, economic vacancy, lease renewal probability, and tenant concentration risk indicators.
3. Audit {{data_source_systems}} to determine grain, latency constraints, and calculation dependencies across properties.
4. Design layout tiers categorizing components into Executive Summary, Lease Expiration Runway, and Asset-Level Drilldown.
5. Select optimal visualization types for each metric group to avoid chart clutter and support rapid anomaly detection.
6. Specify mandatory slice-and-dice dimensions including market submarket, lease type, asset tier, and expiration quarter.
7. Map required data alerts and conditional threshold coloring for underperforming occupancy corridors based on {{refresh_frequency}}.
8. Consolidate specifications into a prioritized dashboard architecture matrix.

Constraints

• MUST format the primary output as a comprehensive Markdown matrix table.
• MUST align every dashboard component directly with one or more items from {{primary_kpis}}.
• MUST NOT suggest non-standard chart types that lack native support in enterprise BI tools.
• Keep calculations explicit regarding physical square footage versus revenue-weighted leased area.

Output format

1. Dashboard View Hierarchy

A short breakdown of the 3 key visual layers (Executive, Asset Management, Leasing Ops).

2. Dashboard Specification Matrix

A Markdown table with the following exact columns: | View Layer | Metric / KPI | Visual Component | Data Source | Slicers & Filters | Threshold Alert Rule | Priority (P1-P3) |

3. Implementation Prerequisites

A bulleted list of 3-5 technical dependencies regarding {{data_source_systems}} and {{refresh_frequency}}.

Self-review

1. Did I include every metric from {{primary_kpis}} inside the matrix?
2. Are all asset classes in {{property_types}} accounted for in the slicing dimensions?
3. Does the matrix follow the exact requested column header structure without omitted rows?