KPI / operating reviews
Metric design defines what teams measure, how performance is monitored, and how decision makers interpret operational health.
What this system does
Defines north-star, activation, retention, churn, revenue, cost, operational, and quality metrics.
Connects metric definitions to SQL logic, dashboards, review cadences, and stakeholder decisions.
Adds QA checks so metrics are trusted before they reach leadership or product teams.
How I use it
BudgetDB uses spend allocation, headcount, software cost per employee, source-to-fact reconciliation, and executive views.
Dashboards show KPI surfaces for contact center performance, revenue/product mix, and operating review.
Product analytics SQL examples calculate conversion, churn, NPS, CSAT, and first-purchase logic.
Related projects
Evidence or examples
BudgetDB code creates company software cost per employee and team allocation views.
Portfolio SQL demo includes churn rate, conversion rate, NPS, and CSAT examples.
Dashboard assets include contact center KPI and revenue/product dashboard examples.
metric_name + owner + source table + calculation + grain + refresh cadence + QA check + business decision.ROUND(total_software_spend_2025 / NULLIF(total_employees_2025, 0), 2) AS software_cost_per_employee_2025A north-star metric should reflect durable value, not just activity. Pair it with guardrail metrics.