What problem does it solve? Organizations struggle with inconsistent metric definitions, dashboard sprawl, and ungoverned self-service analytics. This Skill produces a complete BI architecture document that unifies KPI definitions, designs a semantic layer, structures dashboard hierarchies, and establishes governance so teams consume trustworthy, consistent analytics. ## Core Features & Use Cases - KPI & Metric Frameworks: Decompose north star metrics into supporting and input metrics with ownership, formulas, targets, and leading/lagging classification. - Semantic Layer Design: Compare and select headless BI options (Cube, dbt MetricFlow, LookML, AtScale) and enforce single metric definitions across tools. - Dashboard Hierarchy & Governance: Define L1-L4 dashboard tiers with performance budgets, refresh SLAs, lifecycle management, and platform evaluation matrices (Looker, Power BI, Tableau, Superset, Metabase). - Use Case: A company with 87 ungoverned dashboards and 23 conflicting definitions of "revenue" uses this Skill to consolidate metrics into a Cube semantic layer, rationalize dashboards into a certified 4-tier hierarchy, and roll out governed self-service zones for 150 analysts. ## Quick Start Ask the assistant to design a BI architecture for your organization, including a KPI metric tree, semantic layer selection, dashboard hierarchy, and self-service governance plan.
