Choose Your Level
Pick the difficulty that matches where you are. You can come back and try a harder level later.
Define KPIs for a Startup
Identify the 5 most important metrics for a food delivery startup.
Diagnose a Metric Drop
Revenue dropped 15% month-over-month. Write a structured root-cause analysis.
Design a Metrics Framework (North Star)
Build a full metrics tree from a North Star metric down to team-level leading indicators.
Business Metrics & KPI Definition (SaaS & E-Commerce)
Understanding commercial metrics is critical for aligning data analysis with business goals. Tech companies look for analysts who know how to calculate Customer Acquisition Cost (CAC), Lifetime Value (LTV), Churn Rate, Monthly Recurring Revenue (MRR), and Net Promoter Score (NPS).
1. Business KPI Taxonomy & Spec
Comprehensive KPI dictionary defining metric formulas, data source tables, update frequencies, and target benchmarks.
2. Automated SQL/Python Metric Script
Query script calculating CAC, LTV, churn rate, and cohort retention metrics.
3. Executive KPI Dashboard
Interactive KPI tracking board highlighting month-over-month trend variations.
Frequently Asked Questions (Business Metrics & KPIs)
What is an ideal LTV:CAC ratio for subscription businesses?
A healthy LTV:CAC ratio is 3:1 or higher, meaning customer lifetime value is three times the cost required to acquire them.
How do you calculate customer churn rate?
Churn Rate = (Customers lost during period / Total customers at start of period) * 100.
What is the difference between leading and lagging KPIs?
Leading KPIs predict future performance (e.g. free trial signups), whereas lagging KPIs measure historical outcomes (e.g. quarterly revenue).
Explore Data Analytics Career Paths
Build proof of work across other topics or view full career roadmaps mapping technical skills to hiring expectations.