← all posts

Data

Analytics, tracking, metrics, dashboards

Dashboard Design for Startups: Why 3 Dashboards Beat 30 (and How AI Builds Them in Minutes)

Tutorials Data

A practical guide to dashboard design for startups: executive, product, and engineering. Concrete metrics, SQL queries, and prompts for generating dashboards in Metabase and Grafana.

SQL for Product Managers: 7 Cohort Queries That AI Writes Better Than an Analyst

Tutorials Data

7 SQL queries for cohort analysis: retention, revenue cohorts, activation, churn prediction. Ready-made prompts for AI generation. Copy and run.

Magic Number: How to Find the Action That Retains Users

Tutorials Data

Methodology for finding a product's magic number: cohort analysis in SQL, AI correlation of user actions with 30-day retention, A/B test validation. Ready-to-use queries and prompts.

Event Taxonomy from Scratch: AI-Generated Tracking Plan in 1 Hour

Tutorials Data

How to build an event taxonomy for a SaaS product with AI: naming conventions, taxonomy structure, prompts for generating 30 events, and a ready-to-use tracking plan.