Skip to content

sickn33/agentic-awesome-skills / plugins/aasb-aas-ai-product-evaluation-ops/skills/kpi-dashboard-design

kpi-dashboard-design

Verified

Comprehensive patterns for designing effective Key Performance Indicator (KPI) dashboards that drive business decisions.

FileKindSize
SKILL.mdskill md17.5 KB
resources/implementation-playbook.mdmarkdown1.2 KB
resources/metric-queries.sqlother1.3 KB

resources/metric-queries.sql

View on GitHub
-- Inputs are normalized month_index integers, one user per id, and spend rows at source grain.
-- query: retention
WITH cohort_sizes AS (
 SELECT cohort_month, COUNT(*) AS cohort_size FROM users GROUP BY cohort_month
), active AS (
 SELECT DISTINCT u.cohort_month, e.month_index - u.cohort_month AS month_offset, u.id
 FROM users u JOIN events e ON e.user_id = u.id
 WHERE e.month_index >= u.cohort_month
)
SELECT a.cohort_month, a.month_offset, COUNT(*) AS active_users,
       100.0 * COUNT(*) / c.cohort_size AS retention_pct
FROM active a JOIN cohort_sizes c ON c.cohort_month = a.cohort_month
GROUP BY a.cohort_month, a.month_offset, c.cohort_size;
-- query: cac
WITH spend_by_month AS (
 SELECT month_index, SUM(amount) AS spend FROM spend GROUP BY month_index
), acquired AS (
 SELECT cohort_month AS month_index, COUNT(*) AS customers
 FROM users WHERE source = 'marketing' GROUP BY cohort_month
)
SELECT s.month_index, s.spend, COALESCE(a.customers, 0) AS customers,
       1.0 * s.spend / NULLIF(a.customers, 0) AS cac
FROM spend_by_month s LEFT JOIN acquired a ON a.month_index = s.month_index;
-- query: growth
WITH previous AS (
 SELECT month_index, amount, LAG(amount) OVER (ORDER BY month_index) AS previous_amount
 FROM monthly_revenue
)
SELECT month_index, amount, 100.0 * (amount - previous_amount) / NULLIF(previous_amount, 0) AS growth_pct
FROM previous;
brainstormingobra/superpowersYou MUST use this before any creative work - creating features, building components, adding functionality, modifying behavior, or planning anything new, in software or out of it (a talk, a business, a renovation).Stars: 322kUpdated Claude CodeCodexVerifiedInstall
brand-guidelinesanthropics/skillsApplies Anthropic's official brand colors and typography to any sort of artifact that may benefit from having Anthropic's look-and-feel. Use it when brand colors or style guidelines, visual formatting, or company design standards apply.Stars: 198kUpdated Claude CodeCodexVerifiedInstall
frontend-designanthropics/skillsGuidance for distinctive, intentional visual design when building new UI or reshaping an existing one. Helps with aesthetic direction, typography, and making choices that don't read as templated defaults.Stars: 198kUpdated Claude CodeCodexVerifiedInstall
mcp-builderanthropics/skillsGuide for creating high-quality MCP (Model Context Protocol) servers that enable LLMs to interact with external services through well-designed tools. Use when building MCP servers to integrate external APIs or services, whether in Python (FastMCP) or Node/TypeScript (MCP SDK).Stars: 198kUpdated Claude CodeCodexVerifiedInstall