Competency Center and Business Intelligence knowledge for consulting engagements. Use when working on data architecture, KPI frameworks, dashboards, BI implementation, or analytics enablement. Covers COE establishment, metric design, visualization best practices, and data platform selection.
Instalar com Codex ou Claude Copie este prompt, cole no Codex, Claude ou outro assistente e deixe que ele revise a página da skill e instale para você.
Um comando direto ignora o prompt de revisão. Verifique a origem antes de executá-lo.
Competency Center and Business Intelligence knowledge for consulting engagements. Use when working on data architecture, KPI frameworks, dashboards, BI implementation, or analytics enablement. Covers COE establishment, metric design, visualization best practices, and data platform selection.
Competency Center Solutions Skill
Overview
Provides specialized knowledge for competency center and business intelligence engagements including data architecture design, KPI framework development, dashboard creation, and analytics operating model establishment.
KPI Framework Development
KPI Definition Template
KPI Name: [Name]
Business Owner: [Role]
Definition: [Clear, unambiguous description]
Formula: [Numerator / Denominator]
Unit: [%, $, #, etc.]
Frequency: [Daily/Weekly/Monthly/Quarterly]
Data Source: [System(s)]
Target: [Value and rationale]
Threshold: Red < [X] < Yellow < [Y] < Green
Trend Direction: Higher is Better / Lower is Better
Related KPIs: [Dependencies]
Semantic Colors:
├── Green: Good/Positive/On track
├── Yellow/Amber: Warning/Caution
├── Red: Bad/Negative/Critical
├── Blue: Neutral/Informational
└── Gray: Secondary/Disabled
Avoid:
├── More than 5 colors per visual
├── Color as only differentiator (accessibility)
├── Bright/saturated colors for large areas
└── Red-green only (colorblind users)
Data Architecture Patterns
Data Warehouse Architecture (Kimball)
Source Systems → Staging → Data Warehouse → Data Marts → BI Tools
↓
Dimension Tables ←→ Fact Tables
(Who, What, Where) (Measures)
Centralized COE:
├── Single team serves entire organization
├── Consistent standards and governance
├── Resource efficiency
└── May create bottleneck
Federated COE:
├── Central standards, distributed execution
├── Business unit analysts embedded
├── Flexibility with governance
└── Balance of control and agility
Hybrid COE:
├── Core team for platform/standards
├── Embedded analysts for business
├── Community of practice
└── Most common model
