Projects

Product analytics case studies: A/B tests, retention, segmentation, dashboards. Filter by sphere, category and stack.

All projects

Experiments

Volta Neobank — Product Analytics

Fixed a neobank's onboarding bottleneck with an A/B test: +5.72pp KYC conversion, €208.5K in 12 mo at 13.9× ROI. 23 projects: funnel → A/B → retention → segmentation → Market & Jobs → RAT v2 → causal.

Pythonpandas / NumPy +4

Experiments

CRM Experiment Lab — Segment-Stage Randomization, GCG and Net Effect

CRM experiment: segment-stage randomization holds SRM at p=0.266, GCG uplift reaches +0.9968 purchases per user, and the net effect is +50.5 per 1,000 sends once unsubscribes are priced in.

Pythonpandas / NumPy +5

Experiments

Data Analyst Telegram Bot

A Telegram bot for the analyst without BI: a raw CSV export becomes p-value, lift and 95% CI in 30 seconds — 12 commands, history and HTML export.

Pythonaiogram +6
View Project

Repo is private — available on request

Analytics

Delivery Control Tower

A 550,710-row day × city × channel × category aggregate: DuckDB star schema, rolling-origin order forecast, delivery bottlenecks, 14 window SQL queries and an offline dashboard for three roles.

pythonsql +2

Analytics Real data

GMV Drop RCA — root cause on real data

An injected −10% GMV drop on real UCI Online Retail II data: the metric tree attributes 56.2% of the named drop to UK decile-1 and the full attribution reconciles to £0.00.

Pythonpandas +6

Analytics

Classifieds liquidity — a measurability audit

A synthetic classifieds marketplace with a planted answer key: the sell-through proxy misses by 21.4%, an EM correction brings every category inside 3 pp, and paid visibility fails its holdout.

Pythonpandas +5

Analytics

RAG Evaluation Harness — retrieval and generation metrics

RAG pipeline with an offline harness: recall@5 and MRR = 1.00 on 20 questions, correctness 0.37, 0.00 on retrieval-miss control set. TF-IDF, no API keys; faithfulness ≡1.00 — an extractive invariant.

Pythonscikit-learn +4

Analytics

LinkedIn Content Analytics

Analytics on my own LinkedIn posts: one parser, four renderers. Formats are compared with confidence intervals — and noise is called noise, not a ranking.

Pythonopenpyxl +3
View Project

Repo is private — available on request

Analytics

Promo Margin Lab — what a promo rouble actually earns

Promo returns +68.5 m RUB of revenue but −24.4 m RUB of profit: 97.9% of waves lose money at a 1.0–19.5% breakeven vs 25.4% actual, and the optimiser earns +231 496 ₽ vs +136 648 ₽ for top-15%.

Pythonpandas +6

Analytics

Product A/B & Funnel Analytics — Conversion versus Retention

A 12 000 → 9 623 → 3 384 funnel and A/B on 2 552 users: onboarding lifts activation → paid by 19.59% (p=0.000946), verdict SHIP; at an equal step, conversion adds 10.00% to LTV, retention 8.65%.

Pythonpandas / NumPy +5

Product

TaskFlow — PostHog Product Analytics Pipeline

Onboarding test on a seeded event stream: completion 55.9% → 70.8% (+26.6%), χ² = 40.10, p < 0.0001 at SRM p = 0.90; 6.3% of completed signups reach a paid upgrade.

PythonPostHog +5
View Project

Repo is private — available on request

Product

Product Analytics Dashboard (Streamlit)

A product analytics dashboard on a synthetic SaaS dataset (8,000 users): AARRR funnel, cohort retention, revenue (MRR, ARPU, churn) and segmentation — 5 Streamlit pages.

PythonStreamlit +1
View Project

Repo is private — available on request

Engineering

ClickHouse — ten SQL cases on 50M rows

Nine SQL cases on 50 million events plus an optimisation that leaves the query text untouched: a projection reads a key range instead of a full scan, and seven DuckDB twins cross-check every case.

ClickHouseDuckDB +5

Engineering Real data

OSS catalog — 47 projects from one source

A static catalog of 47 open repositories: GitHub metadata is synced by a script into frontmatter and the build reads only that — 15 fields per project, 26 tests and an idempotent render.

AstroTypeScript +5