Skip to content

Author: Yasemen Nur Salım Dündar

Category Performance Intelligence

Tableau Category Performance Dashboard

Category performance is a scale-versus-reliability story. E-Commerce is the largest value pool, but it also carries the weakest completion profile. Digital Wallet is much smaller, but it shows the strongest execution quality.

Key takeaway

Nova should not treat every category as an equal growth candidate. The biggest opportunity is to protect high-GMV categories where reliability leakage is expensive, while using stronger categories as operating benchmarks.

Key Findings

Finding Metric Interpretation
E-Commerce is the value anchor $1.11B GMV, 41.9% GMV share The category drives the largest share of platform value
E-Commerce also has the weakest completion profile 86.5% completion, about 15.0% non-completed amount rate Reliability improvements here have the highest financial leverage
Food Delivery is the usage engine 14.86M transactions, 93.6% completion It drives the most interactions and performs better operationally than the largest GMV category
Grocery is the second-largest value pool $520.8M GMV, 19.6% GMV share, 91.5% completion It is large enough to matter, but should be monitored for service-risk concentration
Ride Hailing needs stabilization $312.2M GMV, 88.0% completion, about 11.9% non-completed amount rate The category has meaningful scale with weaker reliability
Digital Wallet is the reliability benchmark 96.6% completion, $279.6M GMV It is smaller, but shows the strongest execution quality

Business Insights

The category portfolio is not simply a ranking by GMV. E-Commerce deserves the most attention because it combines the largest value base with the most visible reliability leakage. Even small improvements in completion, failure, or refund behavior would affect a larger dollar base than in any other category.

Food Delivery and Grocery tell a different story. Food Delivery has the highest interaction volume, making it important for daily engagement and operational capacity planning. Grocery is a large value pool with decent completion, but the dashboard's service-risk distribution suggests it should be watched before scaling aggressively.

The dashboard also surfaces 3,067 critical services, a 4.4 average rating, and a 6.4% repeat user rate. That means category performance should be managed below the category level: service health, service concentration, and risk segment mix determine whether growth is durable.

Recommendation

Prioritize reliability work in E-Commerce and Ride Hailing, use Digital Wallet as the quality benchmark, and review critical or monitor services before pushing growth investment into categories with elevated non-completion risk.

This analysis is built with dbt service-health and category-health models. It does not use predictive modeling.

dbt Model Flow

Layer Models Purpose
Staging stg_interactions, stg_services, stg_markets Standardize corrected transaction, service, and market data
Intermediate int_services_enriched, int_service_interactions, int_service_health, int_service_risk, int_category_health Join services to interactions, aggregate service performance, classify service risk, and roll up category health
Mart mart_category_performance, mart_category_market_performance, mart_marketplace_service Provide Tableau-ready category, market-category, and service-level reporting tables

Risk Logic

Service risk is assigned from operational signals:

Signal Role
Success rate Measures completed interaction reliability
Failure rate Flags services with elevated failure behavior
Refund rate Captures revenue and quality leakage
Rating Adds customer-facing service quality context

The category dashboard then rolls these service-level signals into category-level risk and growth views.

Why this matters

The dashboard is not just visualizing raw category totals. It is built from a service-level health model, which lets category performance reflect both scale and operational quality.