Launch HN: June (YC W21) – Two-click analytics reports on top of Segment data

It's not an argument but as the companies scale, I see that most of them often feel the need of switching to (or adding an extra layer) a BI tool for flexibility so I hope to see the same trend among the data analysts. It's now trivial to ingest the customer event data into your data warehouse thanks to Segment Warehouse, open-source tools such as Snowplow, and even GA4 which provides a free way to ingest the data into your BigQuery project.

The open-source ELT tools such as dbt can be used to build up similar models for product analytics using SQL. That way, you can use the default definition of `Power Users` out of the box and customize it later on if you need to join different datasets in order to calculate the same metrics as you grow.

I’m actually working on a similar product that works on top of the data warehouse using SQL, you model your event data (or just use integrations) and run ad-hoc funnel & retention queries but I must admit that the onboarding process is not seamless as yours. :)

On the suggested events that’s also something we’ve been looking in. Segment defined their spec, which is a standard naming convention for events and we were thinking about building on top of it

>Literally spent days on Amplitude trying to get out a useful chart instead of working on my product, now June.so fixes this.

This is a very compelling pull quote considering the value of your time as a product builder.

I was one of those guys thinking Amplitude was all that I needed. By trying your tool, I realized that indeed analytics weren't supposed to be that hard to setup.