A curious PM's experiments with AI, analytics, and building things.
Want to try it? Join the waitlistJourney analytics requires sessionization, computed dimensions, segments, and smart aggregation - all at query time. Here's how to build a 6-layer SQL architecture to make it work.
A cookie on a laptop, a device ID on a phone, a CRM record in-store, a phone number at the call center - all the same person. How do you stitch that into one coherent journey? Here's how we built cross-device identity resolution for our DIY journey analytics platform.
When your data lives in separate tables with different schemas, how do you combine it all into one unified set of data for analysis? Here's how to build a 'Data Group' layer using ClickHouse materialized views.
A deep dive into how to use Airbyte to sync data from a data warehouse into ClickHouse - covering CDC, full refresh, and append-only sync modes, the tradeoffs of each, and how to build an API layer on top to keep things simple.
Before choosing any technology, I needed to establish what I would and would not build myself - and why that matters.
What if one PM with AI coding tools could build what usually takes hundreds of engineers? I'm finding out - and sharing everything I learn along the way.
I'm letting a few people try what I've created for free.
Join the waitlist