5 posts
#analytics
Analytics posts for small teams. Building a privacy-respecting stack after GA4, ETL with dbt for a data team of one to three people, and choosing between Snowflake, ClickHouse and DuckDB for real-time analytics. Mobile teams get a guide to moving from Firebase Analytics to AppMetrica, and there is a short piece on funnel charts that lead to decisions instead of decorating a dashboard.
Start with the privacy-respecting stack if you are rethinking web analytics, or with the dbt post if ad-hoc SQL has piled up. Read the warehouse comparison before you sign a long contract.
Related service: Web application development
(01)
Building a privacy-respecting analytics stack post-GA4
GA4 dominated by default, but GDPR/ePrivacy compliance, cookie consent friction, and customer trust have driven many teams to alternatives. Plausible, Umami, PostHog, self-hosted — what actually works in 2026.
→
(02)
ETL with dbt for a small data team — practical patterns
A 1-3 person data team can build maintainable analytics with dbt and avoid the typical mess of ad-hoc SQL. Practical patterns for project structure, testing, documentation, and CI without over-engineering.
→
(03)
Real-time analytics for SMBs — Snowflake vs ClickHouse vs DuckDB
Snowflake costs $50K+ per year and overkills most SMBs. ClickHouse is free and powerful but requires operations expertise. DuckDB is shockingly fast for the right scale. Practical comparison for SMB analytics in 2026.
→
(04)
AppMetrica vs Firebase Analytics: migrating mobile app analytics
By mid-2026 Firebase Analytics in Russia is unreliable: events stop coming, remote config drops. Here is what to switch to and how to migrate without losing data.
→
(05)
Funnel diagrams that actually help
Most funnel charts in dashboards are decoration. Three rules to make a funnel that triggers action.
→